Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Administering: Data Integrator Bulk Loader Properties
 

Classic Java CAPS

Managing Java CAPS Users

Using LDAP with Java CAPS

Administering the Sun Business Process Manager Database

Using the Sun Business Process Manager Worklist Manager for User Activities

Maintaining Sun Master Indexes (Repository)

Working With the EDM for Sun Master Patient Index

Working With the EDM for Sun Master Index

Java EE Based Components

Maintaining Sun Master Indexes

Analyzing and Cleansing Data for Sun Master Index

Loading the Initial Data Set for a Sun Master Index

Related Topics

Initial Bulk Match and Load Overview

Using the Initial Bulk Match and Load Tool With Sun Master Index (Repository)

Initial Bulk Match and Load Process Overview

Data Preparation, Matching, and Loading Procedure Overview

Distributed Processing

About the Bulk Match Process

About the Bulk Load Process

About the Cluster Synchronizer

Required Format for Flat Data Files

Generating the Initial Bulk Match and Load Tool

To Generate the Initial Bulk Match and Load Tool

Configuring the Environment

To Configure the Environment

Creating the Cluster Synchronizer Database

To Create the Cluster Synchronization Tables

Configuring the Initial Bulk Match and Load Tool

Configuring the Initial Bulk Match and Load Tool Processing

Configuring Initial Bulk Match and Load Tool Logging

Initial Bulk Match and Load Tool Configuration Properties

Initial Bulk Match and Load Tool Logging Properties

Performing a Match Analysis

Running the Bulk Matcher in Analysis Mode

Reviewing the Match Analysis Results

Reconfiguring the Matching Logic

Performing the Bulk Match

To Perform the Bulk Match

Running the Bulk Match and Bulk Load in One Step (SQL*Loader Only)

To Run the Bulk Match and Bulk Load in One Step

Loading the Matched Data Into the Master Index Database

Loading Matched Data Using SQL*Loader

Loading Matched Data Using the Data Integrator Wizard Bulk Loader

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

Data Integrator Bulk Loader Properties

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

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.