Integration Platform Technologies: Siebel Enterprise Application Integration > External Business Components > Process of Configuring External Business Components >

Creating the External Table Definition

You use Siebel Tools and the External Table Schema Import Wizard to import your external table definition into the Siebel Repository.

For more information about using Siebel Tools, see Using Siebel Tools on the Siebel Bookshelf.

This task is a step in Process of Configuring External Business Components.

To import the external table definition

1. Start Siebel Tools.
2. In Siebel Tools, check out and lock the appropriate project.
3. Select File > New Object....
4. In the New Object Wizards applet, on the General tab, double-click External Table Schema Import.

   The External Table Schema Import Wizard appears, as shown in the following figure.
5. In the External Table Schema Import Wizard, specify the following values:
   • The project the new Table object definition will be associated with.
   • The database where the external table resides. The value specified must correspond to the database platform used by the Siebel database.
   • The full path for the location of the SQL/DDL file that contains the external table definition.
   • Specify the three-digit batch code that allows grouping.
6. Click Next to confirm the entries, and then click Finish to import the DDL file.

   A Table object definition is added to the Siebel Repository, corresponding to the external table.

7. Repeat Step 3 through Step 6 for every external table definition you want to import.

About Data Type Mappings for Importing Table Definitions

When importing table definitions, certain data type mappings are supported for use with the Siebel application. Table 47 contains the data type mappings you can use when importing table definitions.

Table 48 contains the data types that are not supported for importing table definitions.

About the New Imported Table Definition

After the table definition is imported using the External Table Schema Import Wizard, the external table and the external column names are generated.

The external table name is stored in the Table object's Alias property. This external table name consists of the following:

• An EX prefix (for external table)
• A three-digit batch code specified in the External Table Schema Import Wizard
• An automatically generated seven-digit number

An example of the Table name is:

EX_ABC_0000001

The external column name is stored in the Column child object's Alias property. An X is added as the prefix and a four-digit number is added as the suffix for the external column name, for example:

X_ABC_0000001_0001

The Table object's Type property is set to External or External View (if a view was imported). This column denotes that the table resides outside of the Siebel database.