Business Intelligence and Analytics Connection Profiles

The following topics describe connection profiles for business intelligence and analytics platforms and services:

• ConnectionProfile:AWS QuickSight

• ConnectionProfile:Microsoft Power BI

• ConnectionProfile:Microsoft Power BI SP

• ConnectionProfile:Qlik Cloud

• ConnectionProfile:Tableau

ConnectionProfile:AWS QuickSight

AWS QuickSight is a cloud-based data analytics platform that enables you to visualize, analyze, and share large workloads of data.

The following examples show how to define an AWS QuickSight connection profile.

• This JSON defines a job based on authentication using an AWS access key and secret:

  Copy

  {
     "AWS_QUICKSIGHT": 
     {
        "Type": "ConnectionProfile:AWS QuickSight",
        "Authentication Method": "SECRET",
        "AWS Access Key": "MYAWSACCESSKEY1234",
        "AWS Secret": "myAwsSecret12345",
        "AWS Region": "us-east-1",
        "AWS Account ID": "12345678",
        "AWS QuickSight URL": "https://quicksight.us-east-1.amazonaws.com",
        "Connection Timeout": "30",
        "Description": "",
        "Centralized": true
     }
  }

• This JSON defines a job based on authentication using an AWS IAM role from inside an EC2 instance:

  Copy

  {
     "AWS_QUICKSIGHT": 
     {
        "Type": "ConnectionProfile:AWS QuickSight",
        "Authentication Method": "NOSECRET",
        "IAM Role": "QUICKSIGHTIAMROLE", 
        "AWS Region": "us-east-1",
        "AWS Account ID": "12345678",
        "AWS QuickSight URL": "https://quicksight.us-east-1.amazonaws.com",
        "Connection Timeout": "30",
        "Description": "",
        "Centralized": true
     }
  }

The following table describes the AWS QuickSight job connection profile parameters.

ConnectionProfile:Microsoft Power BI

The Microsoft Power BI job enables you to integrate Power BI workflows with your existing Control-M workflows.

The following example shows how to define a connection profile for a Microsoft Power BI job:

{ 
   "POWERBI": 
   { 
      "Type": "ConnectionProfile:Microsoft Power BI", 
      "Application ID": "77538c66-d7fp-4ca4-8cwa-120ed404fe8c",  
      "Client Secret": "*****", 
      "User Name": "[email protected]", 
      "Password": "*****",  
      "Resource Group": "https://analysis.windows.net/powerbi/api", 
      "API URL": "https://api.powerbi.com/v1.0/myorg/",  
      "Description": "Power BI connection profile", 
      "Centralized": true 
   } 
}

The following table describes the Microsoft Power BI job connection profile parameters.

ConnectionProfile:Microsoft Power BI SP

The Microsoft Power BI job enables you to include service principal authentication to integrate Power BI workflows with your existing Control-M workflows. Service principal authentication utilizes Azure Active Directory to allow applications to access resources without exposing sensitive credentials.

The following example shows how to define a connection profile for a Microsoft Power BI SP job that authenticates with a username and password:

{
   "POWERBI": 
   {
      "Type": "ConnectionProfile:Microsoft Power BI SP",
      "Description": "",
      "Power BI URL": "https://api.powerbi.com/v1.0/myorg/",
      "Resource Group": "https://analysis.windows.net/powerbi/api",
      "Client ID": "0ab4cdc9-e94c-494d-ace8-4873cde12345",
      "Client Secret": "*****",
      "Authentication": "Password",
      "Username": "[email protected]",
      "Password": "*****",
      "Connection Timeout": "50",
      "Centralized": true
   }
}

The following example shows how to define a connection profile for a Microsoft Power BI SP job that authenticates with a service principal:

{
"POWERBI": {
      "Type": "ConnectionProfile:Microsoft Power BI SP",
      "Description": "",
      "Power BI URL": "https://api.powerbi.com/v1.0/myorg/",
      "Resource Group": "https://analysis.windows.net/powerbi/api",
      "Client ID": "0ab4cdc9-e94c-494d-ace8-4873cde12345",
      "Client Secret": "*****",
      "Authentication": "Client",
      "Tenant ID": "04dc5587-63a8-4c64-ae55-ab0694f12345",
      "Connection Timeout": "50",
      "Centralized": true
   }
}

The following table describes the Microsoft Power BI SP job connection profile parameters.

ConnectionProfile:Qlik Cloud

Qlik Cloud supports a cloud-based extract, transform, load (ETL) service, called Qlik Cloud Data Services, and enables you to visualize your data using Qlik Sense.

The following example shows how to define a connection profile for a Qlik Cloud job:

{
   "QLIK_connection": 
   {
      "Type": "ConnectionProfile:Qlik Cloud",
      "Tenant ID": "******",
      "Qlik API URL": "qlikcloud.com/api/v1",
      "Region": "sg",
      "API Key": "******",
      "Connection Timeout": "10",    
      "Description": "Qlik Cloud connection profile",
      "Centralized": true
   }
}

The following table describes the Qlik Cloud job connection profile parameters.

ConnectionProfile:Tableau

Tableau is a cloud-based data analytics platform that enables you to visualize, analyze, and share large workloads of data.

The following example shows how to define a connection profile for a Tableau job:

{
   "TABLEAU_CP": 
   {
      "Type": "ConnectionProfile:Tableau",
      "Tableau URL": "https://prod-useast-b.online.tableau.com",
      "Token Name": "myToken",
      "Token Secret": "*****",
      "Site Name": "bmctest",
      "API Version": "3.19",
      "Connection timeout": "50",
      "Description": "",
      "Centralized": true
   }
}

The following table describes the Tableau job connection profile parameters.