Siebel Enterprise Integration Manager Administration Guide > Exporting Data > Editing the Configuration File for Export Processing >

Parameters Used for Exports in Both the Header and Process Sections


Table 15 describes the parameters that can appear in either the header section or a process section, and are specific to an export process. For generic parameters that can be used in all EIM processes, see Process Section Parameters Generic to All EIM Processes.

Table 15.  Export Process Parameters for the EIM Configuration File - Header and Process Sections
Parameter
Description

ATTACHMENT DIRECTORY

(Default is SIEBEL_HOME\OUTPUT) Specifies the directory to be used for exporting attachments. Before specifying a directory, make sure the directory exists on a Siebel Server machine and you have read and write access to it. Example:

ATTACHMENT DIRECTORY = SIEBEL_HOME\OUTPUT

If the export of an attachment fails, the export process continues and EIM writes a message in the trace file.

CLEAR INTERFACE TABLE

Specifies whether existing rows in the EIM table for the given batch number should be deleted. The default value is TRUE.

EXPORT ALL ROWS

Specifies that all rows in the target base table and secondary tables are to be exported. The default value 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.

Note: Rows from child tables of related child tables are not exported until they have been mapped.

EXPORT MATCHES

WHERE clause fragment. Example:

EXPORT MATCHES = (NAME LIKE "GEN%")

For more information on the EXPORT MATCHES parameter, see EXPORT MATCHES Parameter.

EXPORT MATCHES Parameter

The EXPORT MATCHES parameter 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.

NOTE:  Complex SQL WHERE clauses like subqueries are not supported.

EXPORT MATCHES can be used only against a target base table, or against a non-target base table that is an extension table of S_PARTY when the target table is S_PARTY. For more information, see To check whether a base table is of Siebel extension type.

The syntax to use with the EXPORT MATCHES parameter depends on whether the target base table is S_PARTY or not.

NOTE:  The column names included in the criteria (that is, in "(...criteria...)" below) must be columns from the target base table or the table that is specified for the EXPORT MATCHES parameter.

Syntax for EXPORT MATCHES with S_PARTY as the Target Base Table

The syntax listed below is for use with the EXPORT MATCHES parameter if the EIM table's target table is S_PARTY.

Allowed syntax includes the following:

EXPORT MATCHES = S_PARTY, (...criteria...)

EXPORT MATCHES = <non-target base table name of Siebel Extension type>, (...criteria...)

NOTE:  When using the EXPORT MATCHES parameter against a non-target base table, you must still include the target table in the export.

The following syntax is not allowed:

EXPORT MATCHES = <EIM table name>, (...criteria...)

EXPORT MATCHES = (...criteria...)

Syntax for EXPORT MATCHES with Target Base Tables Other Than S_PARTY

The syntax listed below is for use with the EXPORT MATCHES parameter if the EIM table's target table is not S_PARTY.

Allowed syntax includes the following:

EXPORT MATCHES = <EIM table name>, (...criteria...)

EXPORT MATCHES = <target base table name>, (...criteria...)

EXPORT MATCHES = (...criteria...)

The following syntax is not allowed:

EXPORT MATCHES = <non-target base table name>, (...criteria...)

To check whether a base table is of Siebel extension type

  1. In Siebel Tools, navigate to the Table control and query a table name.

Check the Type property value. If the Type property value contains 'Extension (Siebel),' then the table is a Siebel extension type table.

Siebel Enterprise Integration Manager Administration Guide