Siebel EBC Configuration

Popularity:

The full name of EBC is external business component. It is a data integration method that can be used with external ODBC data sources. It imports tables & view sechma from other databases into tools repository in DDL mode, which can be used as the base table of BC like normal tables, however, the data source can be specified as a non-Siebel Application System Data Source on BC.

Configuration process:

• Export the table or view structure from any data source in DDL format
• Use tools to import DDL
• Create BC and UI
• Create a data source

Export DDL Structure

Use PL/SQL develop or other tools to export DDL schema definitions (note)

(1) The row_id field must be included in the newly created view. Otherwise, the "service object creation service component error" is reported on the interface after the Siebel application is set up ".

(2) it is best to give each column an alias to ensure that the same name is not required. Note that after importing Siebel, the table column must be consistent with the alias.

(3) Note that if you create a view,Do not forget to grant the sse_role permission to the newly created view.Otherwise, an error occurs when preparing SQL statements"

 

Import to Siebel Repository

1. Create in Wizard

 

 

 

 

 

 

 

2. Select the DDL Mode

 

 

 

 

 

 

3. Note that the runtime data source here is optional.

4. Note that the alias must be consistent with the alias in the created view.

 

Create BC and UI

Use the imported table as the base table, create field, create BC, applet, view, screen, etc.

It is worth noting that the EBC created here can establish a join relationship with other tables, and the base table ex _ *** of EBC can also be used by other BC as a join table to establish a join.

 

Configure Data Source

The default data source actually points to the ODBC connection of the Siebel system. For example, if we create a view in the Siebel database, we can ignore it all.

However, data source can be configured as an external data source. In this case, you must manually create a data source in the application configuration file. For example, if the field service application is usedProgramThe configuration file is {siebel_root}/siebsrvr/bin/SFs. cfg.

If you want to connect to an ORACLE data source, you only need to copy the [serverdatasrc] region, rename it [remoteserverdatasrc], and modify the connectionstring

Add the following in the datasources area:

 

Specify Data Source

You need to tell Siebel when to use the data source. There are two places in the system that you can set and use each of them.

1. Data Source attribute on BC. You can write remoteserverdatasrc here.

2. Create a New remoteserverdatasrc item in the data source subitem of the External table.

Note: If this parameter is specified on the table, the data source will be used for all BC instances that use this table.

 

Configure data source user authentication

1. Static configuration method: You can add dsusername and dspassword parameters to the configuration file.

2. dynamic configuration method:

In the Siebel application system, choose management> server configuration> enterprise> configuration information configuration.

Similar to the configuration in the cfg file, copy "serverdatasrc" and rename it "remoteserverdatasrc]

Modify configuration parameters: Similarly, if it is an Oracle database, you only need to set the user name and password.

Dsusername = Siebel; dspassword = Siebel

Finally, configure the component parameters in the component definition that requires this external data source.

Om-named data source name, which is separated by commas (,). The custom data source name is appended to the parameter.

 

Finally, synchronize this component and restart Siebel server.