Extract Process

Extract process involves extracting CM system data based on the rules defined in a parameter file and packaging it in a binary file - blueprint. This file can then be used as an input source by the data upload process.

Oracle and MS SQL Server are both supported. The example below utilizes the oracle database platform to illustrate the extract and upload process. MS SQL Server requires 2 different ODBC connections for the extract process and upload process. A description of the ODBC setup is in the extract and upload bat files provided as samples.

OraSdBp.exe, included in this package, is the extract utility that reads an input parameter file for the list of Oracle database tables, extracts data from these tables and compresses into a binary file (blueprint).

A sample extract parameter file extract_​cmsystbls.lst is included in this package to provide the implementers a starting point. This parameter file, as can be seen, defines rules for the tool to extract CM data based on their key definition. However, in some cases, CM data may be stored on 'CI' rows. The column user_​exit_​pgm on CI_​MD_​PRG_​COM table is one such case. For cases like these, the implementers can choose to change the extraction rules in this file to match their requirements.

To extract your data, make a copy of extract_​cmsystbls.lst file and edit it to match your requirements. Execute the extract process from a Command-window and provide it with the required parameter when prompted.

The data in input parameter must match the following format:

CI_​ALG_​TYPE_​L;LANGUAGE_​CD = 'ENG';VERSION

Where, the first field stores the table name, second field stores the selection criteria (where clause for selecting data) and the third field stores the list of column that should be ignored during extraction. The character semi-colon is used as the field separator. If there are multiple columns that need to be ignored (not included in the data being extracted), comma can be used in the third field as the separator.

OraSdBp accepts the following parameters:

This option will list all the accepted parameters with a brief description.