Creating the External Table Definition from an ODBC Data Source

You can use the External Table Schema Import Wizard to create the table definition from an Open Database Connectivity (ODBC) data source.

To create the external table definition from an ODBC data source

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 ODBC 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 next dialog box, click Select Data Source.

   The Select Data Source dialog box appears.

6. Click the Machine Data Source tab, select the appropriate data source name, and then click OK.

7. In the Connect to Database Type dialog box, on the Login tab enter the database user ID and password, then click OK.

8. Enter the table owner for the data source, then click Next.

9. Select the tables to import, then click Next.

10. Confirm the entries, then click Finish.

    A Table object definition is added to the Siebel Repository for each external table selected.

Deploying a Table for an External Business Component

Once you import the table definition for your external business component, you must publish the table. Publishing a table for an external business component is no different than publishing any other table. See the section Publishing Tables in the Using Siebel Tools guide.