Microsoft BizTalk Adapter Pack 2010 Samples

BizTalk Adapter Pack 2010 is a set of adapters built on top of the Microsoft Windows Communication Foundation (WCF) Line of Business (LOB) Adapter SDK. These adapters enable service-oriented programmatic access in order to interact with an external system. The samples on this page demonstrate some of the features of these adapters.

Let us know if you have a request for samples.

Download entire collections of samples, or browse and download individual samples:

• BizTalk Adapter Pack 2010: Oracle Database Adapter Samples
• BizTalk Adapter Pack 2010: Oracle E-Business Suite Adapter Samples
• BizTalk Adapter Pack 2010: SAP Adapter Samples
• BizTalk Adapter Pack 2010: Siebel Adapter Samples
• BizTalk Adapter Pack 2010: SQL Adapter Samples

Oracle Database Adapter

Adapter with BizTalk Server

• Invoke Functions with Record Types
  How to invoke a function with RECORD type parameters in an Oracle database.
• Invoke Functions with REF CURSORs
  How to invoke a function with REF CURSORs in an Oracle database.
• Invoke Functions in Oracle Database
  How to invoke a function in Oracle database.
• Invoking Overloaded Procedures
  How to invoke overloaded procedures in an Oracle database.
• Invoking Procedures with BFILE Parameters
  How to invoke procedures in an Oracle database that take BFILE parameters.
• Reading and Updating Large Data Type Columns
  How to perform operations on columns of large data types in an Oracle database.
• Polling an Oracle Database
  How to poll an Oracle database.
• Invoking SQL Statements Using SQLEXECUTE
  How to invoke a SQL statement in an Oracle database using a SQLEXECUTE operation.
• Performing a Select Operation
  How to perform a SELECT operation on an Oracle database.

Adapter with WCF service model

• Invoking Procedures with BFILE Parameters
  How to invoke procedures in an Oracle database that take BFILE parameters.
• Invoking Overloaded Procedures
  How to invoke overloaded procedures in an Oracle database.
• Polling an Oracle Database
  How to poll an Oracle database.
• Invoke Functions with Record Types
  How to invoke a function with RECORD type parameters in an Oracle database.
• Invoke Functions with REF CURSORs
  How to invoke a function with REF CURSORs in an Oracle database.
• Performing Operations in a Transaction
  How to perform operations on the Oracle database in a transaction using the WCF service model.

Adapter with WCF channel model

• Polling an Oracle Database
  How to poll an Oracle database.
  
• Streaming Data from an Oracle Database
  How to implement end-to-end streaming for Oracle large objects.
  
• Performing Operations in a Transaction
  How to perform operations on the Oracle database in a transaction using the WCF channel model.

Oracle E-Business Suite adapter

Adapter with BizTalk Server

• Invoking Concurrent Program
  How to invoke concurrent programs in Oracle E-Business Suite.
• Inserting Into Interface Tables
  How to perform an INSERT operation on interface tables in Oracle E-Business Suite.
• Using Message Content Property to Set Applications Context
  How to use message context properties to set applications context while performing operations on Oracle E-Business Suite.
• Performing Composite Operations
  How to perform composite operations on Oracle E-Business Suite.
• Receiving Incremental Notification
  How to receive incremental change notifications from Oracle E-Business Suite.
• Polling Using SELECT Statement
  How to poll Oracle E-Business Suite using a SELECT statement.
• Polling Using Stored Procedures
  How to poll Oracle E-Business Suite using a stored procedure.

Adapter with WCF service model

• Invoking Concurrent Program
  How to invoke concurrent programs in Oracle E-Business Suite.
• Performing an ExecuteReader Operation
  How to perform an ExecuteReader operation in Oracle E-Business Suite.
• Performing Operations on Interface Tables
  How to perform operations on interface tables in Oracle E-Business Suite.
• Performing Operations on Tables with Columns of Large Data Types
  How to perform operations on tables in Oracle E-Business Suite with large data type columns.
• Receiving Notifications
  How to receive change notifications from Oracle E-Business Suite.
• Polling Using a SELECT Statement
  How to poll Oracle E-Business Suite using a SELECT statement.
• Polling Using Stored Procedures
  How to poll Oracle E-Business Suite using a stored procedure.

Adapter with WCF channel model

• Inserting Into Interface Tables
  How to perform an INSERT operation on interface tables in Oracle E-Business Suite.
• Polling Using a SELECT Statement
  How to poll Oracle E-Business Suite using a SELECT statement.

SAP Adapter

Adapter with BizTalk Server

• Sending an IDOC to SAP Server
  How to send a strongly-typed IDOC to an SAP server.
• Receiving an IDOC from SAP Server
  How to receive a strongly-typed IDOC to an SAP server.
• Receiving an IDOC with Different Version Numbers from SAP Server
  How to receive IDOCs that have a version number less than SYSREL.
• Receiving Inbound Messages from SAP Server
  How to receive RFC Server calls (inbound messages) from SAP Server.
• Performing Operations in a Transaction
  How to perform operations on an SAP Server in a transaction.
• Invoking Transactional RFCS (tRFC) in an SAP Server
  How to invoke a tRFC in an SAP Server.

Adapter with WCF service model

• Performing BAPI Transactions
  How to perform operations on an SAP server in a transaction.
• Sending an IDOC to SAP Server
  How to send a weakly-typed IDOC to an SAP server.
• Receiving Inbound Messages from SAP Server
  How to receive RFC Server calls (inbound messages) from SAP Server.
• Invoking Transactional RFCS (tRFC) in an SAP Server
  How to invoke a tRFC in an SAP Server.

 Adapter with WCF channel model

• Receiving an IDOC from SAP Server
  How to receive a strongly-typed IDOC to an SAP server.
• Receiving Inbound Messages from SAP Server
  How to receive RFC Server calls (inbound messages) from an SAP server.

Using the Data Provider for SAP

• Invoke an RFC and Execute a Query on SAP Artifacts
  How to invoke an RFC on the SAP system and execute a query against SAP artifacts.

Siebel Adapter

Adapter with BizTalk Server

• Invoking Business Services
  How to invoke a business service in Siebel.
• Performing Operations on Business Components
  How to perform an insert operation on the Account business component in Siebel.
• Performing Operations on Business Services with Integration Objects
  How to invoke a business service in Siebel, which works with Integration Objects.
  Working with Business Components with Picklists
  How to insert a picklist value for the Account business component in Siebel.
• Working with Business Components with Multi-value Links
  How to invoke a business component in Siebel that has multi-value links.

Adapter with WCF service model

• Performing Operations Using the WCF Service Model
  How to use the Microsoft BizTalk Adapter 3.0 for Siebel eBusiness Applications to: (a) Perform Insert, Update, Delete, and Query operations on a Siebel business component (b) Invoke a method of a Siebel business service, and (c) Invoke a business component with multi-valued links.

Using the Data Provider for Siebel

• Invoke a Siebel Business Service and Query Siebel artifacts
  How to use the .NET Framework Data Provider for Siebel eBusiness Applications to perform operations on the Siebel system artifacts.

SQL adapter

Using the adapter with BizTalk Server

• Performing Composite Operations
  How to perform composite operations on SQL Server
• Receiving Notifications, Execute Stored Procedures, and Updating Tables
  How to receive notifications for changes to a table. If the notification is for an insert operation, execute a stored procedure to update the same table, and then update another table.
• Performing Operations on FILESTREAM Data
  How to perform operations on tables with FILESTREAM data.
• Receiving Incremental Notifications
  How to receive incremental query notifications from SQL Server.
• Performing Operations on Tables
  How to perform operations on tables in SQL Server.
• Invoking Stored Procedures
  How to invoke stored procedures in SQL Server.
• Receiving Strongly-typed Polling Messages
  How to receive strongly-typed polling messages from SQL Server.

Adapter with WCF service model

• Performing Operations on Tables
  How to perform operations on tables in SQL Server.
• Invoking the ExecuteReader Operation
  How to invoke ExecuteReader operation in SQL Server.
• Invoking Stored Procedures
  How to invoke stored procedures in SQL Server.
• Invoking Strongly-typed Stored Procedures
  How to invoke strongly-typed stored procedures in SQL Server.
• Receiving Notifications
  How to receive query notifications from SQL Server.
• Receiving Polling Messages
  How to receive polling messages from SQL Server.
• Receiving Strongly-typed Polling Messages
  How to receive strongly-typed polling messages from SQL Server.
• Performing Operations on FILESTREAM Data
  How to perform operations on tables with FILESTREAM data.
• Invoking Scalar Functions
  How to invoke scalar functions in SQL Server.
• Invoking Table-valued Functions
  How to invoke table-valued functions in SQL Server.

Adapter with WCF Channel Model

• Performing Operations on Tables
  How to perform operations on tables in SQL Server.
• Receiving Polling Messages
  How to receive polling messages from SQL Server.