Integration Platform Technologies: Siebel eBusiness Application Integration Volume ll > External Business Components > 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.

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, double-click External Table Schema Import.

    The External Table Schema Import Wizard appears, as shown in the following figure.

    Click for full size image
  5. In the External Table Schema Import Wizard, specify values as described below:
    • The project the new Table object definition will be associated with.
    • The database where the external table resides. The value specified should 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 will allow 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 need 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 24 contains the data type mappings you can use when importing table definitions.

Table 24.  Supported Data Type Mappings by Product
Supported Data Types
Siebel Data Type

MS SQL Server Data Types

int

Numeric with scale of 0

bigint

Numeric with scale of 0

smallint

Numeric with scale of 0

tinyint

Numeric with scale of 0

float

Numeric

real

Numeric

decimal

Numeric

money

Numeric

smallmoney

Numeric

bit

Character with a length of 1

char

Character

nchar

Character

varchar

Varchar

nvarchar

Varchar

text

Long

ntext

Long

datetime

Date Time

smalldatetime

Date Time

DB2 Universal Database Data Types

UINT

Numeric with scale of 0

BIGUINT

Numeric with scale of 0

SMALLUINT

Numeric with scale of 0

FLOAT

Numeric

REAL

Numeric

DECIMAL

Numeric

NUMERIC

Numeric

CHAR

Character

VARGRAPHIC

Varchar

LONG VARGRAPHIC

Long

DATE

Datetime

TIME

Datetime

TIMESTAMP

Datetime

Oracle Data Types

Number

Numeric

TIMESTAMP WITH TIME ZONE

Numeric

TIMESTAMP WITH LOCAL TIME ZONE

Numeric

Char

Character

Nchar

Character

varchar2

Varchar

nvarchar2

Varchar

Long

Long

date

Datetime

Siebel Analytics Data Types

Integer

Numeric with scale of 0

Smallint

Numeric with scale of 0

Tinyint

Numeric with scale of 0

Float

Numeric

Double

Numeric

Bit

Character (1)

Boolean

Character (1)

Char

Character

Varchar

Varchar

Longvarchar

Long

Datetime

Datetime

Date

Datetime

Time

Datetime

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

Table 25.  Unsupported Data Type Mappings by Product
Unsupported Data Types

MS SQL Server Data Types

timestamp

varbinary

binary

image

cursor

uniqueidentifier

DB2 Universal Database Data Types

CLOB

DBCLOB

BLOB

Oracle Data Types

TIMESTAMP

CLOB

NCLOB

BLOB

BFILE

ROWID

UROWID

RAW

LONG RAW

INTERVAL YEAR TO MONTH

INTERVAL DAY TO SECOND

Siebel Analytics Data Types

Timestamp

Varbinary

Longvarbinary

Binary

Object

Unknown

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.

Integration Platform Technologies: Siebel eBusiness Application Integration Volume ll