Welcome to JDBTools

Description

This program converts, compares, merges, normalizes, and refactors data to and from disparate sources (CSV, Excel, and any JDBC/ODBC database) for use in a Java program.

System Requirements

Java SE 5

ODBC

To use ODBC in the Mac OS X, install the ODBC driver in the Application/Utilitles/ODBC Administrator application.

To use ODBC in Windows XP, run the Data Sources (ODBC) in Administrative Tools. If you can't find it, go to start and run. Type odbcad32.exe and press enter. Press add, select the driver that you want and which database, excel file, or text file to use. For the data source name, you need to remember that so you can use it in the program.

The driver for ODBC is sun.jdbc.odbc.JdbcOdbcDriver.

The connection string is jdbc:odbc:YourDataSourceNameInODBC.

Planning

This project is still in the planning stage. I will have a beta within a month or two.

Program Files

Download here (code experiment so far, do not use for production!)