Azure Data Factory Series : Create Azure Data Factory with SSIS runtime

Introduction

This blogpost describes how to create the Azure Data Factory. The plan is create some follow up blogpost about running SSIS packages in Azure Data Factory. Now, this blogpost descibes how to create and setup the Azure Data Factory. This is a introduction to Azure Data Factory.

Prerequisites for creating a Azure Data Factory is an Azure subscription. I'm using a Visual Studio Professional subscription.

For later use I've downloaded and installed the Storage Explorer. I expect to need that for uploading some data to the storage account.

Create a data factory

1. First step is login into azure.

2. The second step is to create the resource Azure data factory in the Azure Portal. In the Resource blade select the Create a Resource -> Analytics -> Azure Data Factory

3. On the New Factory blade I put a descriptive name in the name field and press on Create.

And the Azure Data Factory is created in Azure.

4. When you open the Azure Data Factory, it's possible to browse the the settings and view the monitoring

5. Select Author&Monitor to start the Azure Data Factory

6. Now let's configure the SSIS integration Runtime in the Azure Data Factory. Click on the Configure SSIS Integration Runtime.

7. Now enter some settings in the General settings tab.

7. Now enter some settings in the SQL settings tab and click on test connection to make sure that the database server can be reached.

8. Enter some advanced settings. I'll not go into much detail here because thisis a introductory blogpost.

9. Now it will take some time to create the SSIS runtime in Azure. In my case it took exactly 30 minutes to finish.

10. And we are done! There are two Integration Runtimes created. One is the standard ADF IR and the SSIS runtime. We are up and running!!

11. Let's see how SSMS can connect to the server. We see now there is a SSISDB installed along the SQL Azure Database.

12. And if you want to access the SSIS catalog, some settings are needed when connecting to Catalog. You can change that in the Options tab.

13. This is the result of connecting to the IS catalog.

Well, this is a small introduction to setting up Azure Data Factory with a SSIS runtime. I hope you like it and see you at future blogposts..

Final thoughts

Setting up the Azure Data Factory with SSIS runtime is very easy in Azure. More ADF blogposts to come...

Hennie