test

Loading the Initial Data Set for a Sun Master Index

Data Integrator Bulk Loader Properties

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.

Tip –

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).

Table 7 Data Integrator Bulk Loader Properties

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.