BizTalk Server 2020 – Step-by-Step WCF-OracleDB Adapter installation guide

by Sandro Pereira, Nicolas Blatter,

BizTalk Server 2020 – Step-by-Step WCF-OracleDB Adapter installation guide

by Sandro Pereira, Nicolas Blatter,

Oracle database plays a crucial role in running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads.

The Microsoft BizTalk Adapter exposes Oracle databases as WCF services. Adapter clients can perform operations on the Oracle database by exchanging SOAP messages with the adapter.

Fortunately for us, this process is now simpler and more direct, this is due to the fact that on BizTalk Server 2020 the Microsoft BizTalk Adapter Pack x86 and x64 is now installed with the default installation process.

However, it is not available out-of-the-box in the BizTalk Server Administration Console. This whitepaper explains in detail – a step-by-step guideline – how to install and configure the WCF-OracleDB Adapter on a BizTalk Server 2020 standalone environment running Windows Server 2019.

What’s in store for you?

This whitepaper will give you a detailed understanding of the following:

  • Requirements Installation
  • Install Oracle Data Access Components (ODAC)
  • Test Oracle Connectivity
Sandro Pereira
About the author

Sandro Pereira

BizTalk consultant at DevScope

Currently working as a BizTalk consultant at DevScope (www.devscope.net). In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size and criticality, using Microsoft Azure (API Management, Logic Apps, Service Bus, Event Hubs, PowerApps, Flow, …), Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO and so on.

Nicolas Blatter
About the author

Nicolas Blatter

Senior Technology Consultant at Hewlett Packard Enterprise

Nicolas is the Senior Technology consultant at Hewlett Packard Enterprise. He has a Degree in Business Information Technology. He worked as an EDI Specialist between 1991 – 2000 at Swisscos, Digital, Compaq. From 2000 through today, Nicolas works as a BizTalk Specialist and has implemented projects with all/any of the released BizTalk versions.

Trusted by 650+ enterprises

Get ready to be amazed in less than 45 minutes

Try for Free or Book a Demo