Edit

Get started with the Oracle Database adapter

  • Article

This section provides an overview of the adapter, prerequisites, and topics for users who are new to Microsoft BizTalk Adapter Pack. It discusses the features of Microsoft BizTalk Adapter for Oracle Database and the different operations that can be performed on the Oracle database using the adapter.

What is an adapter? An adapter is a software component that enables you to send and receive messages to and from a line-of-business (LOB) system. The primary design goal of adapters is to facilitate the exchange of business documents between trading partners. Because each business system can adhere to specific document formats and protocols, the adapter uses a delivery mechanism that conforms to commonly recognized standards and protocols.

The adapters can be divided into two broad categories:

  • LOB adapters. Such adapters provide a service-oriented programming model to access LOB systems—for example, adapters for SAP or Siebel.

  • Data adapters. Such adapters provide a service-oriented programming model to access databases—for example, an adapter for the Oracle database or SQL Server.

    There are five adapters in the BizTalk Adapter Pack:

  • Microsoft BizTalk Adapter for SQL Server (the SQL adapter)

  • Microsoft BizTalk Adapter for Oracle E-Business Suite (the Oracle E-Business adapter)

  • Microsoft BizTalk Adapter for Oracle Database (the Oracle Database adapter)

  • Microsoft BizTalk Adapter for mySAP Business Suite (the SAP adapter), including .NET Framework Data Provider for mySAP Business Suite (Data Provider for SAP)

  • Microsoft BizTalk Adapter for Siebel eBusiness Applications (the Siebel adapter), including .NET Framework Data Provider for Siebel eBusiness Applications (Data Provider for Siebel)

    Note

    The Siebel adapter is not available for 64-bit platforms.

    If you do not already know how you want to use the Oracle Database adapter at your company, it is recommended that you start by exploring the features and functionality of the adapter described in Understanding the BizTalk Adapter for Oracle Database.