Configure a Receive Location for the CData BizTalk Adapter for xBase

Ready to get started?

Download for a free trial:

Download Now

Learn more:

xBase BizTalk Adapter

Powerful BizTalk Adapters that allow you to easily connect BizTalk Server with live xBase- compatible databases through standard orchestrations.

Use the xBase Adapters to synchronize with data stored in xBase databases like FoxPro & Clipper (.dbf, .ndx, .ntx, .dbt, etc). Perfect for data synchronization, local back-ups, workflow automation, and more!

Pull xBase data in BizTalk using the CData BizTalk Adapter for xBase. Use receive locations to execute SQL commands and automate actions in xBase.

You can follow the procedure in this article to connect to xBase data, configure a static one-way receive location, and use it to perform a simple test: retrieving xBase data and writing it to an XML file.


Create the Receive Port



Create the Receive Location

After you create the receive port, create the receive location and configure it to use the xBase adapter as its transport type.

  4. In the Receive Location properties, select CData.xBase in the Transport Type menu.

Configure the Adapter


  2. In the SQL Command property, enter the command. This example uses SELECT Company, SUM(Total) FROM Invoices GROUP BY ContactName

Configure the Connection String


  2. Click the button in the Connection String property.
  4. Enter connection properties. Below is a typical connection string: DataSource=MyDBFFilesFolder;




Use a Send Port to Write Data to an XML File



  4. For the file name, a macro can be used to easily identify what day the file was created. By default, %MessageId%.xml is used. However, this is not a very user-friendly name, as it is a randomly generated BizTalk Id. To produce a file in the format Invoices_yyyy-MM-dd.xml, enter Invoices_%Date%.xml.


  7. Set the following properties:
    Property: Select "BTS.InboundTransportLocation" from the menu.
    Operator: Select "==" from the menu.


Enlist and Enable the Locations and Ports





The log will include error messages for all applications on the system, so it is important to check that the source of the error message is "CData BizTalk xBase Receive Adapter". Details of the error message should provide insight into why the error is occurring. For guidance on resolving the error, contact support@cdata.com.