Samples for the Oracle EBS adapter
Samples for Microsoft BizTalk Adapter for Oracle E-Business Suite are categorized into:
BizTalk Server samples
WCF service model samples
WCF channel model samples
Microsoft Office SharePoint Server samples
The samples are available at BizTalk Adapter Pack 2010: Oracle E-Business Suite adapter samples. The SQL scripts for creating the interface tables, concurrent programs, tables, and packages used in the samples are included.
Note
These samples need updated to the current version. Interested in updating them? If yes, then add your updated samples to our public GitHub repo at https://github.com/Microsoft/Integration.
The following list describes the samples.
BizTalk Server samples
| Sample Directory Name | Description |
|---|---|
| InterfaceTableInsert | Demonstrates how to insert records into an interface table in Oracle E-Business Suite using Oracle E-Business adapter. |
| ConcurrentProgram | Demonstrates how to invoke a concurrent program in Oracle E-Business Suite using the Oracle E-Business adapter. |
| RequestSet | Demonstrates how to invoke a request set in Oracle E-Business Suite using the Oracle E-Business adapter. |
| MsgContextProperty | Demonstrates how to use the message context properties exposed by the Oracle E-Business adapter to set application context to perform operations on artifacts in Oracle E-Business Suite using the Oracle E-Business adapter. |
| OracleEBS_CompositeOperation | Demonstrates how to perform composite operations in Oracle E-Business Suite using the Oracle E-Business adapter. |
| OracleNotifyIncremental | Demonstrates how to receive “incremental” query notification messages from Oracle using the Oracle E-Business adapter. |
| PollingUsingSelectStatement | Demonstrates how to configure a polling query using a SELECT statement and receive the results using the Oracle E-Business adapter. |
| PollingUsingStoredProc | Demonstrates how to configure a polling query using a stored procedure and receive the results using the Oracle E-Business adapter. |
WCF Service model Sasamplesmples
| Sample Directory Name | Description |
|---|---|
| ConcProgram_ServiceModel | Demonstrates how to invoke concurrent programs in Oracle E-Business Suite using the adapter. |
| ExecuteReader | Demonstrates how to invoke an ExecuteReader operation on Oracle E-Business Suite using the adapter. |
| Interface_Table_Ops | Demonstrates how to perform operations on interface tables in Oracle E-Business Suite using the adapter. |
| LargeDataTypes_ServiceModel | Demonstrates how to perform operations on tables with columns of large data types in Oracle E-Business Suite using the adapter. |
| Notification_ServiceModel | Demonstrates how to receive notifications from databases behind Oracle E-Business Suite using the adapter. |
| SelectPolling_ServiceModel | Demonstrates how to use a SELECT statement to poll an interface table in Oracle E-Business Suite using the adapter. |
| StoredProcPolling_ServiceModel | Demonstrates how to use a stored procedure to poll tables in Oracle E-Business Suite using the adapter. |
WCF Channel model samples
| Sample Directory Name | Description |
|---|---|
| InsertOperation | Demonstrates how to perform an Insert operation on an interface table in Oracle E-Business Suite using the adapter. |
| SelectPolling_ChannelModel | Demonstrates how to use a SELECT statement to poll an interface table in Oracle E-Business Suite using the adapter. |
Microsoft Office SharePoint Server samples
| Sample Directory Name | Description |
|---|---|
| MOSS_Sample | Demonstrates how to use the Oracle E-Business adapter to create a Windows Communication Foundation (WCF) service from Oracle E-Business Suite artifacts, and then use the WCF service to display data in Microsoft Office SharePoint Server using a Business Data List Web Part. |