Business Intelligence and Analytics Jobs

Determines the authorization credentials that are used to connect Control-M to Amazon QuickSight, as described in Amazon QuickSight Connection Profile Parameters.

Rules:

• Characters: 1−30

• Case Sensitive: Yes

• Invalid Characters: Blank spaces.

Determines the ID of the Amazon QuickSight job that is created in an Amazon QuickSight workspace.

Determines which of the following refresh functions to perform:

• Full Refresh: Updates the entire data set, which refreshes all the rows in the table.

• Incremental Refresh: Adds the rows that have not been imported to the table.

(Optional) Determines the number of seconds to wait before checking the job status.

Default: 30

Determines the authorization credentials that are used to connect Control-M to IBM Cognos, as described in IBM Cognos Connection Profile Parameters.

Rules:

• Characters: 1−30

• Case Sensitive: Yes

• Invalid Characters: Blank spaces.

For more information about creating a local connection profile for this job, see Creating a connection profile.

Defines the path and name of the job that you want to execute.

Rules:

• Characters: 1−4,096
• Case sensitive: Yes

Variable Name: %%JOBNAME

Defines the path and name of the job that you want to execute in a readable format.

Rules:

• Characters: 1−4,096
• Case sensitive: Yes

Variable Name: %%COGNOS-LOCATION

Defines the type of job, which can be job, report, or reportView.

Rule: Case sensitive

Variable Name: %%COGNOS-TYPE

Determines the values of the IBM Cognos prompt in the selected report or reportView as follows:

• Name: Indicates the name of the prompt

  Variable Name: %%COGNOS-REPORT_PARAMS-P001-PRM_NAME

• Type: Indicates the type of prompt

  Variable Name: %%COGNOS-TYPE

• Multi:

• Required: 

• Range: 

• Value: 

• Description: 

Defines if the report is executed as a burst report.

Variable Name: %%COGNOS-BURST_REPORT

Defines what Control-M does with the IBM Cognos job output.

Determines the report output format in one or more of the following options:

• CSV
• HTML
• MHT
• PDF
• SingleXLS
• spreadsheetML
• XHTML
• XLS
• XLWA
• XML

Determines whether the report is saved to the Cognos server or as a report view, as follows:

• To Cognos Server: Saves the report at the default location on the Cognos server.

  Variable Name: %%COGNOS-DEST-SAVE_REPORT-SERVER

• As Report View: Saves the report as a report view with the name and location that you define.

  Variable Name: %%COGNOS-DEST-SAVE_REPORT-VIEW

Defines the report view name when As Report View is selected.

Rule: Case sensitive.

Variable Name: %%COGNOS-DEST-SAVE_REPORT-VIEW_NAME

Defines the report archive system file location.

Variable Name: %%COGNOS-DEST-FILE-DIR

Determines the filename, with options as follows:

• Use the report name: 

• Specify a file name: Defines the filename. If the filename is empty, the default report name is used.

  Variable Name: %%COGNOS-DEST-FILE-NAME

Determines the authorization credentials that are used to connect Control-M to Microsoft Power Automate, as described in Microsoft Power Automate Connection Profile Parameters.

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).

Defines the name of the Microsoft Power Automate flow that you want to execute.

This value is populated in runtime.

Defines the full API endpoint to trigger the selected flow.

Defines specific parameters in JSON format, to pass when the job executes, as shown in the following example:

{
  "requestId": "8f3c2b91-3d7e-4d44-a3e2-91f7a1d12abc",
  "timestamp": "2026-03-26T12:30:00Z",
  "action": "CreateCustomer",
  "data": {
    "id": 100245,
    "name": "Asaf",
    "email": "[email protected]"
  }
}

For no parameters, type {}.

Determines whether to retrieve detailed execution information after the flow runs.

(Optional) Determines the number of seconds to wait before checking the job status.

Default: 60

Determines the authorization credentials that are used to connect Control-M to Microsoft Power BI, as described in Microsoft Power BI Connection Profile Parameters.

Determines one of the following options for execution in Power BI:

• Dataset Refresh

• Pipeline Deployment

• Enhanced Dataset Refresh

(Dataset) Defines a Power BI workspace where you want to refresh data.

(Dataset) Defines the ID for the specified Power BI workspace (defined in the PowerBI Group Name).

Defines a Power BI dataset to refresh in the specified workspace.

This attribute is also known as the semantic model in Power BI.

(Dataset, Enhanced Dataset Refresh) Defines specific parameters in JSON format, to pass when the job executes, as shown in the following example:

{
  "type":"Defragment",
  "commitMode":"transactional",
  "maxParallelism":20,
  "retryCount":2,
  "objects":[
      {"table":"Contributions"},
      {"table":"Traffic_Popular"}
    ]
}

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"}

(Optional) Determines the maximum number of seconds to wait for REST API requests to respond, before disconnecting.

Default: 60

(Optional) Determines the number of seconds to wait before checking the job status.

Default: 60

Determines the authorization credentials to connect Control-M to Microsoft Power BI, as described in Microsoft Power BI SP Connection Profile Parameters.

Determines one of the following execution options in Power BI:

• Dataset Refresh

• Dataflow Refresh

• Pipeline Deployment

• Enhanced Dataset Refresh (recommended)

• Dataset Refresh - Service Principal

• Dataflow Refresh - Service Principal

• Pipeline Deployment - Service Principal

• Enhanced Dataset Refresh - Service Principal

Defines the ID for the specified Power BI workspace (defined in the PowerBI Group Name).

Defines the ID for the specified Power BI SP workspace (defined in the PowerBI Group Name).

Defines a Power BI dataset to refresh in the specified workspace.

This attribute is also known as the semantic model in Power BI.

Defines a Power BI SP dataset to refresh in the specified workspace.

This attribute is also known as the semantic model in Power BI.

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.

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.

Defines the ID of a Power BI pipeline to deploy for test and production.

Defines the ID of a Power BI SP pipeline to deploy for test and production.

(Deprecated) Defines specific parameters, in JSON format, to pass when the job executes.

Do not enter parameters. Instead, use the default {} (no 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"}

• For the Type parameter, enter one of the following:
  Automatic: Refresh and recalculate the object and its dependents. Use this type if the partition is in a state other than Ready.

• Full:Refresh the data and recalculate all partitions in the partition, table, or database that you specify. Use this type for a calculation partition.

For more information and options, see DatasetRefresh Type in the Microsoft Power BI documentation.

{
  "type":"Automatic",
  "commitMode":"transactional",
  "maxParallelism":20,
  "retryCount":2,
}

Default: {"type":"Automatic"}

(Optional) Determines the number of seconds to wait before checking the job status.

Default: 60

Determines the authorization credentials that are used to connect Control-M to Qlik Cloud, as described in Qlik Cloud Connection Profile Parameters.

Rules:

• Characters: 1−30

• Case Sensitive: Yes

• Invalid Characters: Blank spaces.

Determines one of the following options to load data into the environment:

• Full: Deletes all the tables in the current environment and reloads the data from the data sources.

• Partial: Keeps the tables in the current environment and executes the Load and Select statements, preceded by an Add, Merge, or Replace prefix.

Defines the Qlik Sense app name, which contains one or more workspaces, called sheets.

Determines whether the job logs are included in the Control-M output.

Determines the number of seconds to wait before checking the job status.

Default: 10

Determines the authorization credentials that are used to connect Control-M to Tableau, as described in Tableau Connection Profile Parameters.

Rules:

• Characters: 1−30

• Case Sensitive: Yes

• Invalid Characters: Blank spaces.

Determines one of the following Tableau actions to perform:

• Refresh Data Source: Updates the Tableau workflow with the most recent version of a data source.

• Run Flow: Executes the Tableau workflow.

Defines the name of the data source that is refreshed.

Tableau can connect to the following types of data sources:

• Files, such as CSV, PDF, or XLSX (Excel) files.

• Databases, such as Oracle, SQL Server, and DB2.

• Cloud storage, such as Azure, GCP, and AWS.

(Optional) Determines the number of seconds to wait before checking the job status.

Default: 30