Configure dynamic ports in the Oracle Database Adapter

In BizTalk Server, you can configure dynamic ports for a WCF-Custom adapter. Because the Oracle Database adapter is a WCF-based adapter, you can dynamically configure a port for the Oracle Database adapter by using message context properties.

For the Oracle Database adapter, the URI, action, and binding may be determined from a property on an incoming message, and then specified in the Expression shape, as shown in the following example:

Request2=Request1;  
Request2(WCF.Action)="http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/ACCOUNTACTIVITY/Select";  
Request2(WCF.BindingType)="oracleDBBinding";  
Request2(WCF.UserName)="SCOTT";  
Request2(WCF.Password)="TIGER";  
SendPort(Microsoft.XLANGs.BaseTypes.Address)="oracledb://adapdoc/";  
SendPort(Microsoft.XLANGs.BaseTypes.TransportType)="WCF-Custom";  
  

Note

If you are using a WCF-OracleDB adapter in BizTalk Server Administration console, you can also specify the transport type as SendPort(Microsoft.XLANGs.BaseTypes.TransportType)="OracleDatabaseAdapter", where OracleDatabaseAdapter is the name with which you added the WCF-OracleDB adapter in BizTalk Server Administration console.

In the above example,

  • Request2 message is being created from Request1 message. Both the messages map to an operation schema, which is generated using the Consume Adapter Service BizTalk Project Add-in.

  • SendPort is the name of the logical send port in the BizTalk orchestration.

    The Expression shape is part of the BizTalk orchestration. When you deploy the orchestration, the WCF-custom send port is also created.

    For more information on configuring dynamic ports, see Configuring Dynamic Send Ports Using WCF Adapters Context Properties.

See Also

Building Blocks to develop BizTalk Applications with Oracle Database