Edit

Set up a self-hosted integration runtime for the SAP CDC connector

  • Article
  • 2 minutes to read

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Learn how to create and set up a self-hosted integration runtime for the SAP CDC connector in Azure Data Factory.

To prepare a self-hosted integration runtime to use with the SAP CDC connector, complete the steps that are described in the following sections.

Create and set up a self-hosted integration runtime

In Azure Data Factory Studio, create and configure a self-hosted integration runtime. You can download the latest version of the private self-hosted integration runtime. The download version has improved performance and detailed error messages. Install the runtime on your on-premises computer or on a virtual machine (VM).

The more CPU cores you have on the computer running the self-hosted integration runtime, the higher your data extraction throughput is. For example, an internal test achieved a higher than 12-MB/s throughput when running parallel extractions on a self-hosted integration runtime computer that has 16 CPU cores.

Download and install the SAP .NET connector

Download the latest 64-bit SAP .NET Connector (SAP NCo 3.0) and install it on the computer running the self-hosted integration runtime. During installation, in the Optional setup steps dialog, select Install assemblies to GAC, and then select Next.

Screenshot of the SAP .NET Connector 3.0 installation dialog.

Add a network security rule

Add a network security rule on your SAP systems so that your self-hosted integration runtime computer can connect to them. If your SAP system is on an Azure VM, to add the rule:

  1. Set Source IP addresses/CIDR ranges to your self-hosted integration runtime machine IP address.

  2. Set Destination port ranges to 3200,3300. For example:

    Screenshot of the Azure portal networking configuration to add network security rules for your runtime to connect to your SAP systems.

Test connectivity

On the computer running your self-hosted integration runtime, run the following PowerShell cmdlet to ensure that it can connect to your SAP systems:

Test-NetConnection <SAP system IP address> -port 3300

Screenshot of the PowerShell cmdlet to test the connection to your SAP systems.

Edit hosts files

Edit the hosts file on the computer running your self-hosted integration runtime to add your SAP IP addresses to your server names.

On the computer running your self-hosted integration runtime, edit C:\Windows\System32\drivers\etc\hosts to add mappings of your SAP system IP addresses to your server names. For example:

# SAP ECC 
xxx.xxx.xxx.xxx sapecc01 
# SAP BW 
yyy.yyy.yyy.yyy sapbw01 
# SAP SLT 
zzz.zzz.zzz.zzz sapnw01

Next steps

Set up an SAP CDC linked service and source dataset