Loading Matched Data Using the Data Integrator Command-Line Bulk Loader

You can use the Data Integrator command-line Bulk Loader to load data into an Oracle, MySQL, or SQL Server database. Using the command-line tool does not require the use of NetBeans, but it does require that NetBeans be installed on the master loader machine.

To Load Matched Data Using the Data Integrator Bulk Loader

1. Complete the steps under Performing the Bulk Match.

2. In the master IBML Tool home directory, open genCollab.bat (or genCollab.sh for UNIX) and configure the properties described in Data Integrator Bulk Loader Properties.

3. Save and close the file.

4. In the master IBML Tool home directory, do one of the following:

   • On Windows, double-click genCollab.bat or type genCollab.bat from a command line.

   • On UNIX, type sh genCollab.sh at the command line.

     This generates a zip file in the IBML Tool home directory.

5. Extract the contents of etl-loader.zip to the current directory.

   This generates an ETL collaboration and creates a new directory, ETLloader, in the IBML Tool home directory.

6. In the master IBML Tool home directory, run cluster-truncate.sql against the master index database to clear the cluster synchronizer tables.

7. In the ETLloader/config directory, open logger.properties and modify any logging properties if needed.

8. In the ETLloader directory, do one of the following:

   • On Windows, double-click startLoad.bat or type startLoad.bat from a command line.

   • On UNIX, type sh startLoad.sh at the command line.

9. After the data is loaded, check the log files to ensure there were no errors during processing.