Skip to main content

Posts

Showing posts with the label Siebel Schema

How to create external table in Siebel Tools through Siebel Wizard

  What is external table in Siebel: "External Table" in the Siebel is used by " External Business Component (EBC)". EBC is used to access data in a database tables that does not belong Siebel schema or a different database or same database with different tables (using joins) or manipulation data using sql functions. Create External Table: You use Siebel Tools and the External Table Schema Import Wizard to import your external table definition into the Siebel Repository. Start Siebel Tools. Select File > New Object.... In the New Object Wizards applet, on the General tab, double-click External Table Schema Import. The External Table Schema Import Wizard appears, as shown in the following figure. Provide the appropriate project which new external table will belong to then select the type of schema source to "DDL/ Analyics" and 3 characters for the table name and click Next button. Now on next window select the database where you have created your DB view...