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. Set to 120 seconds or longer for jobs that run for more than an hour. 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 runs. 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. Set to 120 seconds or longer for jobs that run for more than an hour. 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 ETL service, called Qlik Cloud Data Services, and allows 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. Set to 120 seconds or longer for jobs that run for more than an hour. Default: 10 |
Tolerance |
Determines the number of times to check the job status before ending Not OK. Default: 2 |