Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Example: Creating a custom Studio connection for Amazon RDS for Oracle

Set up a custom Studio connection for an artifact that interacts with Amazon RDS for Oracle.

Before you begin

  • You must have the Studio connections and Studio resources - Edit (TMC_CONNECTION_RESOURCE_EDIT) user permission and the Author workspace permission assigned 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

Information noteNote: 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 Studio connections tab.
  3. Select the environment using the faceted search at the top of the page.
  4. Click Add Studio connection.
  5. In the Add new Studio connection wizard, select the workspace in which to create the connection.
    The current workspace is selected by default.
  6. Select Custom Studio connections from the Applications dropdown list.
  7. Change the Application Name to oracle.
  8. Enter Oracle as the Studio connection name.
  9. Click Add parameter as many times as needed.
  10. Define the parameter keys and enter the parameter values specific to the Studio connection.

    Example

    The table presents an example of the parameter keys and their values.
    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 Studio connection has been created in your workspace.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here