EBC in Siebel

• Get an DDL file for an external table
• Import DDL file in Siebel Tools
• Configure the newly created table
• Create an Business Component based on this table
• Configure this Business Component

After that you can use this BC just like any other Siebel BC with some limitations.

Now, I am going to discuss each step in detail.

::)  Getting a DDL File

This was the part that I had to struggle with in the start and in the end it turned out to be pretty simple task. Table I used in this example is oracle database table and you can get DDL of oracle database using Toad or SQL Developeran tool provided by oracle to interact with database.

I am mentioning the steps that we need to do to get Table DDL using SQL Developer

• Open SQL Developer and connect to database in which you table resides.
• Select the table for which you want to get DDL file
• On the right hand side you will see various tabs as shown below picture
  
• Click on SQL Tab
• You will see the DDL of that table in the window below
  
• copy and paste it in txt file and save that file