Using Oracle Database or Oracle EBS adapter for Oracle AQ (Advanced Queuing)

Here is a simple way to get started on Oracle AQ (Advanced Queuing) using the Oracle Database and/or Oracle E-Business Suite adapters. Here is what I did, right from defining my queue – one step at a time. Step 1 – Define the queue payload typeCREATE TYPE AQ_MESSAGE_TYPE AS OBJECT (ID VARCHAR2(30), INFO VARCHAR2(200)); Step…

1

Oracle EBS/DB Adapter Changes in Beta

As the Beta release for the Adapter pack approaches, here’s a list of changes in the Oracle EBS/DB Adapters so that you can prepare for it:   ·         Now support Windows Vista and Windows Server 2008   ·         Based on Oracle ODP.Net 11.1.0.7   Both adapters now _require_ ODP.Net 11.1.0.7 installed on the client as…

2

BizTalk Adapter Pack v2 CTP

BizTalk Adapter Pack team has released a CTP. This is  the 5th CTP and the first one available publicly for everyone to try.  The specific enhancements in this CTP  are mostly to the OracleDB adapter(included in the BAPv1) to which we added features like support for polling stored procedures and composite operations. We also added 64…

0

Enhancements to existing Oracle DB Adapter

For the next release of adapter pack, we are adding 2 new adapters — Oracle EBS and SQL. In addition, we are also enhancing support for the existing OracleDB adapter. We are planning to add support for the following:           –       UDTs           –       Table Types           –       Boolean types We would like to hear from you about any other specific…

0

I see errors (or warnings) in the event log when I disable the Receive Location, for small Polling Intervals (especially 0)

The Symptoms! Occasionally, you may see errors/warnings in the event log when you disable a WCF-Custom receive location which was configured to use the polling feature of the oracle adapter, especially if the polling interval is set to a low value. You would see these errors almost every time you disabled the location, if Polling Interval =…

6

BizTalk Oracle Adapter Vs WCF-based Oracle DB Adapter

The following is a list of key feature differences between the BizTalk Oracle adapter and the WCF-based Oracle DB adapter in the BizTalk Adapter Pack. 1.       LOB access: While the BizTalk Oracle adapter uses an ODBC driver to connect to Oracle DB, the WCF-based Oracle DB adapter uses Oracle’s ODP.NET 2.       Inbound processing: The BizTalk…

1

Streaming in OracleDB adapter

OracleDB adapter supports streaming of data for both inbound (wrt adapter) and outbound messages where it is possible to do so. Streaming can be at record level (in case of Insert operation), xml node level or xml node value level. For inbound messages, the adapter consumes it using Message.WriteBodyContents(XmlDictionaryWriter). In general for any operation the…

0

Getting LOB metadata from SAP, OracleDB and Siebel adapter using svcutil

The WCF based adapters that ship in the Biztalk Adapter Pack are WCF bindings. The svcutil tool can be used to get metadata for a LOB method using these bindings. The scheme in the URI determines which adapter binding is loaded by svcutil. However when using the svcutil tool, there is no easy way to specify…

2