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 then select the DDL (.sql, .ddl) file which exported from SQL Developer. Click on Next button.

See How to create DB View and export DDL file in SQL Developer

In next window select Data Source Name and Finish the wizard.

New table will be created and will available in the Siebel Tools/ Table. If you see in Table there is column name Alias which will contain the DB view name and if you expand and click on Columns and find the Alias column under that system will map the sql query column names or Alias defined by you. One last system find the column which will you make as Id column. For that select the row and find column "System Field Mapping" and from drop down select "Id". All done. Now you simple create the Business Component on this table and use.

About the New Imported Table Definition:

After the table definition is imported using the External Table Schema Import Wizard, the external table and the external column names are generated.

The external table name is stored in the Table object's Alias property. This external table name consists of the following:

An EX prefix (for external table)

A three-digit batch code specified in the External Table Schema Import Wizard

An automatically generated seven-digit number

An example of the Table name is:

EX_ABC_0000001

The external column name is stored in the Column child object's Alias property. An X is added as the prefix and a four-digit number is added as the suffix for the external column name, for example:

X_ABC_0000001_0001

The Table object's Type property is set to External or External View (if a view was imported). This column denotes that the table resides outside of the Siebel database.

See How to create Business Component on External Table

Source: Oracle Docs

How to set Profile Attribute in Siebel Workflow

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set SessionAccessService in Business Service Name. Set SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.

How to call Popup Applet through Server Script in Siebel

Below is the script for calling popup applet through script: if (MethodName == "MethodName") { var oServiceAF = TheApplication().GetService("SLM Save List Service"); var inputPropAF = TheApplication().NewPropertySet(); var outputPropAF = TheApplication().NewPropertySet(); inputPropAF.SetProperty("Applet Name","ABC Popup Applet"); inputPropAF.SetProperty("Applet Mode","6"); inputPropAF.SetProperty("Applet Height", "700"); inputPropAF.SetProperty("Applet Width", "700"); oServiceAF.InvokeMethod("LoadPopupApplet", inputPropAF, outputPropAF) return (CancelOperation); } Applet Modes: 1=Base, 2=New, 3=Edit, 5=Query, 6=EditList

How to query or find record in Siebel Business Component

You can perform query operation on Business Component through Workflow, eScript with the help of Siebel Operation, Inbound E-mail Database Operations (method: FindRecord) or EAI Siebel Adapter (method: Query but you need to create Integration Objects). This Business Component can be Virtual Business Component (VBC), External Business Component (EBC) or generic Business Component (BC). See also: Difference Between Business Components and How to Create BC in Siebel through Object Wizard through Workflow with the help of Siebel Operation Create a workflow and provide the Business Object, business component should be in this BO for which you want to perform the query operation. From the Palettes window drag drop the Siebel Operation into workflow designer plane. Select the Siebel Operation box and open the properties window, provide the Business Component name from the drop down list and set Query in Operation field. You can set the search specification by two means either provide the fie

ITCanopy

Search This Blog