Siebel Connector for PeopleSoft > Database Adapter > Methods and Arguments >

Additional Information

This section provides additional information about the DB Adapter.

Generating SQL

The Database Adapter generates SQL statements based upon the integration object definitions in tools and data in the input object. The process generates multiple SQL statements, executes them, and joins the result set.

Starting at the root of the tree, the Adapter generates SQL for all children of a component type. For better performance, the Adapter may use an SQL OR clause to group these children together. (Because the maximum length of an SQL statement is limited by ODBC, the length of the SQL statements can be controlled by changing a parameter.)

The Database Adapter business service uses the ODBC API for all database access. With the algorithm outlined above, Database Adapter needs to be processing only one component at a time. All the joins will occur in memory.

The Database Adapter relies upon the ODBC API to cache the underlying ODBC cursors. The ODBC API will not perform connection pooling because it can only handle one open ODBC connection at a time. Database Adapter will cache ODBC connections, if necessary.

Handling Transactions

The Database Adapter does not perform any BeginTransaction or EndTransaction on the Siebel side of data flow transactions. It does perform BEGIN, COMMIT, and ROLLBACK transactions on PeopleSoft database through the ODBC API. The ODBC API provides interfaces to support manual transaction control.

Translating Data Types

The ODBC API, used by the DB Adapter, converts the generic data types specified in the tools to the corresponding ODBC data types. The SQL integration objects are expected to encode these ODBC data types as their External Data Type. The SQL wizard or PeopleSoft wizard (which generates these integration objects) is used to set this external data type. The wizard may query PeopleSoft metadata to obtain database data types such as NUMBER, VARCHAR2, and so on. Then, the ODBC API translates these application-specific data types into ODBC data types.

Passing Connection Parameters

The Database Adapter passes the following connection parameters to the ODBC API for its Connect method:

The Database Adapter looks for these parameters in the following locations:

The Adapter assumes that these parameters are passed to it by the caller. It will not explicitly retrieve these parameters.

Error Handling

The Database Adapter handles errors like other eAI external adapters. If an error occurs in the PeopleSoft database system, the error is reported by the underlying low-level ODBC layer. Regardless of the error type (database connectivity problem, invalid table/view/column names, and so on), the error from the ODBC layer is passed up the stack to the caller of the DB Adapter. You must define error handling logic using workflow exception steps in order to respond to an error condition.

Passing the PeopleSoft Operations Field to the DTE

Because PeopleSoft must be able to specify operations that will be carried out on Siebel business objects, each Integration Object must have a meta-operator field that can be filled in to specify the operation. The Field Type for the field is set to System (External). The Database Adapter does not use this field; it just passes the field to the Data Transformation Engine (DTE).


 Siebel Connector for PeopleSoft 
 Published: 18 April 2003