Business Intelligence and Analytics Jobs

Determines the authorization credentials that are used to connect Control-M to AWS QuickSight.

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 Microsoft Power BI.

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

• Dataset Refresh

• Pipeline Deployment

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

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

Defines a Power BI data set that you want to refresh under the specified workspace.

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

{
  "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 that are used to connect Control-M to Qlik Cloud .

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.

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, Excel, and PDF.

• 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