Business Intelligence and Analytics Jobs
The following topics describe job attributes that work with business intelligence and analytics platforms and services:
Amazon QuickSight Job
Amazon QuickSight is a cloud-based data analytics platform that enables you to visualize, analyze, and share large workloads of data.
To create an Amazon QuickSight job, see Creating a Job. For more information about this plug-in, see Control-M for Amazon QuickSight.
The following table describes the Amazon QuickSight job attributes.
|
Attribute |
Description |
|---|---|
|
Connection Profile |
Determines the authorization credentials that are used to connect Control-M to Amazon QuickSight, as described in Amazon QuickSight Connection Profile Parameters. Rules:
|
|
AWS Dataset ID |
Determines the ID of the Amazon QuickSight job that is created in an Amazon 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 job status. Default: 30 |
|
Failure Tolerance |
Determines the number of times to check the job status before the job ends Not OK. Default: 2 |
Microsoft Power Automate Job
Microsoft Power Automate is a cloud-based service that enables you to create automated workflows between apps and services without extensive coding. It helps streamline repetitive tasks, such as approvals, notifications, data syncing, and file management across tools such as Microsoft 365, SharePoint, and third-party apps.
To create a Microsoft Power Automate job, see Creating a Job. For more information about this plug-in, see Control-M for Microsoft Power Automate.
The following table describes Microsoft Power Automate job attributes.
|
Attribute |
Description |
|---|---|
|
Connection Profile |
Determines the authorization credentials that are used to connect Control-M to Microsoft Power Automate, as described in Microsoft Power Automate Connection Profile Parameters. |
|
Environment ID |
Defines a unique identifier of the Microsoft Power Automate environment that contains the flow you want to trigger. Microsoft Power Automate environments separate different workspaces (for example: Development, Test, Production). |
|
Flow Name |
Defines the name of the Microsoft Power Automate flow that you want to execute. This value is populated in runtime. |
|
Endpoint URL |
Defines the full API endpoint to trigger the selected flow. |
|
Parameters |
Defines specific parameters in JSON format, to pass when the job executes, as shown in the following example: Copy
For no parameters, type {}. |
|
Fetch Detailed Logs |
Determines whether to retrieve detailed execution information after the flow runs. |
|
Status Polling Frequency |
(Optional) Determines the number of seconds to wait before checking the job status. Default: 60 |
|
Failure Tolerance |
Determines the number of times to check the job status before the job ends Not OK. Default: 3 |
Microsoft Power BI Job
The Microsoft Power BI job enables you to integrate Power BI workflows with your existing Control-M workflows.
To create a Microsoft Power BI job, see Creating a Job. For more information about this plug-in, see Control-M for Microsoft Power BI.
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, as described in Microsoft Power BI Connection Profile Parameters. |
|
Dataset Refresh/ Pipeline Deployment |
Determines one of the following options for execution in Power BI:
|
|
Workspace Name |
(Dataset) Defines a Power BI workspace where you want to refresh data. |
|
Workspace ID |
(Dataset) Defines the ID for the specified Power BI workspace (defined in the PowerBI Group Name). |
|
Dataset ID |
Defines a Power BI dataset to refresh in the specified workspace. This attribute is also known as the semantic model in Power BI. |
|
Parameters |
(Dataset, Enhanced Dataset Refresh) Defines specific parameters in JSON format, to pass when the job executes, as shown in the following example: Copy
For no parameters, type {}. For more information about available parameters, see Datasets - Refresh Dataset in the Microsoft Power BI documentation. To define parameters, the dataset must be in the Premium group. Format: {"param1":"value1", "param2":"value2"} For Enhanced Dataset Refresh, you must provide a value in the Parameters attribute. If you do not have parameters available, you must type the following: {"type":"Full"} |
|
Connection Timeout |
(Optional) Determines the maximum number of seconds to wait for REST API requests to respond, before disconnecting. Default: 60 |
|
Status Polling Frequency |
(Optional) Determines the number of seconds to wait before checking the job status. Default: 60 |
|
Pipeline ID |
Defines the ID of a Power BI pipeline to deploy for test and production. |
Microsoft Power BI SP Job
The Microsoft Power BI SP job enables you to utilize service principal authentication to integrate Power BI workflows with your existing Control-M workflows. Service principal authentication allows applications to access resources without exposing sensitive credentials.
To create a Microsoft Power BI SP job, see Creating a Job. For more information about this plug-in, see Control-M for Microsoft Power BI SP.
The following table describes Microsoft Power BI SP job attributes.
|
Attribute |
Action |
Description |
|---|---|---|
|
Connection Profile |
All |
Determines the authorization credentials to connect Control-M to Microsoft Power BI, as described in Microsoft Power BI SP Connection Profile Parameters. |
|
Action |
|
Determines one of the following execution options in Power BI:
|
|
Workspace ID |
|
Defines the ID for the specified Power BI workspace (defined in the PowerBI Group Name). |
|
Workspace ID - SP |
|
Defines the ID for the specified Power BI SP workspace (defined in the PowerBI Group Name). |
|
Dataset ID |
Dataset Refresh |
Defines a Power BI dataset to refresh in the specified workspace. This attribute is also known as the semantic model in Power BI. |
|
Dataset ID - SP |
Dataset Refresh - Service Principal |
Defines a Power BI SP dataset to refresh in the specified workspace. This attribute is also known as the semantic model in Power BI. |
|
Dataflow ID |
Dataflow Refresh |
Defines a unique identifier assigned to a dataflow within the Power BI service. A dataflow is a collection of tables that are created and managed in Workspaces in the Power BI service. |
|
Dataflow ID - SP |
Dataflow Refresh - Service Principal |
Defines a unique identifier assigned to a dataflow within the Power BI SP service. A dataflow is a collection of tables that are created and managed in Workspaces in the Power BI SP service. |
|
Pipeline ID |
Pipeline Deployment |
Defines the ID of a Power BI pipeline to deploy for test and production. |
|
Pipeline ID - SP |
Pipeline Deployment - Service Principal |
Defines the ID of a Power BI SP pipeline to deploy for test and production. |
|
Parameters |
|
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 the Premium group. Format: {"param1":"value1", "param2":"value2"} Copy
For no parameters, type {}. Default: {} |
|
Enhanced Parameters |
|
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 the Premium group. Format: {"param1":"value1", "param2":"value2"} Copy
Default: {"type":"Full"} |
|
Status Polling Frequency |
All |
(Optional) Determines the number of seconds to wait before checking the job status. Default: 60 |
| Failure Tolerance | All |
Determines the number of times to check the job status before the job ends Not OK. Default: 2 |
Qlik Cloud Job
Qlik Cloud supports Qlik Cloud Data Services, a cloud-based extract, transform, load (ETL) service, and enables you to visualize your data with Qlik Sense.
To create a Qlik Cloud job, see Creating a Job. For more information about this plug-in, see Control-M for Qlik Cloud.
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, as described in Qlik Cloud Connection Profile Parameters. 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 job status. Default: 10 |
|
Tolerance |
Determines the number of times to check the job status before the job ends 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.
To create a Tableau job, see Creating a Job. For more information about this plug-in, see Control-M for Tableau.
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, as described in Tableau Connection Profile Parameters. 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 job status. Default: 30 |
|
Failure Tolerance |
Determines the number of times to check the job status before the job ends Not OK. Default: 1 |
