Edit

Share via

Software prerequisites for BizTalk Adapter Pack 2016

  • Article

Lists the software requirements for the Microsoft BizTalk Adapter Pack (BAP) included with BizTalk Server 2016.

The BizTalk Adapter Pack can be consumed from:

  • A .NET application

  • Microsoft BizTalk Server

  • An ADO interface

  • A Microsoft SharePoint portal

    Based on how you use the adapters, the required software varies.

Prerequisites when using a .NET application

When using a .NET application to consume the adapters, the following software is required on your development computer (the computer where you're creating the .NET application). Install the software in the order listed.

BizTalk Adapter Pack 2016
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows 10
  • Windows 8.1
.NET Framework 4.6.x
Visual Studio 2015
WCF LOB Adapter SDK
The enterprise application clients and associated software. See Supported enterprise application versions (in this topic).

Prerequisites when using BizTalk Server

When using a BizTalk Server to consume the adapters, the following software is required on your BizTalk Server. Install the software in the order listed.

BizTalk Adapter Pack 2016
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows 10
  • Windows 8.1
.NET Framework 4.6.x
Visual Studio 2015
WCF LOB Adapter SDK

Install the Consume Adapter Service BizTalk Project Add-in for Visual Studio included with the WCF LOB Adapter SDK. To install, do a Custom (select BizTalk Server Addin) or Complete installation of the WCF LOB Adapter SDK.
BizTalk Server 2016
The enterprise application clients and associated software. See Supported enterprise application versions (in this topic).

Prerequisites when using ADO

The Microsoft BizTalk Adapter for mySAP Business Suite and Microsoft BizTalk Adapter for Siebel eBusiness Applications include an ADO layer (Data Provider for SAP and Data Provider for Siebel) that can be used to write an ADO.NET client to connect to an SAP system or Siebel system. You can also use the ADO layer with SQL Server Integration Services (SSIS) to import and export data from the LOB application, and SQL Server Reporting Services (SSRS) to generate reports to present data from the LOB systems.

Note

Using the ADO Provider with SSRS is supported only for the Data Provider for SAP.

The following software is required on the computer that uses the BizTalk Adapter Pack with an ADO interface. Install the software in the order listed.

BizTalk Adapter Pack 2016
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows 10
  • Windows 8.1
.NET Framework 4.6.x
Visual Studio 2015
WCF LOB Adapter SDK
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2014 SP1
The enterprise application clients and associated software. See Supported enterprise application versions (in this topic).

Prerequisites when using SharePoint

The goal of using the adapters with Microsoft SharePoint is to show data from an LOB application on a SharePoint portal.

A typical setup with the BizTalk Adapter Pack and SharePoint can use a single computer or use different computers for different tasks. The following table lists the software prerequisites for each computer. If you are using a single computer, all the software must be installed on that computer. Install the software in the order listed.

Computer where you run the WCF Adapter Service Development Wizard Computer where you host the WCF service Computer where you can use the SharePoint Designer to define your External Content Types
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows 10
  • Windows 8.1


  • .NET Framework 4.6.x


  • Visual Studio 2015


  • WCF LOB Adapter SDK


  • Microsoft BizTalk Adapter Pack


  • The enterprise application clients and associated software. See Supported enterprise application versions (in this topic).
  • Windows Server 2016
  • Windows Server 2012 R2
  • Windows 10
  • Windows 8.1


  • .NET Framework 4.6.x


  • Visual Studio 2015


  • WCF LOB Adapter SDK


  • Microsoft BizTalk Adapter Pack


  • The enterprise application clients and associated software. See Supported enterprise application versions (in this topic).


  • Internet Information Services (IIS) version that comes with the operating system. KB 224609 lists the versions.
 Microsoft SharePoint Software Development Kit (SDK)

Supported enterprise application versions

To see the specific LOB system versions that are supported by the BizTalk Adapter Pack, see Supported Line-of-Business (LOB) systems.

This section lists any extra info for each adapter, such as any client DLLs required for each adapter.

Oracle Database adapter

  • Optional: If you use distributed transactions with the Oracle database, install Oracle Services for Microsoft Transaction Server (part of the Oracle client installation) on the computer running the adapter client.

  • For your application to work with the most recent version of ODP.NET, install the policy DLLs and register the DLLs in the GAC. See Oracle Data Provider for .NET FAQ.

Oracle E-Business adapter

  • Optional: To use distributed transactions with the Oracle database, install Oracle Services for Microsoft Transaction Server (part of the Oracle client installation) on the computer running the adapter client.

  • For your application to work with the most recent version of ODP.NET, install the policy DLLs and register the DLLs in the GAC. See Oracle Data Provider for .NET FAQ.

SAP adapter

  • The SAP adapter requires Unicode version of the RFC SDK irrespective of whether the SAP system is Unicode or non-Unicode.

  • Required drivers: The following table lists the DLLs required by the BizTalk Adapter Pack to interface with the SAP system:

    SAP client version Required drivers
    7.2 - SAP RFC SDK 7.10 UNICODE. This is available as part of SNOTE 27517. The instructions to download the SDK are available at https://go.microsoft.com/fwlink/?LinkId=94691. After you have downloaded and extracted the SDK, copy all the DLLs from the \rfcsdk\bin and \rfcsdk\lib folders to the relevant location mentioned preceding this table.

    - DLLs are available from SAP as part of **R3DLLINST.zip    . This contains Microsoft run-time DLLs and can be downloaded from the SAP site. See SNOTE 684106 for more information. You can download the .zip file from https://go.microsoft.com/fwlink/?LinkId=94693. This link has an “Attachments” option from where you can download the package.

    - Microsoft Visual C++ run-time DLLs required for SAP 7.1 client

    - If you use SAP Secure Network Communications (SNC) to connect to an SAP system, you must also have the relevant DLLs from SAP. These DLLs are different for 32-bit and 64-bit platforms and are available with SNOTE 352295. You can download the DLLs from https://go.microsoft.com/fwlink/?LinkId=104032. This link has an “Attachments” option from where you can download the package. The names of the DLLs are:

    - **For 32-bit    : gsskrb5.dll, gssntlm.dll

    - **For 64-bit x86    *: gx64krb5.dll, gx64ntlm.dll

    Tip

    SNOTEs are release notes that accompany fixes released by SAP.

    Most of the packages that contain these DLLs must be downloaded from the SAP Service Marketplace. To get downloads from the SAP Service Marketplace:

    1. Install the Download Manager available from the SAP Service Marketplace.

    2. Configure the Download Manager by using your credentials for the SAP Service Marketplace.

    3. Be authorized by the SAP administrator in your organization to download software from the SAP service website. This is required because access to the SAP Software Distribution Center is restricted by a 'Download Software' authorization object. This ensures that software is downloaded only by authorized users.

    4. Install the SAPCAR program, which is required to extract the files from the packages that you download from the SAP Service Marketplace. SAPCAR is also available from the SAP Service Marketplace.

      For the 32-bit and 64-bit version of the BizTalk Adapter Pack, you must have the respective 32-bit and 64-bit versions of these DLLs.

    • On a 32-bit computer, the 32-bit version of the DLLs must be added to the C:\Windows\System32 folder.

    • On a 64-bit computer, the 32-bit version of the DLLs must be added to the C:\Windows\SysWow64 folder. The 64-bit version of the DLLs must be added to the C:\Windows\System32 folder.

Siebel adapter

No extra steps.

SQL adapter

Required drivers for SQL Server 2014:

  • If you use the UDTs shipped with the SQL Server versions, for example, Geography, make sure the following DLLs are present on the computer where you use the adapter to perform operations on SQL Server. For example, if you create BizTalk projects to perform operations on SQL Server, these DLLs must be present on the computer where BizTalk Server is running.

    • Make sure Microsoft.SqlServer.Types.dll is added to the GAC.

    • Make sure SqlServerSpatial.dll is available in the System32 folder.

    You can install these DLLs on the computer by running the SQL Server setup and selecting Management Tools – Basic and Management Tools – Complete in the Feature Selection page of the wizard.

  • If you use the adapter to perform operations on columns of FILESTREAM data types, make sure you have SQL Client Connectivity SDK installed. You can install the SQL Client Connectivity SDK by running the SQL Server setup and selecting SQL Client Connectivity SDK in the Feature Selection page of the wizard. The adapter uses the sqlncli10.dll, installed with the SQL Client Connectivity SDK, to perform FILESTREAM operations.

  • If you create your own UDTs in SQL Server, make sure the respective assemblies for the UDTs are added to the GAC.

64-bit host instance support

The Siebel adapter is supported in a 32-bit host instance. It is not supported to run the Siebel adapter in a 64-bit host instance.

All the other adapters can run in a 32-bit or 64-bit host instance.

For more information about the supported installation scenarios for installing the 32-bit and 64-bit BizTalk Adapter Pack, see 32-bit and 64-bit install scenarios at Installing BAP.

Next step

Install the BizTalk Adapter Pack