Example: Creating a custom connection for Amazon RDS for Oracle - Cloud

Talend Management Console User Guide

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Management Console
Content
Administration and Monitoring > Managing projects
Administration and Monitoring > Managing users
Deployment > Deploying > Executing Pipelines
Deployment > Deploying > Executing Tasks
Deployment > Scheduling > Scheduling Tasks
Last publication date
2024-02-29
Set up a custom connection for an artifact that interacts with Amazon RDS for Oracle.

Before you begin

  • You must have the Manage permission enabled for the workspace where the connection is stored.
  • Ensure that the connection to be matched in Talend Studio does not use \ in its parameter values. When a connection needs to use \ to be interpreted as a special character, such as in \t, use \\ instead in both Talend Studio and Talend Management Console.

About this task

Note: The artifact published from Talend Studio must include connection_ parameters. Refer to the Talend Studio User Guide for more information.

Procedure

  1. Open the Management page.
  2. Go to the Connections tab.
  3. Select the environment using the faceted search at the top of the page.
  4. Click Add connection.
  5. In the Add new connection wizard, select the workspace in which to create the connection.
    The current workspace is selected by default.
  6. Select Custom connections from the Applications drop-down list.
  7. Change the Application Name to oracle.
  8. Enter Oracle as the connection name.
  9. Click Add parameter as many times as needed.
  10. Define the parameter keys and enter the parameter values specific to the connection.

    Example

    Parameter Key in Talend Studio Parameter Key in Talend Management Console Parameter Value
    connection_oracle_database database myawsoracledb
    connection_oracle_schema schema myawsoracleschema
    connection_oracle_host host localhost
    connection_oracle_port port 1521
    connection_oracle_username username awsuser
    connection_oracle_password password awspassword
  11. Click Save.

Results

The connection has been created in your workspace.