|
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
- Start Siebel Tools.
- In Siebel Tools, check out and lock the appropriate project.
- Select File > New Object....
- 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.
- 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.
- 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.
- 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
|
|
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
|
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.
| 
