Proposed Pull Request Change

📄 Document Links

View on GitHub View on Microsoft Learn

--- title: Set up a self-hosted integration runtime for the SAP CDC connector titleSuffix: Azure Data Factory description: Learn how to create and set up a self-hosted integration runtime for the SAP change data capture (CDC) connector in Azure Data Factory. author: ukchrist ms.subservice: data-movement ms.topic: conceptual ms.date: 05/15/2024 ms.author: ulrichchrist ms.custom: - devx-track-dotnet - sfi-image-nochange --- # Set up a self-hosted integration runtime for the SAP CDC connector [!INCLUDE[appliesto-adf-asa-md](includes/appliesto-adf-asa-md.md)] 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](create-self-hosted-integration-runtime.md?tabs=data-factory). You can download the latest version of the private [self-hosted integration runtime](https://www.microsoft.com/download/details.aspx?id=39717). 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. > [!NOTE] > If you want to use shared self hosted integration runtime from another Data Factory, you need to make sure your Data Factory is in the same region of another Data Factory. What is more, your Data Flow integration runtime need to be configured to "Auto Resolve" or the same region of your Data Factory. ## Download and install the SAP .NET connector Download the latest [64-bit SAP .NET Connector (SAP NCo 3.0)](https://support.sap.com/en/product/connectors/msnet.html) 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**. :::image type="content" source="media/sap-change-data-capture-solution/sap-cdc-net-connector-installation.png" alt-text="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. 1. Set **Destination port ranges** to **3200,3300**. For example: :::image type="content" source="media/sap-change-data-capture-solution/sap-cdc-add-network-security-rule.png" alt-text="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: ```powershell Test-NetConnection <SAP system IP address> -port 3300 ``` :::image type="content" source="media/sap-change-data-capture-solution/sap-cdc-powershell-test-connection.png" alt-text="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: ```ini # SAP ECC xxx.xxx.xxx.xxx sapecc01 # SAP BW yyy.yyy.yyy.yyy sapbw01 # SAP SLT zzz.zzz.zzz.zzz sapnw01 ``` ## Related content [Set up an SAP CDC linked service and source dataset](sap-change-data-capture-prepare-linked-service-source-dataset.md)