Business Intelligence and Analytics Jobs

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

Rules:

• Characters: 1−30

• Case Sensitive: Yes

• Invalid Characters: Blank spaces.

Determines the ID of the AWS QuickSight job that is created in an AWS 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 status of the job.

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 file name, with options as follows:

• Use the report name: 

• Specify a file name: Names the file as you define. If the file name 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 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

(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 data set that you want to refresh under the specified workspace.

(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 the Premium group.

Format: {"param1":"value1", "param2":"value2"}

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

For no parameters, type {}.

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

Default: 10

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

Default: 10

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

• Dataset Refresh - Service Principal

• Dataflow Refresh - Service Principal

• Pipeline Deployment - 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.

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

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

For no parameters, type {}.

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

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 status of the job.

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, including those in Excel, *.pdf, and *.csv format.

• 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 status of the job.

Default: 30