A self-hosted integration runtime is necessary when we want to access data in the on-premise Windows machine from ADF. This is a secure tunnel that allows ADF to read or write data to a database or files. This section will describe how to set up this tunnel.
- Going back to the factory, we select the Connections section and then select Integration Runtimes, as shown in the following screenshot. Click on + New:
- This brings forth the Integration Runtime Setup wizard. Select the first integration runtime and click on Next.
- We discussed earlier in this book the two types of self-hosted integration runtime; one is for a public (cloud) network, like the default runtime available with ADF by default. The other one is used to access private networks and machines, exactly what we want to do here. We'll use the Private Network integration runtime. Click on Next. The last step is used to name our integration runtime; name it WWImportersDW and click on Next.
- The final step is to download and set up an integration runtime service. This is a Windows service that will allow communication or a tunnel between your PC and ADF. As shown in the following screenshot, we have two options. Express setup will install the integration runtime on your local machine and set up the authentication keys to create the communication service.
The second option requires us to download the ADF integration runtime. It directs you to the following URL: https://www.microsoft.com/en-us/download/details.aspx?id=39717. Click on Download to continue.
- You will be asked to choose the download. Check the first option and click on Next.
- Once downloaded, start the installation of the executable. Choose the language you want and click on Next to continue.
- Read and accept the terms and conditions. Click on Next.
- Choose the destination folder and click on Next.
- Finally, click on Install to proceed with the installation.
- If you're using a laptop, you will get this message when the installation completes. It simply tells you that the service will not be available if your PC goes to sleep or hibernates. Click on OK to dismiss it:
In a real-world scenario, we wouldn't use a laptop to install the integration runtime. It would be installed on a machine that is not going to sleep or hibernate. Usually, we use a small server that has access to the data sources. We should never install it on a laptop or a database server.
- Once we've clicked on Finish in the last step of the wizard, a window opens and asks us for the authentication key, as shown in the following screenshot:
- This key is found on the Integration Runtime Setup. Go back to the factory; if you've followed the steps in this section, you should have a step like the one in this screenshot:
- Click on the copy icon as highlighted. You will get a confirmation message that the content has been copied to your local clipboard.
- Go back to the Microsoft Integration Runtime Configuration Manager and paste the authentication key content; you should see a screen like this:
- Click on Register to link the integration runtime with your ADF. In ADF, click on Finish to complete the integration runtime setup in the factory. You should see the newly created integration runtime in the list, as shown in the following screenshot:
