BizTalk Server 2013 R2: Installation and Configuration – Installing BizTalk Adapter Pack (Part 12)

The next posts will focus on installing and configuring BizTalk Server 2013 R2 and additional components

Make sure that you have installed all the latest critical Windows updates from Microsoft and all the prerequisites before you install BizTalk Server 2013 R2.

BizTalk Adapter Pack

BizTalk Adapter Pack, along with BizTalk AppFabric Connect, RFID features, UDDI Services, and ESB Toolkit, are not automatically installed with the default installation process; instead, you have to manually install these features.

The Microsoft BizTalk Adapter Pack contains adapters that enable enterprise applications and databases to interface with each other by implementing a common adapter framework. Similar to programming to Web services, adapters enable clients to program to different enterprise applications. Technically, adapters are a simple binding to the Windows Communication Framework (WCF). The BizTalk Adapter Pack consists of the following adapters:

• Microsoft BizTalk Adapter for Oracle Database (Oracle Database adapter).
• Microsoft BizTalk Adapter for Oracle E-Business Suite (Oracle E-Business adapter).
• Microsoft BizTalk Adapter for mySAP Business Suite (SAP adapter). This also includes the .NET Framework Data Provider for mySAP Business Suite (Data Provider for SAP).
• Microsoft BizTalk Adapter for Siebel eBusiness Applications (Siebel adapter). This also includes the .NET Framework Data Provider for Siebel eBusiness Applications (Data Provider for Siebel).
• Microsoft BizTalk Adapter for SQL Server (SQL adapter).

Microsoft BizTalk Adapter Pack and Microsoft BizTalk Adapter Pack (x64)

We are preparing an x64 environment machine, so why do I need to install both x86 and x64 Microsoft BizTalk Adapter Pack, and not only the x64 pack?

On any computer where you want to perform design-time tasks using either Visual Studio or BizTalk MMC, you must install the 32-bit adapter because:

• BizTalk Server Administration console runs as a 32-bit Microsoft Management Console (MMC) application.
• Visual Studio is also a 32-bit application (and there isn’t any 64-bit version of Visual Studio)

However, from the BizTalk runtime perspective:

• If you want to run the adapters under a 32-bit BizTalk process (Host Instance), you need to install the Microsoft BizTalk Adapter Pack.
• If you want to run the adapters under a 64-bit BizTalk process (Host Instance), you need to install the Microsoft BizTalk Adapter Pack (x64).

So you always have to install the Microsoft BizTalk Adapter Pack, or in other cases, you always need to install the 32-bit adapter if you want to perform any operation at design-time, especially when configuring the adapters in the administrative console.

Steps to install BizTalk Adapter Pack

To install BizTalk Adapter Pack:

• Close any programs you have open. Run the BizTalk Server 2013 R2 installer as Administrator.
• On the Start page, click Install Microsoft BizTalk Adapters.

• In the next Start page, the first step is to install the WCF LOB Adapter SDK, select Step 1. Install Microsoft WCF LOB Adapter SDK. An installer of the SDK is launched.
  • The WCF LOB Adapter SDK is a collection of a run-time engine and tools that help adapter developers create service-oriented interfaces to existing LOB systems by using WCF. The goal of the SDK is to facilitate uniform development of reusable, metadata-oriented, WCF-based adapters that enable enterprise applications, databases, and messaging platforms to integrate with each other.

• On the Welcome to the Windows Communication Foundation LOB adapter SDK Setup Wizard page, click Next.

• On the End-User License Agreement page, select I accept the terms in the License Agreement to accept the license agreement and click Next.

• In the Choose Setup Type page, select the installation type Complete:
  • Typical: will install the common runtime and tools,
  • Custom: will allow you to select the features that you want to install and the installation location.
  • Complete: will install all the features.

• On the Ready to install WCF LOB adapter SDK page, click Install.

• On the Completed the Windows Communication Foundation LOB Adapter SDK Setup Wizard page, click Finish.

• Back to the Start page, the second step is the Adapter Pack (x86) installation, select the Step 2. Install Microsoft BizTalk Adapter Pack. An installer of the SDK is launched.

• On the Welcome to the Microsoft BizTalk Adapter Pack Setup Wizard page, click Next.

• On the End-User License Agreement page, select I accept the terms in the License Agreement to accept the license agreement and click Next.

• In the Choose Setup Type page, select the installation type Complete:
  • Typical: will install the common runtime and tools,
  • Custom: will allow you to select the features that you want to install and the installation location.
  • Complete: will install all the features.

• On the Ready to install Microsoft BizTalk Adapter Pack page, click Install.

• On the Customer Experience Improvement Program page, select if you want to join the customer experience improvement program or not, and click OK.

• On the Completed the Microsoft BizTalk Adapter Pack Setup Wizard page, click Finish.

• Back to the Start page, the next step is installing the Microsoft BizTalk Adapter Pack (x64) – note that before you install this pack, you have to install x86 first – select Step 3. Install Microsoft BizTalk Adapter Pack(x64). An installer of the SDK is launched.

• On the Welcome to the Microsoft BizTalk Adapter Pack(x64) Setup Wizard page, click Next.

• On the End-User License Agreement page, select I accept the terms in the License Agreement to accept the license agreement and click Next.

• In the Choose Setup Type page, select the installation type Complete:
  • Typical: will install the common runtime and tools,
  • Custom: will allow you to select the features that you want to install and the installation location.
  • Complete: will install all the features.

• On the Ready to install Microsoft BizTalk Adapter Pack(x64) page, click Install.

• On the Customer Experience Improvement Program page, select if you want to join the customer experience improvement program or not, and click OK.

• On the Completed the Microsoft BizTalk Adapter Pack(x64) Setup Wizard page, click Finish.

• Back to the Start page, the final step is installing the Microsoft BizTalk Adapters for Enterprise Applications. Select Step 4. Install Microsoft BizTalk Adapters for Enterprise Applications. An installer of the SDK is launched.

• On the Welcome to the Microsoft BizTalk Adapters for Enterprise Applications Setup Wizard page, click Next.

• On the End-User License Agreement page, select I accept the terms in the License Agreement to accept the license agreement and click Next,

• In the Customer Information page, type your User Name and Organization and click Next to continue.

• In the Choose Setup Type page, select the installation type Complete:
  • Custom: will allow you to select the features that you want to install and the installation location.
  • Complete: will install all the features.

• On the Choose Destination Location page, choose the folder location that to want to install these features and click Next.

• On the Ready to install page, click Install.

• On the Completed the Microsoft BizTalk Adapters for Enterprise Applications Setup Wizard page, click Finish.

• Close the Start page, click Exit.

Add adapters to BizTalk Administration Console

As it happens with all adapters that we installed on our BizTalk Server environment, before we can begin to use them, we need to register or add the adapters. So in the next step, it will be describing how we can add the enterprise adapters, or any other custom adapter, on the BizTalk Administration Console. To accomplish that, we need to:

• Open BizTalk Administration Console by pressing the Windows key to switch to the Start screen, typing BizTalk Server Administration or BizTalk, and clicking the BizTalk Server Administration option from the Search menu
• In the console left tree, expand BizTalk Server Administration > BizTalk Group > Platform Settings and then Adapters.
• Right-click on Adapters and add a new adapter by selecting the option New > Adapter.

• In the Adapter Properties window;
  • In the Name box, type a descriptive name for this adapter.
    • WCF-SQL
  • In the Adapter combo box, select the adapter from the drop-down that you want to add.
    • WCF-SQL
  • In the Description box, type a description for the adapter (this is optional).
    • The WCF-SQL Adapter provides access to SQL Database tables, views, stored procedures, and functions. Polling is also provided, allowing applications to periodically query databases for data.
  • Click OK to complete the process of adding the adapter.

• Repeat steps to add the other adapters.

Note: This configurations requires that you restart the host instance associated with the adapters.

Related links

• BizTalk Server 2013 R2: Installation and Configuration – Important considerations before set up the server (Part 1)
• BizTalk Server 2013 R2: Installation and Configuration – Enable Internet Information Services (Part 2)
• BizTalk Server 2013 R2: Installation and Configuration – Install Windows Identity Foundation (WIF) (Part 3)
• BizTalk Server 2013 R2: Installation and Configuration – Install and configure SMTP Server Feature (optional) (Part 4)
• BizTalk Server 2013 R2: Installation and Configuration – Install Microsoft Office Excel 2013 (Part 5)
• BizTalk Server 2013 R2: Installation and Configuration – Install Visual Studio 2013 (Part 6)
• BizTalk Server 2013 R2: Installation and Configuration – Install SQL Server 2014 (Part 7)
• BizTalk Server 2013 R2: Installation and Configuration – Configure SQL Server Database Mail feature (Part 8)
• BizTalk Server 2013 R2: Installation and Configuration – Install and Configure BizTalk Server 2013 R2 (Part 9)
• BizTalk Server 2013 R2: Installation and Configuration – Configure SQL Server Network Configuration protocols (Part 10)
• BizTalk Server 2013 R2: Installation and Configuration – Validate Mail account used by BizTalk to send BAM Alerts (Part 11)
• BizTalk Server 2013 R2: Installation and Configuration – Install and Configure Microsoft UDDI Services (Part 13)
• BizTalk Server 2013 R2: Installation and Configuration – Install and Configure the Microsoft BizTalk ESB Toolkit (Part 14)
• BizTalk Server 2013 R2: Installation and Configuration – Configure BizTalk Server SQL Jobs (Part 15)
• BizTalk Server 2013 R2: Installation and Configuration – Optimize the BizTalk Server 2013 R2 environment (Part 16)
• BizTalk Server 2013 R2: Installation and Configuration – Optimize the BizTalk Server 2013 R2 environment (Part 17)
• BizTalk Server 2013 R2: Installation and Configuration – Optimize the BizTalk Server 2013 R2 environment (Part 18)
• BizTalk Server 2013 R2: Installation and Configuration – Install additional Developer tools (Part 19)

Hope you find this helpful! If you liked the content or found it useful and would like to support me in writing more, consider buying (or helping to buy) a Star Wars Lego set for my son.