Creating a metadata connection to ADW - 7.2

Oracle

Version
7.2
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components > Oracle components
Data Quality and Preparation > Third-party systems > Database components > Oracle components
Design and Development > Third-party systems > Database components > Oracle components

Procedure

  1. In Talend Studio, expand Metadata in the Repository view, right-click DB connections, and select Create connection from the context menu.
    The Database Connection (Step 1/2) dialog box appears.
  2. Enter the connection name (ADWC_test in this example) in the Name field and click Next.

    The Database Connection (Step 2/2) dialog box appears.

  3. Fill the fieds with your credentials in the Database Connection (Step 2/2) dialog box as prompted.

    To allow for secure connection, select Oracle Custom from the Db Type drop-down list and Oracle 12 from the Db Version drop-down list.

    The following gives a sample string of connection. Click JDBC Thin Connections and Wallets for related information.
    dbname_high= (description=
                      (address=(protocol=tcps)(port=1522)(host=adw.example.oraclecloud.com))(connect_data=(service_name=adw_jdbctest_high.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adw.oraclecloud.com,OU=Oracle
                      US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))
  4. Select the Use SSL Encryption option and then select the Need Client Authentication option.
  5. Fill the Trust Store Path field by clicking Browse... to the right of the field, navigating to the directory where the client credentials file (Wallet) is uncompressed, and selecting cwallet.sso, leaving Trust Store Password empty.
  6. Fill the Key Store Path field by clicking Browse... to the right of the field, navigating to the directory where the client credentials file (Wallet) is uncompressed, and selecting cwallet.sso, leaving Key Store Password empty.
  7. Click Test connection.

    A message box appears indicating that the connection is successful. You can now use this DbConnection object in your job design canvas to connect to ADW.

    If a dialog box appears prompting that third-party modules are required, click Download and install all modules available to install the modules and then click Test connection again.