search

airbytehq / airbyte

The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
https://airbyte.com
Other
16.27k stars 4.15k forks source link

Source/Destination Oracle: add option to provide custom TNS description #15793

Open mvanluytelaar opened 2 years ago

mvanluytelaar commented 2 years ago

Problem

When connecting to an oracle database, the current descriptor pattern as part of the JDBC-URL is not enough when dealing with failover scenario's or for instance mTLS connections requiring specific parameters which fail to parse when provided as additional JDBC-parameters.

Example: when connecting to an OCI hosted Autonomous database the following TNS-description is required;

description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=someregion.oraclecloud.com))(connect_data=(service_name=someservicename.oraclecloud.com))
  (security=
    (MY_WALLET_DIRECTORY = /tmp/airbyte_local/somewalletdir)   
    (ssl_server_cert_dn="CN=someregion.oraclecloud.com, OU=Oracle ADB AMSTERDAM, O=Oracle Corporation, L=Redwood City, ST=California, C=US")
   )

Currently there is no way to add extra security/failover options in the description. Suggestion is to add an optional field for entry of a custom TNS name description.

Description

In the web-GUI, on Oracle connections, an extra field is present allowing a custom TNS name description.

natalyjazzviolin commented 2 years ago

Hi @mvanluytelaar , could you please specify which Oracle connectors you've got in mind?

mvanluytelaar commented 2 years ago

Hi @mvanluytelaar , could you please specify which Oracle connectors you've got in mind?

I am referring to the Oracle DB connector, source and destination