- Creating the External Table Definition.
Import the external table definition into Siebel Tools using the External Table Schema Import Wizard.
This wizard creates a new Table object definition in the Siebel Repository, based upon the contents of a DDL (data definition language) file.
As may be appropriate, it is possible to import an external view definition rather than a table definition. When a view rather than a table definition is imported, it is necessary to amend the Type property of the created Table definition to reflect External View.
NOTE: You can import a database view definition as well as a table definition here. While no difference exists in the resulting Siebel Table object, if it references an external database view, only read access from the Siebel Application is supported.
- Mapping External Columns to Siebel System Fields.
Map columns in the external table or view to Siebel system fields.
NOTE: One column in the external table or view must be mapped to the Id system field by setting the System Field Mapping property for the column.
- Specifying the Data Source Object.
Configure the table definition and specify the data source object.
The data source object is a child object of the Table Object in Siebel Tools and may need to be exposed in the Object Explorer. See the Object Types Reference on the Siebel Bookshelf for information on exposing objects in the Object Explorer of Siebel Tools.
This object tells the object manager which data source to use to access the object.
- Specifying Any Optional Table Properties.
When the table is imported, specify additional table properties for the corresponding external table.
- Configuring the External Business Component.
Configure the EBC and specify the data source object. This data source name will be the same as that specified for the Table object.
- Specifying Run-Time Parameters.
After the data source definition is named in Siebel Tools, specify the run-time parameters by completing the following:
- Configure the data source definition.
- Update the server component definition.