The Data Integrator collaboration is generated by a file that includes configurable properties you need to define. The file is named genCollab.bat for Windows and genCollab.sh for UNIX. It is located in the directory where you extracted the IBML Tool files on the master processor. The following table lists and describes the default properties for the file.
If you get a usage error when running the Bulk Loader after configuring the properties below, remove the double-quotes from around the paths and filenames (but not from the delimiters).
Property Name |
Description |
---|---|
NetBeans and Java Properties |
|
NB_HOME |
The absolute path to the NetBeans home directory on the master processor. |
JAVAPATH |
The absolute path to the bin directory in the Java installation; for example, C:\\Java\jre1.5.0_11\bin. |
DB_DRIVER_PATH |
The absolute path to the database driver for the database platform of the master index database. |
DB_DRIVER_NAME |
The name of the database driver in the path specified above; for example, ojdbc14.jar. |
Source Data Properties |
|
SOURCE_LOC |
The absolute path to the data files to be loaded into the master index database. These are located in the masterindex folder in the working directory you created for the Bulk Matcher. |
FIELD_DELIMITER |
The character that separates the fields in the master data image files. By default, fields are delimited by a pipe character (|). |
RECORD_DELIMITER |
The characters that separate the records in the master data image files. By default, the records are delimited by three dollar signs ($$$). |
Target Database Properties |
|
TARGET_DB_TYPE |
The database platform used for the master index database. Specify 1 for Oracle, 2 for MySQL, or 3 for SQL Server. |
TARGET_LOC |
The name or IP address of the server on which the master index database resides. |
TARGET_PORT |
The port number on which the master index database is listening. The default port is 1521 for Oracle, 1433 for SQL Server, and 3306 for MySQL. |
TARGET_ID |
The SID or database name of the master index database. |
TARGET_SCHEMA |
The name of the database schema that defines the tables, fields, and relationships for the master index database. The default schema for SQL Server databases is “dbo”; for Oracle, the default is the same as the SID name of the database. |
TARGET_CATALOG |
The name of the database catalog containing the master index database metadata. This property can be left empty. |
TARGET_LOGIN |
The login ID of the user with administrator abilities for the master index database. |
TARGET_PW |
The password for the above login ID. |