Siebel Connector for PeopleSoft >

Database Adapter

The Database Adapter is a Siebel business service that can be used to exchange information with PeopleSoft through its database interface. It accesses PeopleSoft's database interface by dynamically generating an SQL statement (or set of SQL statements), based upon data in an Integration Object and the invoked method which indicates whether the SQL statement is an INSERT, UPDATE, DELETE, or SELECT. The Adapter executes the SQL statements against the external PeopleSoft data store. For INSERT, UPDATE, DELETE, a count or error is returned. In the case of SELECT, the retrieved data values are returned and inserted into a second Integration Object.

Like other Siebel business services, the Database Adapter simplifies moving and converting data between Siebel eBusiness Applications and external applications.

Similar to the Siebel Integration Manager, the Database Adapter is used to move data to or from an external database. The Adapter dynamically creates an SQL statement (or set of SQL statements), based upon data in an Integration Object and the invoked method, which indicates whether the SQL statement is an INSERT, UPDATE, DELETE, or SELECT. The Database Adapter executes the SQL statements against the external PeopleSoft data store. For INSERT, UPDATE, DELETE, a count or error is returned. In the case of SELECT, the retrieved data values are returned and inserted into a second Integration Object.


 Siebel Connector for PeopleSoft 
 Published: 18 April 2003