White Paper for External Business Component (SQL Server 2005)
1. What is External BC and Its use?
External Business Component
represents the Database Table structure of the other application into Siebel
Application Architecture. External Business Component (EBC) is another way of
integrating Siebel with External Applications. It is another tool available at
your disposal to achieve integration.
EBC is one of the easiest ways to
integrate your Siebel Application with External Database. Integration steps can
easily remember on the finger tips.
There are three main steps to
integrate your Siebel apps with External DB.
1) Get
the DDL File (Not mandatory) you can
connect to database and import the table schema.
2) Import
the Table Structure into Siebel Tools with (External
Table Schema Import)
3) Create
the New Data source in configuration
file and Profile Parameter.
Steps:
- Get
the DDL file containing the create table query of your external database
table.
- Save
this to text file and (Customers.txt)
- Import
the Table structure into Siebel Tools.
Click Ok
Enter the Details as Mentioned in the Image
Select the details as above.
Click the finish button
Now create a Data Source for your table to point to External
System.
Now Map the Siebel System ID field to External System ID
field to maintain the integrity issue.
(Note: Considering all of you know how to create a BO, BC,
Applet and View)
1) Now Create the Business Component on this Table our
normal BC using the wizard.
2) Create the Applet On Newly Created Business Component.
3) Create a New BO and add the BC to it and configure the
new View on this BO and applet.
%Siebel Installation Directory% BIN/ENU/uagent.cfg
and add following section.
1) Edit the uagent.cfg file to define your external Data Source
2) Now configure your Server Data Source to define it.
3) Login to Siebel Server with SADMIN/SADMIN
5) Query in a Subsystem name field = InfraDatasources
6) Copy record by Ctrl + B
7) Enter the Following Details
Enter the New Record Details As
follow
TestDS
|
TestDS
|
TestDS
|
TestDS
|
Change the
following parameter values.
DSConnectString
|
TestDS
|
DSDLLName
|
Sscdms80.dll
|
DSPassword
|
[sql server password]
|
DSTableOwner
|
Dbo
|
DSUserName
|
[Sql server user name]
|
Click on Advance
Button and Query
|
DSSQLStyle
|
MSSqlServer
|
Now Goto following View
Step1
Step2
Now Click
the Synchronize button.
Restart
the Siebel Server.
Open
Database Connectivity Configuration with SQL Server
Step1
Step2
Step3
Step4
Step5
Now finally Test all the changes.
