Business Intelligence and Analytics Connection Profiles

The following topics describe the connection profile parameters for business intelligence and analytics platforms and services:

AWS QuickSight Connection Profile Parameters

Before you can define a job, you must create a connection profile in the Configuration domain. A connection profile contains authorization credentials—such as the username, password, and other plug-in-specific parameters—and enables you to connect to the application server with only the connection profile name. To create a connection profile, see Creating a Centralized Connection Profile.

For more information about this plug-in, see Control-M for AWS QuickSight.

The following table describes the AWS QuickSight connection profile parameters.

Parameter

Description

AWS QuickSight URL

Defines the authentication endpoint for AWS QuickSight, based on the following format:

https://quicksight.<region name>.amazonaws.com

https://quicksight.us-east-1.amazonaws.com

AWS Region

Determines the region where the AWS QuickSight jobs are located.

us-east-1

AWS Account ID

Determines the AWS account ID, which can be retrieved from the top right-hand corner of the AWS console.

Authentication Method

Determines one of the following authentication methods:

  • AWS Key & Secret: Used for services outside the AWS infrastructure.

  • AWS IAM Role: Used for services within the AWS infrastructure.

AWS Access Key

Defines the access key assigned to the account in the AWS QuickSight integration setup.

AWS Secret

Defines the secret access key assigned to the account in the AWS QuickSight integration setup.

IAM Role

Defines the Identity and Access Management (IAM) role for the AWS connection.

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to AWS QuickSight before a timeout occurs.

Default: 30

IBM Cognos Connection Profile Parameters

Before you can define a job, you must create a connection profile in the Configuration domain. A connection profile contains authorization credentials—such as the username, password, and other plug-in-specific parameters—and enables you to connect to the application server with only the connection profile name. To create a connection profile, see Creating a Centralized Connection Profile.

For more information about this plug-in, see Control-M for IBM Cognos.

The following table describe the IBM Cognos connection profile parameters.

Field

Description

Web Server Host Name

Defines the name of the IBM Cognos web services server.

Use SSL

Determines whether SSL is used to encrypt the connection between Control-M for IBM Cognos and the IBM Cognos web server.

For more information, see Business Intelligence and Analytics Connection Profiles.

Port Number

Defines the port number of the IBM Cognos web services server

Namespace ID

Defines the authentication method ID for the IBM Cognos server. Ask your IBM Cognos Administrator for the settings.

User Name

Defines the user name for the IBM Cognos server.

Password

Defines the password for the IBM Cognos server.

Confirm Password

Confirms the password for the IBM Cognos server.

Power BI Connection Profile Parameters

Before you can define a job, you must create a connection profile in the Configuration domain. A connection profile contains authorization credentials—such as the username, password, and other plug-in-specific parameters—and enables you to connect to the application server with only the connection profile name. To create a connection profile, see Creating a Centralized Connection Profile.

For more information about this plug-in, see Control-M for Power BI.

The following table describes Power BI connection profile parameters.

Parameter

Description

Application ID

Defines the application ID of the registered application.

Client Secret

Defines the secret (password) associated with the user and the application.

User Name

Defines the name of a user for logging on to the Power BI platform, typically an email address.

Password

Defines the password for the specified Power BI user.

Resource Group

Defines the URL of the resource group that holds your application:

https://analysis.windows.net/powerbi/api

API URL

Defines the Azure AD authentication endpoint base URL for Power BI:

https://api.powerbi.com/v1.0/myorg/

Qlik Cloud Connection Profile Parameters

Before you can define a job, you must create a connection profile in the Configuration domain. A connection profile contains authorization credentials—such as the username, password, and other plug-in-specific parameters—and enables you to connect to the application server with only the connection profile name. To create a connection profile, see Creating a Centralized Connection Profile.

For more information about this plug-in, see Control-M for Qlik Cloud.

The following table describes the Qlik Cloud connection profile parameters.

Parameter

Description

Qlik API URL

Defines the REST API authentication endpoint base URL for Qlik Cloud.

qlikcloud.com/api/v1

Tenant ID

Defines the tenant ID, which is a unit in Qlik Sense that can hold users, apps, and spaces.

Region

Determines the region where the Qlik tenant is located, such as Singapore.

API Key

Defines a Qlik Cloud API key that authenticates connections to Qlik Cloud, which is generated through the Qlik Cloud profile.

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to Qlik Cloud before a timeout occurs.

Default: 10

Tableau Connection Profile Parameters

Before you can define a job, you must create a connection profile in the Configuration domain. A connection profile contains authorization credentials—such as the username, password, and other plug-in-specific parameters—and enables you to connect to the application server with only the connection profile name. To create a connection profile, see Creating a Centralized Connection Profile.

For more information about this plug-in, see Control-M for Tableau.

The following table describes the Tableau connection profile parameters.

Parameter

Description

Tableau URL

Defines the REST API authentication endpoint base URL for Tableau.

https://prod-useast-b.online.tableau.com

Token Name

Defines the Tableau account access key.

Token Secret

Defines the Tableau account secret access key.

Site Name

Defines the name of the Tableau site where the job executes.

API Version

Determines which version of Tableau REST APIs the job executes.

Most recent version: 3.19

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to Tableau before a timeout occurs.

Default: 50