Creating the External Table Definition from a DDL File

You can use the External Table Schema Import Wizard to create the table definition from a data definition language (DDL) file.

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.

To create the external table definition from a DDL file

1. In Siebel Tools, check out and lock the appropriate project.

2. From the File menu, choose New Object to display the New Object Wizards dialog box.

3. Click the General tab, then double-click External Table Schema Import.

4. In the External Table Schema Import Wizard, specify the following values, then click Next:

   1. Choose the project with which the new Table object definition will be associated.

   2. Specify DDL/Analytics as the schema source type.

   3. Choose the three-digit group code for table name generation. For example, if you choose AXA, then the format of the table names generated will be:

      EX_AXA_00000001
      

5. In the Import External Schema - DDL dialog box, specify the following, then click Next:

   1. Specify the database where the external table resides. The value specified must correspond to the database used by the Siebel schema, for example, Oracle Server Enterprise Edition.

   2. Provide the full path for the location of the SQL/DDL file that contains the external table definition.

6. Confirm the entries, 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 2 through Step 6 for every external table definition you want to import.