Oracle Database (commonly known as Oracle DBMS or simply Oracle) is a multi‑model database management system created and maintained by Oracle Corporation. Organizations use it widely for online transaction processing (OLTP), data warehousing (DW), and mixed workloads that combine both models. Because of this, many companies need to integrate their applications with Oracle. To support… Read More »

Adapters enable communication between BizTalk Server and external systems or trading partners. Users configure adapters by creating send ports and receive locations that define the properties for each adapter instance. In many cases, adapters support both send and receive operations. However, some adapters only support one‑way communication. The HTTP Adapter is one of the adapters… Read More »

There are many things to consider when planning this type of installation. This whitepaper will explain in detail – a step-by-step guideline – how to install and configure Microsoft BizTalk Server 2020 on a basic multi-computer environment using Windows Server 2019, i.e., installation of BizTalk Server with a remote SQL Server (1 SQL Server and… Read More »

There was a lot of inconsistent and incorrect information about the BizTalk WCF-SAP Adapter installation process and how it works, especially in old versions of the adapter, where there was a need to use the classic RFC library to connect to SAP. Fortunately for us, this process is now simpler and more direct, and this… Read More »

What a journey—more than two years! Writing a book through the pandemic and handling every detail was tough. I’m grateful to Tom Canter and Lex Hegt for walking this path with me, and to Kovai and Saravana for their support. Today brought a surprise. The book went live on the same day I returned to… Read More »

I recently published a blog post about BizTalk Server 2020 BAM Configuration: Microsoft SQL Server Integration Services (SSIS) is not installed on the local machine. This article is a direct continuation of that one, as the issues I encountered during the installation went far beyond that initial error. Although SQL Server Integration Services and SQL… Read More »

And yes, let’s continue one of my previous insane experiences installing a brand new BizTalk Server 2020 production environment. In one of my earlier blog posts, I explained another issue while trying to install this feature: BizTalk Server 2020 EDI/AS2 Runtime Configuration: Host (BizTalkServerApplication) is an invalid Receive Handler for SQL Adapter. This is a different… Read More »

This could be a valid error message if it weren’t for the simple little detail that we are dealing with a High-availability multi-server BizTalk Server installation. That means that the SQL Server was installed in another machine(s)… and yes, Microsoft SQL Server Integration Services was installed on the SQL Server as Analysis Service and all… Read More »

I have to say that I saw bizarre error messages during these long years as a consultant, but this one gained direct entry into my TOP 10 for a straightforward fact: there isn’t a SQL Adapter on BizTalk Server 2020. The adapter was deprecated since BizTalk Server 2006 R2, and they decided to remove it… Read More »