Data Integration Connection Profiles

The following topics describe connection profiles for data integration platforms and services:

ConnectionProfile:Airbyte

Airbyte is an open-source extract, transform, and load (ETL) service that enables you to build data pipelines and load data to a data warehouse, data lake, database, or analytics tool of your choice.

For more information, see Control-M for Airbyte.

The following example shows how to define an Airbyte connection profile:

Copy 
"Airbyte": 
{
   "Type": "ConnectionProfile:Airbyte",
   "Airbyte URL": "https://api.airbyte.com",
   "API Key": "your_api_key_here",
   "Connection Timeout": "10",
   "Description": "",
   "Centralized": true
}

Parameter

Description

Airbyte URL

Defines the Airbyte authentication endpoint.

Default: https://api.airbyte.com

API Key

Defines the Airbyte account access key, which is available on the Airbyte Developer Portal. You can use Secrets in Code to hide this value in the code.

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to Airbyte before a timeout occurs.

Default: 20

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:AWS Glue

Amazon Web Services (AWS) Glue, a serverless data integration service, enables you to define data-driven workflows that automate the movement and transformation of data.

The following examples show how to define an AWS Glue connection profile:

  • This JSON-based connection profile authenticates with an AWS access key and secret.

    Copy 
    "GLUECONNECTION": 
    {
       "Type": "ConnectionProfile:AWS Glue",
       "AWS Access key ID": "MYAWSACCESSKEY1234",
       "AWS Secret": "myAwsSecret12345",
       "Authentication": "SECRET",
       "AWS Region": "eu-west-2",
       "Glue url": "glue.eu-west-2.amazonaws.com",
       "Connection Timeout": "40",
       "Description": "",
       "Centralized": true
    }

  • This JSON-based connection profile authenticates with an AWS IAM role from inside an EC2 instance.

    Copy 
    "GLUECONNECTIONIAM": 
    {
       "Type": "ConnectionProfile:AWS Glue",
       "IAM Role": "GLUEEC2IAMROLE",
       "Authentication": "NOSECRET",
       "AWS Region": "eu-west-2",
       "Glue url": "glue.eu-west-2.amazonaws.com",
       "Connection Timeout": "40",
       "Description": "",
       "Centralized": true
    }

The following table describes the AWS Glue connection profile parameters.

Parameter

Description

Authentication

Determines the type of authentication to use for the connection with AWS Glue, one of the following:

  • SECRET: Authenticates with an AWS access key and secret.

  • NOSECRET: Authenticates with an AWS IAM role from inside an EC2 instance.

AWS Access key ID

(SECRET authentication) Defines the access key ID for connection to AWS.

AWS Secret

(SECRET authentication) Defines the secret access key for connection to AWS. You can use Secrets in Code to hide this value in the code.

IAM Role

(NOSECRET authentication) Defines the identity and Access Management (IAM) role for connection to AWS.

AWS Region

Determines the AWS Glue service region.

Glue url

Defines the URL of an AWS Glue service regional endpoint.

For more information about regional endpoints available for the AWS Glue service, refer to the AWS documentation.

Connection Timeout

Defines the timeout value, in seconds, for the trigger call made by Control-M to AWS Glue.

Default: 40

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:AWS Glue DataBrew

Amazon Web Services (AWS) Glue DataBrew, a cloud-based ETL service, enables you to visualize your data and publish it to the Amazon S3 Data Lake.

The following examples show how to define an AWS Glue DataBrew connection profile:

  • This JSON-based connection profile authenticates with an AWS access key and secret.

    Copy 
    "AWSDATABREW":
    {
       "Type": "ConnectionProfile:AWS Glue DataBrew",
       "Authentication": "SECRET", 
       "AWS Access Key": "MYAWSACCESSKEY1234",
       "AWS Secret": "myAwsSecret12345",
       "AWS Region": "us-east-1",
       "AWS Logs URL": "https://logs.{{AWSRegion}}.amazonaws.com",
       "AWS API Base URL": "https://databrew.{{AWSRegion}}.amazonaws.com",
       "Connection Timeout": "30",
       "Description": "",
       "Centralized": true
    }

  • This JSON-based connection profile authenticates with an AWS IAM role from inside an EC2 instance.

    Copy 
    "AWSDATABREW": 
    {
       "Type": "ConnectionProfile:AWS Glue DataBrew",
       "Authentication": "NOSECRET", 
       "IAM Role": "IAMROLE", 
       "AWS Region": "us-east-1",
       "AWS API Base URL": "https://databrew.{{AWSRegion}}.amazonaws.com",
       "AWS Logs URL": "https://logs.{{AWSRegion}}.amazonaws.com",
       "Connection Timeout": "30",
       "Description": "",
       "Centralized": true
    }

The following table describes the AWS Glue DataBrew connection profile parameters.

Parameter

Description

Authentication

Determines one of the following authentication methods for the connection with AWS Glue DataBrew:

  • SECRET: Authenticates with an AWS access key and secret.

  • NOSECRET: Authenticates with an AWS IAM role from inside an EC2 instance.

AWS Access Key

(SECRET authentication) Defines the AWS Glue DataBrew account access key.

AWS Secret

(SECRET authentication) Defines the AWS Glue DataBrew account secret access key. You can use Secrets in Code to hide this value in the code.

IAM Role

(NOSECRET authentication) Defines the Identity and Access Management (IAM) role for connection to AWS.

AWS Region

Determines the region that the AWS Glue DataBrew jobs are located in.

AWS API Base URL

Defines the REST API URL for the AWS Glue DataBrew regional endpoint, as follows:

https://databrew.<AWSRegion>.amazonaws.com

For more information about regional endpoints available for the AWS Glue DataBrew service, refer to the AWS documentation.

AWS Logs URL

Defines the AWS Logs URL, as follows:

https://logs.<AWSRegion>.amazonaws.com

Connection Timeout

Determines the number of seconds to wait before a timeout occurs after Control-M initiates a request to AWS Glue DataBrew.

Default: 30

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:ADF (Azure Data Factory)

Azure Data Factory (ADF), a cloud-based ETL and data integration service, allows you to create data-driven workflows to automate the movement and transformation of data.

The following examples show how to define an ADF connection profile:

  • This JSON-based connection profile authenticates with an Azure service principal.

    Copy 
    "ADF_SERVPRINC":
    {
       "Type": "ConnectionProfile:ADF",
       "Tenant ID": "tenantId",
       "Identity Type": "PRINCIPAL",
       "Client Secret": "*****",
       "Application ID": "applicationId",
       "Subscription ID": "subscriptionId",
       "Connection Timeout": "40",
       "Description": "",
       "Centralized": true
    }

  • This JSON-based connection profile authenticates with a managed identity.

    Copy 
    "ADF_MANID":
    {
       "Type": "ConnectionProfile:ADF",
       "Identity Type": "MANAGEDID",
       "Specify Managed Identity Client ID": "&client_id=",
       "Managed Identity Client ID": "72d448f0-ac32-45ea-9158-f8653e4ee16",  
       "Subscription ID": "subscriptionId",
       "Connection Timeout": "40",
       "Description": "",
       "Centralized": true
    }

The following table describes the ADF connection profile parameters.

Parameter

Description

Identity Type

Determines the type of authentication to use for the connection with the Azure Data Factory, one of the following:

  • PRINCIPAL: Authenticates with a service principal.

  • MANAGEDID: Authenticates with a managed identity.

Specify Managed Identity Client ID

(Managed identity) Determines whether the client ID for your managed identity is specified by the Managed Identity Client ID parameter.

Include this parameter only if you are using the managed identity authentication method and you have multiple managed identities defined on your Azure virtual machine. Set its value to &client_id=.

Managed Identity Client ID

(Managed identity) Determines which client ID to use as the managed identity.

This parameter requires a value only if you have multiple managed identities defined on your Azure virtual machine and you included the Specify Managed Identity Client ID parameter.

If you have only one managed identity, it is detected automatically.

Tenant ID

(Service principal) Defines the Azure tenant ID where the Azure Data Factory was created.

Client Secret

(Service principal authentication) Defines the client secret associated with the service principal. You can use Secrets in Code to hide this value in the code.

Application ID

(Service principal authentication) Defines the ID of the Azure-registered application that is used to interact with the Azure Data Factory.

Subscription ID

Defines the Azure account subscription ID.

The subscription ID can be retrieved from the Azure portal by selecting the Subscription menu.

Connection Timeout

Defines a timeout value, in seconds, for the trigger call made by Control-M to the Azure Data Factory.

Default: 40

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:Boomi

Boomi enables the integration of Boomi processes with your existing Control-M workflows.

The following example shows how to define a Boomi connection profile:

Copy 
"BOOMICCP": 
{
   "Type": "ConnectionProfile:Boomi",
   "AccountId": "*****",
   "API Token": "*****",
   "End Point": "https://api.boomi.com",
   "API Username": "BOOMI_TOKEN.BoomiUsername",
   "Description": "",
   "Centralized": true
}

The following table describes the Boomi connection profile parameters.

Parameter

Description

AccountId

Defines a unique Boomi account ID.

API Token

Defines a Boomi API Token of a Boomi user for connection to the Boomi endpoint. You can use Secrets in Code to hide this value in the code.

End Point

Defines the Boomi API endpoint:

https://api.boomi.com

API Username

Defines the Boomi username in email format, as follows:

BOOMI_TOKEN.<Boomi_username>@<email_suffix>

[email protected]

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:GCPDF (GCP Data Fusion)

GCPDF (GCP Data Fusion) enables you to load data from multiple sources, visualize it, and publish it to the cloud.

The following example shows how to define a GCPDF connection profile. In the following example, authentication is based on a service account:

Copy 
"GCP Cloud Data Fusion":
{
   "Type": "ConnectionProfile:GCPDF",
   "Identity Type": "service_account",
   "GCP Data Fusion URL": "https://datafusion.googleapis.com",
   "Service Account Key": "*****",
   "Connection Timeout": "20",
   "Description": "",
   "Centralized": true
}

The following table describes the GCPDF connection profile parameters.

Parameter

Description

Identity Type

Determines one of the following authentication types using GCP Access Control:

  • service_account: Authenticates with an application ID (service account) and client secret.

  • os_user: Authenticates based on a detected IAM role, which removes the need to provide additional credentials.

GCP API URL

(Service account) Defines the Google Cloud Platform (GCP) authentication endpoint for GCP Data Fusion, as follows:

https://datafusion.googleapis.com

Service Account Key

(Service account) Defines a service account that is associated with an RSA key pair. You can use Secrets in Code to hide this value in the code.

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to GCP Data Fusion before a timeout occurs.

Default: 20

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:GCP Dataplex

GCP Dataplex is an extract, transform, and load (ETL) service that enables you to visualize and manage data in GCP BigQuery and the cloud.

The following examples show how to define a GCP Dataplex connection profile:

  • This JSON defines a connection profile based on a Service Account.

    Copy 
    "GCP_DATAPLEX_SERVICE_ACCOUNT": 
    {
       "Type": "ConnectionProfile:GCP Dataplex",
       "Identity Type": "service_account",
       "GCP Dataplex URL": "https://dataplex.googleapis.com ",
       "Service Account Key": "*****",
       "Connection Timeout": "30",
       "Description": "",
       "Centralized": true
    }

  • This JSON defines a connection profile based on IAM.

    Copy 
    "GCP_DATAPLEX_IAM": 
    {
       "Type": "ConnectionProfile:GCP Dataplex",
       "Identity Type": "os_user",
       "GCP Dataplex URL": "https://dataplex.googleapis.com",
       "Connection Timeout": "30",
       "Description": "",
       "Centralized": true
    }

The following table describes the GCP Dataplex connection profile parameters.

Parameter

Description

Identity Type

Determines one of the following authentication types using GCP Access Control:

  • service_account: Authenticates with an application ID (service account) and client secret.

  • os_user: Authenticates based on a detected IAM role, which removes the need to provide additional credentials.

GCP Dataplex URL

Defines the Google Cloud Platform (GCP) authentication endpoint for GCP Dataplex.

https://dataplex.googleapis.com

Service Account Key

(Service account) Defines a service account that is associated with an RSA key pair. You can use Secrets in Code to hide this value in the code.

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to GCP Dataplex before a timeout occurs.

Default: 20

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:GCP Dataprep

GCP Dataprep enables you to visualize, format, and prepare your data for analysis.

The following example shows how to define a GCP Dataprep connection profile:

Copy 
"GCP_DATAPREP":
{
   "Type": "ConnectionProfile:GCP Dataprep",
   "GCP Dataprep URL": "https://api.clouddataprep.com",
   "User Access Token": "*****",
   "Connection Timeout": "30",
   "Description": "",
   "Centralized": true
}

The following table describes GCP Dataprep connection profile parameters.

Parameter

Description

GCP Dataprep URL

Defines the GCP Dataprep API authentication endpoint for Dataprep, as follows:

https://api.clouddataprep.com

User Access Token

Defines a token that enables you to authenticate Control-M and connect to your GCP Dataprep account. You can use Secrets in Code to hide this value in the code.

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to GCP Dataprep before a timeout occurs.

Default: 30

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:Informatica

Informatica enables you to automate tasks or workflows based on the parameters that you define.

The following example shows how to define an Informatica connection profile:

Copy 
"INFORMATICA_CONNECTION": 
{
   "Type": "ConnectionProfile:Informatica",
   "TargetAgent": "AgentHost",
   "TargetCTM": "CTMHost",
   "Host": "InformaticaHost",
   "Port": "7333",
   "User": "UserName",
   "Password": "Password",
   "PowerCenterDomain": "DomainName",
   "Repository": "RepositoryName",
   "IntegrationService": "ServiceName",
   "SecurityDomain": "Native",
   "ConnectionType": "HTTP",
   "MaxConcurrentConnections": "100",
   "Centralized": false
}

The following table describes the Informatica connection profile parameters.

Parameter

Description

TargetAgent

Determines the Agent where the connection profile deploys.

TargetCTM

Determines the Control-M/Server where the connection profile deploys. If there is only one Control-M/Server, it defaults to that Control-M/Server.

Host

Defines the name of the Informatica web services server.

Port

(Optional) Defines the port number of the Informatica web services server.

Valid Values: 1–65,535

Default: 7,333

User

Defines the name of a user to log into the Repository.

Password

Defines a password to log into the Repository.

You can use Secrets in Code to hide this value in the code.

PowerCenterDomain

Defines the name of the Informatica server that contains the repository service.

Repository

Defines the name of the repository where the repository folders and workflows are located.

IntegrationService

Defines the name of the integration service to use to run the workflows.

SecurityDomain

Defines the name of a security domain, a collection of user accounts and groups in a Power Center Domain.

If the user name belongs to the native security domain, this parameter is optional, and the default is an empty value.

If the user name belongs to an LDAP security domain, this parameter is required.

ConnectionType

(Optional) Determines the protocol for the connection to the Informatica server.

Valid Values:

  • HTTP

  • HTTPS

MaxConcurrentConnections

(Optional) Defines the maximum number of allowed concurrent workflows in the connection profile.

Valid Values: 1–512

Default: 10

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:Informatica CS

Informatica Cloud Services (CS) enables you to automate your Informatica workflows for multi-cloud and on-premises data integration through the Control-M environment.

The following example shows how to define an Informatica CS connection profile:

Copy 
"INFORMATICA_CS_CONNECTION": 
{
   "Type": "ConnectionProfile:Informatica CS",
   "Login URL": "https://dm-us.informaticacloud.com",
   "Base URL": "https://usw5.dm-us.informaticacloud.com", 
   "Username": "UserName",  
   "Password": "Password", 
   "Request Timeout": "3", 
   "Description": "", 
   "Centralized": true 
}

The following table describes the Informatica CS connection profile parameters.

Parameter

Description

Login URL

Defines the URL for login calls to Informatica Cloud.

Base URL

Defines the instance name of the Informatica Cloud server.

Username

Defines a username for the account to connect to Informatica Cloud.

Password

Defines a password for the login to Informatica Cloud.

You can use Secrets in Code to hide this value in the code.

Request Timeout

A timeout value, in seconds, for the requests sent to Informatica Cloud.

Default: 3

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

Connection Profile:OCI Data Integration

OCI Data Integration is an Oracle Cloud Infrastructure (OCI) platform, that enables data extraction, transformation, and loading (ETL) processes across various sources and targets within the Oracle Cloud.

For more information about this plug-in, see Control-M for OCI Data Integration..

The following example shows how to define an OCI Data Integration connection profile, that authenticates with DefineParameters:

Copy 
"ODI": 
{
   "Type": "ConnectionProfile:OCI Data Integration",
   "OCI Data Integration URL": "https://dataintegration.us-phoenix-1.oci.oraclecloud.com",
   "OCI Region": "us-phoenix-1",
   "Authentication": "DefineParameters",
   "User OCID": "ocid1.user.oc1..aaafdgfgaat56ecah7yw7ebl6pffgh678758kdsfsdf44787zp2dzsa4k2qyxn45wtaa",
   "Tenancy OCID": "ocid1.tenancy.oc1..aaadfghgaaak445azt6b2346uvi2afhgghfghhhtryradsaasdasd",
   "Fingerprint": "67:45:eb:c6:16:h3:67:s6:fd:ac:gf:a6:7q:ad:bb:2f",
   "Private Key": "*****",
   "Description": "",
   "Connection Timeout": "30",
   "Centralized": true
}

The following table describes OCI Data Integration connection profile parameters.

Parameter

Authentication Method

Description

OCI Data Integration URL

All methods

Defines the OCI Data Integrations URL in the following format:

https://dataintegration.<region>.oci.oraclecloud.com

OCI Region

All methods

Determines the region where the OCI Data Integration is located.

Authentication

All methods

Determines one of the following authentication methods:

  • DefineParameters: Defines authentication parameters in the connection profile.

  • ConfigurationFile: Uses a configuration file that contains authentication information and is stored on the Control-M/Agent.

    The following example of a configuration file defines the DEFAULT profile for Linux and the PROFILE2 profile for Windows.

    Copy 
    [DEFAULT] 
    user=ocid1.user.oc1..aaaaaaaa4vcihdfhrdtyry457245636cqqcljd6yrcukszg7gzoymoyvkyupivpjfnq
    tenancy=ocid1.tenancy.oc1..aaa456y4e3yrtyue9f8djfihhwp2cu4e6t2b7lttna7rcgnhrdi4qzika
    fingerprint=9f:af:df:f5:5g:95:92:7c:34:ab:46:d3:b4:30:e6:9e
    region=us-phoenix-1
    key_file=/home/dbauser/key.pem 

    [PROFILE2] 
    user=ocid1.user.oc1..aaaaaaaa4v768679dfhrd8989JHGJG36cqqcljd6yrcukszg7gzoymoyvkyupivpjfnq
    tenancy=ocid1.tenancy.oc1..aaa456y4e3yrtyue987erum,gfwp2cu4e6t2b7lttna7rcgnhrdi4qzika
    fingerprint=9f:af:c0:f5:7b:95:92:7c:03:a5:46:g3:b4:38:e6:9e
    region=us-phoenix-1
    key_file=C:\\Users\\dbauser\\key.pem

User OCID

All methods

Defines an individual user within the OCI environment.

Tenancy OCID

DefineParameters

Defines the OCI Tenacy ID in the OCI Data Integration, which is a global unique identifier for this account within the OCI environment.

Fingerprint

DefineParameters

Defines fingerprint to uniquely identify and verify the integrity of the associated certificate or key.

Private Key

DefineParameters

Defines the Private key within a set of API signing keys that are used for authentication and secure access to OCI resources. You can use Secrets in Code to hide this value in the code.

Config File Path

ConfigurationFile

Defines the path to the configuration file that contains authentication information. This file is stored on the Control-M/Agent.

UNIX: home/user/config/pem.pem

Windows: C:\Users\user1\config\\pem.pem

Profile

ConfigurationFile

Defines the name of a specific section in the configuration file, such as DEFAULT and PROFILE2 in the Configuration File code sample.

Connection Timeout

All methods

Determines the number of seconds to wait after Control-M initiates a connection request to OCI Data Integration before a timeout occurs.

Default: 20

Centralized

All methods

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:Talend Data Management

Talend Data Management is an automation service that enables you to integrate applications, and extract, transform, load, and check the quality of large amounts of data.

The following example shows how to define a Talend connection profile:

Copy 
"TALENDDATA":
{
   "Type": "ConnectionProfile:Talend Data Management",
   "API URL": "https://api.eu.cloud.talend.com/tmc/v2.6",
   "Personal access token authorization": "*****",
   "Description": "Talend Data Management",
   "Centralized": true
}

The following table describes the Talend connection profile parameters.

Parameter

Description

API URL

Defines the authentication endpoint base URL for the Talend Cloud Management Console, as follows:

https://api.<Region>.cloud.talend.com/tmc/v2.6

where <Region> is one of the following values:

  • us: Eastern United States

  • eu: Europe

  • us-west: Western United States

  • au: Australia

  • ap: Asia

https://api.eu.cloud.talend.com/tmc/v2.6

Personal access token authentication

Defines a Talend token for authentication of connections to Talend.

You generate this token through your Talend profile.

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

Connection Profile:Talend OAuth

Talend OAuth (Open Authorization) enables you to use OAuth authentication within the Talend suite of data integration and management tools. It allows third-party applications to access resources on behalf of a user without sharing sensitive credentials.

The following example shows how to define a Talend OAuth connection profile:

Copy 
"TALEND":
{
   "Type": "ConnectionProfile:Talend OAuth",
   "Talend API URL": "https://api.eu.cloud.talend.com",
   "Region": "eu",
   "Client ID": "D4leqpN21SrsebBqbBBTKHUnccsizUdebrdbaasfwfw",
   "Client Secret": "*****",
   "Connection Timeout": "30",
   "Description": "",
   "Centralized": true
}

The following table describes the Talend OAuth connection profile parameters.

Parameter

Description
Talend API URL

Defines the authentication endpoint base URL for the Talend Cloud Management Console, as follows.

https://api.<region>.cloud.talend.com

Region

Determines one of the following regions where the Talend jobs are located:

  • eu: Europe

  • us: Eastern United States

  • us-west: Western United States

  • au: Australia

  • ap: Asia

Default: eu

Client ID

Defines the client ID is used to get an OAuth2 JWT access token through the Client ID Grant flow.

Client Secret

Defines the Client Secret (password) that is used to get an OAuth2 JWT access token through the Client Secret Grant flow. You can use Secrets in Code to hide this value in the code.

Connection Timeout

Determines the number of seconds to wait after Control-M initiates a connection request to Talend before a timeout occurs.

Default: 30

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false

ConnectionProfile:TRIFACTA

Alteryx Trifacta is a data-wrangling platform that allows you to discover, organize, edit, add to, and publish data in different formats and to multiple clouds, including AWS, Azure, Google, Snowflake, and Databricks.

The following example shows how to define an Alteryx Trifacta connection profile:

Copy 
"TRIFACTA":
{
   "Type": "ConnectionProfile:TRIFACTA",
   "Trifacta URL": "https://cloud.trifacta.com",
   "User Name": "User Name",
   "Password": "Password",
   "Connection Timeout": "10",
   "Description": " ",
   "Centralized": true
}

The following table describes the Alteryx Trifacta connection profile parameters.

Parameter

Description

Trifacta URL

Defines the Alteryx Trifacta authentication endpoint, as follows:

https://cloud.trifacta.com

User Name

Defines the registered user name or email address for your Alteryx Trifacta account.

Password

Defines the password for the Alteryx Trifacta user. You can use Secrets in Code to hide this value in the code.

Connection Timeout

Determines the number of seconds to wait before a timeout occurs after Control-M initiates a connection request to Alteryx Trifacta.

Default: 10

Centralized

Determines whether to create a centralized connection profile, which is stored in the Control-M/EM database and is available to all Agents.

You must set this parameter to true.

Valid Values:

  • true: Creates a centralized connection profile.

  • false: Creates a local connection profile, which is associated with and stored on a specific Agent.

Default: false