Siebel Connector for Oracle Applications > Developer Procedures >

Understanding the Database Adapter

The Database (DB) Adapter is a Siebel business service that can be used to construct and execute SQL statements on an external database. As a SQL execution module, the Adapter is driven by a SQL integration object.

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

Similar to the Siebel Integration Manager, the DB Adapter is used to move data to or from an external database. The DB Adapter dynamically creates a 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 DB Adapter executes the SQL statements against the external Oracle 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.

NOTE:  The Database Adapter is also known as the EAI SQL Adapter.