Data Loading with Fast Loader

The Data_Source_id from the invocation source identifies the client load program, to ensure that multiple sources can load to the staging tables without creating data loading control issues for the engine. The Fast Loader does not allow multiple concurrent sessions from the same source, except with the session-specific solution that supports the lines upload. The data source program is responsible for the scheduling of a data load.

Note: You must use a unique Data Source ID for each load. The Data Source ID must not start with UICLIENT.

Data Loading using an Integration Server

If an Integration Server is used, the Integration Server uses its own built-in scheduling mechanism to load the staging tables and start the stored procedure. The Integration Server must be pre-configured to acquire the data from the source application and convert the data to be compatible with what is expected by Emptoris® Contract Management for the object type. In this case, the Fast Loader does not load the data into the staging tables. The external integration server application that starts the Fast Loader must provide the data that is to be loaded to the Emptoris Contract Management database. This data must be loaded to the appropriate staging tables of the Fast Loader.

Data Loading using the SQL Loader or DB2 LOAD utility

If there is no Integration Server to run these functions, a control file or a SQL file can be established for each affected Emptoris Contract Management object type. The control file and the SQL file control the data types and data elements that the system uses to maintain process results and errors that are associated with each Fast Loader job. The Fast Loader acts as a front-end SQL loader and uses the control file or the SQL file with the CSV source data file to load the data.
  • For the Oracle database, if an SQL Loader client is used, it uses the UNIX or Windows cron utility to call the shell script that in turn calls the SQL Loader utility that is provided by the database.
  • For the DB2 database, upload the data by using the DB2 LOAD utility.