Business Intelligence and Analytics Jobs
The following topics describe job attributes that work with business intelligence and analytics platforms and services:
AWS QuickSight Job
AWS QuickSight is a cloud-based data analytics platform that enables you to visualize, analyze, and share large workloads of data.
The following table describes the AWS QuickSight job type attributes.
Attribute |
Description |
---|---|
Connection Profile |
Determines the authorization credentials that are used to connect Control-M to AWS QuickSight. Rules:
|
AWS Dataset ID |
Determines the ID of the AWS QuickSight job that is created in an AWS QuickSight workspace. |
Refresh Type |
Determines which of the following refresh functions to perform:
|
Status Polling Frequency |
(Optional) Determines the number of seconds to wait before checking the status of the job. Default: 30 |
Failure Tolerance |
Determines the number of times to check the job status before ending Not OK. Default: 2 |
Power BI Job
The Microsoft Power BI job enables you to integrate Power BI workflows with your existing Control-M workflows.
The following table describes Microsoft Power BI job attributes.
Attribute |
Description |
---|---|
Connection profile |
Determines the authorization credentials that are used to connect Control-M to Microsoft Power BI. |
Dataset Refresh/ Pipeline Deployment |
Determines one of the following options for execution in Power BI:
|
Workspace Name |
(For Dataset) Defines a Power BI workspace where you want to refresh data. |
Workspace ID |
(For Dataset) Defines the ID for the specified Power BI workspace (defined in Group Name). |
Dataset ID |
Defines a Power BI data set that you want to refresh under the specified workspace. |
Parameters |
(For Dataset) Defines specific parameters, in JSON format, to pass when the job executes. For more information about available parameters, see Datasets - Refresh Dataset in the Microsoft Power BI documentation. To specify parameters, the dataset must be in Premium group. Format: {"param1":"value1", "param2":"value2"} Copy
For no parameters, type {}. |
Connection Timeout |
(Optional) Determines the maximum number of seconds to wait for REST API requests to respond, before disconnecting. Default: 10 |
Status Polling Frequency |
(Optional) Determines the number of seconds to wait before checking the status of the job. Default: 10 |
Pipeline ID |
Defines the ID of a Power BI pipeline that you want to deploy to test and then to production. |
Qlik Cloud Job
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 table describes the Qlik Cloud job attributes.
Field | Description |
---|---|
Connection Profile |
Determines the authorization credentials that are used to connect Control-M to Qlik Cloud . Rules:
|
Reload Type |
Determines one of the following options to load data into the environment:
|
App Name |
Defines the Qlik Sense app name, which contains one or more workspaces, called sheets. |
Print Log to Output |
Determines whether the job logs are included in the Control-M output. |
Status Polling Frequency |
Determines the number of seconds to wait before checking the status of the job. Default: 10 |
Tolerance |
Determines the number of times to check the job status before ending Not OK. Default: 2 |
Tableau Job
Tableau is a cloud-based data analytics platform that enables you to visualize, analyze, and share large workloads of data.
The following table describes the Tableau job attributes.
Attribute |
Description |
---|---|
Connection Profile |
Determines the authorization credentials that are used to connect Control-M to Tableau. Rules:
|
Action |
Determines one of the following Tableau actions to perform:
|
Data Source Name |
Defines the name of the data source that is refreshed. Tableau can connect to the following types of data sources:
|
Status Polling Frequency |
(Optional) Determines the number of seconds to wait before checking the status of the job. Default: 30 |
Failure Tolerance |
Determines the number of times to check the job status before ending Not OK. Default: 1 |