ITCanopy

What is Business Component (BC): A business component defines a logical entity that organizes columns from one or more tables into a single entity. It provides a foundation that controls how Siebel CRM chooses, inserts, and updates data in underlying tables. This data is typically specific to a functional area, such as a product, a contact, or an account. An applet references a business component. It does not directly reference the tables. This configuration allows you to reference data according to functional area. It might also separate work that a developer performs from work that an administrator performs. Types of Business Components: a. Business Component b. External Business Component: The external business component (EBC) feature provides a way to access data that resides in a non-Siebel table or view, using a Siebel business component.  See How to create DB View and export DDL file in SQL Developer See How to create External Table in Siebel Tools on SQL View c. Virtual Bus...

  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...