Export Data Through Siebel EIM
EIM Export - Overview:
2. It applies filter logic to select rows for exporting.
3. EIM updates EIM table rows to indicate the export status.
EIM Export Process:
If CLEAR INTERFACE TABLE in the configuration file is TRUE, all rows with the specified batch number are deleted. Otherwise, a
warning is issued if rows already exist with the specified batch number.
2. It uses export parameter expressions in the configuration file to locate and export table rows:
If EXPORT ALL ROWS is TRUE, ignore any EXPORT MATCHES parameters and export all rows.
If EXPORT ALL ROWS is FALSE, use EXPORT MATCHES parameters to locate specific rows.
For parent tables, EIM locates child table rows and exports them to their corresponding EIM tables.
Preparing the EIM Tables for Export Processing:
2. Issue a warning if the CLEAR INTERFACE TABLES parameter is set to FALSE in the EIM configuration file.
Checking Existing Rows Batch Numbers:
Preserved Column Values:
EIM Tables Not Supported for Export Processes:
Due to the complexity of the associated base tables, EIM export processes to the following interface tables are not supported:
1. EIM_ACCSRCPIDTL
2. EIM_CRSE_TSTRUN
3. EIM_IC_CALC
4. EIM_IC_PERF_HST
5. EIM_MDF
Editing the Configuration File for Export Processing:
Process Section:
To export data, you must define at least one process with TYPE = EXPORT.
Common Header and Process Section Parameters:
ATTACHMENT DIRECTORY:
CLEAR INTERFACE TABLE:
EXPORT ALL ROWS:
EXPORT MATCHES:
Exporting All Data Rows:
To export all rows from the tables that are mapped in an EIM table, set the EXPORT ALL ROWS parameter for the file to TRUE.
Example:
[Export Accounts]
TYPE = EXPORT
BATCH = 2
TABLE = EIM_ACCOUNT
EXPORT ALL ROWS = TRUE
EIM Export - Overview:
- To export data, EIM reads the data in the Siebel database tables and places the information in the appropriate EIM tables.
- The export process generally populates the applicable EIM table with a row for every Siebel base table row encountered.
- As a consequence, where EIM tables have mappings to multiple Siebel base tables, one export operation can generate multiple rows within the EIM table governing the rows encountered within the Siebel base tables.
- During its multiple passes through the EIM tables, EIM performs the following tasks:
2. It applies filter logic to select rows for exporting.
3. EIM updates EIM table rows to indicate the export status.
EIM Export Process:
- To export data to EIM tables, EIM performs the following steps:
If CLEAR INTERFACE TABLE in the configuration file is TRUE, all rows with the specified batch number are deleted. Otherwise, a
warning is issued if rows already exist with the specified batch number.
2. It uses export parameter expressions in the configuration file to locate and export table rows:
If EXPORT ALL ROWS is TRUE, ignore any EXPORT MATCHES parameters and export all rows.
If EXPORT ALL ROWS is FALSE, use EXPORT MATCHES parameters to locate specific rows.
For parent tables, EIM locates child table rows and exports them to their corresponding EIM tables.
Preparing the EIM Tables for Export Processing:
- Requires minimal preparation of the EIM tables.
- EIM inspects each EIM table involved in the process. If EIM finds a row whose IF_ROW_BATCH_NUM matches the batch number for this export process, it does one of the following:
2. Issue a warning if the CLEAR INTERFACE TABLES parameter is set to FALSE in the EIM configuration file.
Checking Existing Rows Batch Numbers:
- Before you initiate an export process, you should verify that rows do not contain an IF_ROW_BATCH_NUM matching the batch number you plan to use.
- If such rows do exist, you should either make sure that they do not contain data you need to preserve, or change the batch number for the export process.
- In each row that you are exporting, you may also want to set the IF_ROW_STAT column to FOR_EXPORT.
Preserved Column Values:
- The values for the LAST_UPD and CREATED columns in the EIM tables always contain the values for the LAST_UPD and CREATED columns from the target base table. For example, if you use the EIM_CONTACT interface table to export data from the S_CONTACT and S_ADDR_PER base tables, the values of the EIM_CONTACT.LAST_UPD and EIM_CONTACT.CREATED columns contain the data from the S_CONTACT.LAST_UPD and S_CONTACT.CREATED columns, respectively.
EIM Tables Not Supported for Export Processes:
Due to the complexity of the associated base tables, EIM export processes to the following interface tables are not supported:
1. EIM_ACCSRCPIDTL
2. EIM_CRSE_TSTRUN
3. EIM_IC_CALC
4. EIM_IC_PERF_HST
5. EIM_MDF
Editing the Configuration File for Export Processing:
Process Section:
To export data, you must define at least one process with TYPE = EXPORT.
Common Header and Process Section Parameters:
ATTACHMENT DIRECTORY:
- Default is SIEBEL_HOME\OUTPUT.
- Specifies the directory to be used for exporting attachments.
- Example: ATTACHMENT DIRECTORY = SIEBEL_HOME\OUTPUT (for Windows)
CLEAR INTERFACE TABLE:
- Specifies whether existing rows in the EIM table for the given batch number should be deleted.
- DEFAULT is TRUE.
EXPORT ALL ROWS:
- Specifies that all rows in the target base table and secondary tables are to be exported.
- DEFAULT is FALSE.
- Existing values in the EIM table and export matches’ expressions are ignored.
- For all columns to export using an EIM table (both data from the base table and data from related child tables), you need to make sure this parameter is set to TRUE (you may need to add this line if it does not currently exist) in the .IFB file.
- Example: EXPORT MATCHES = (NAME LIKE "GEN%")
EXPORT MATCHES:
- Specifies a WHERE clause expression for filtering base table rows.
- The value is in two parts: the Siebel EIM table name and the filter expression that goes against the target base table. The expression is applied against the target base table for the EIM table.
- The expression is a self-contained WHERE clause expression (without the WHERE) and should use only literal values or unqualified column names from the base table. There must also be a space separating the operator from the operand.
- The syntax to use with the EXPORT MATCHES parameter depends on whether the target base table is S_PARTY or not.
- Syntax for EXPORT MATCHES with S_PARTY as the Target Base Table.
Exporting All Data Rows:
To export all rows from the tables that are mapped in an EIM table, set the EXPORT ALL ROWS parameter for the file to TRUE.
Example:
[Export Accounts]
TYPE = EXPORT
BATCH = 2
TABLE = EIM_ACCOUNT
EXPORT ALL ROWS = TRUE