Integrating with data source services on Microsoft Azure

You can configure an integration with the Microsoft Azure platform to allow Cloud Pak for Data as a Service users access to data sources from Microsoft Azure. Before proceeding, make sure you have required permissions. For example, you'll need permission in your subscription to create an application integration in Azure Active Directory.

After you configure an integration, you'll see it under Service instances. You'll see a new Azure tab that lists your instances of Data Lake Storage Gen1 and SQL Database.

To configure an integration with Microsoft Azure:

1. Log on to your Microsoft Azure account at https://portal.azure.com.

2. Navigate to the Subscriptions panel and copy your subscription ID.

3. In Cloud Pak for Data as a Service, go to Administration > Cloud integrations and click the Azure tab. Paste the subscription ID you copied in the previous step into the Subscription ID field.

   

4. In Microsoft Azure Active Directory, navigate to Manage > App registrations and click New registration to register an application. Give it a name such as IBM integration and select the desired option for supported account types.

5. Copy the Application (client) ID and the Tenant ID and paste them into the appropriate fields on the Cloud Pak for Data as a Service Integrations page, as you did with the subscription ID.

6. In Microsoft Azure, navigate to Certificates & secrets > New client secret to create a new secret.

   Important!

   • Write down your secret and store it in a safe place. After you leave this page, you won't be able to retrieve the secret again. You'd need to delete the secret and create a new one.
   • If you ever need to revoke the secret for some reason, you can simply delete it from this page.
   • Pay attention to the expiration date. When the secret expires, integration will stop working.

7. Copy the secret from Microsoft Azure and paste it into the appropriate field on the Integrations page as you did with the subscription ID and client ID.

8. Configure firewall access.

9. Confirm that you can see your Azure services. From the main menu, choose Services > Services instances. Click the Azure tab to see those services.

Now users who have credentials to your Azure services can create connections to them by selecting them on the Add connection page. Then they can access data from those connections by creating connected data assets.