Set up a connection to Oracle Autonomous Database – Celigo Help Center

Oracle Autonomous Database (ADB) is a cloud database that automatically tunes, secures, and manages data using machine learning. It is completely automated and performs these tasks without human intervention. You can use this connector to connect to Oracle Autonomous Datewarehouse (OADW).

Note: Celigo uses a JDBC connection to connect to Oracle ADB; we use the ojdbc10.jar. If you would like to connect to any application that supports this JAR file but is currently not available in our connector list, you're welcome to submit it as an idea on the Product portal.

Set up a connection

After you start the connection, configure it in the Create connection panel and complete all of the required * authentication settings:

Setting	Instructions
Name *	Enter a clear and distinguishable name for your connection. Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.
Host *	Enter the connection string/URL to connect to the server that hosts the database. For example, `<protocol>://<host>:<port>/[?<properties>]` `jdbc://localhost:5001/[?properties]` How to find host details Sign in to Oracle Cloud. In the navigation pane, click Oracle Database > Autonomous Database. Click an Autonomous Database instance. In the Autonomous Database details page, click Database connection. In the Database connection page, go to the Connection strings section. Then, in the Connection string column, click Show to view and copy the value. (Paste this string in the Host field in the Celigo platform.) Tip: Your host URL should start with `jdbc:oracle:thin://`. This is automatically prepended to the value you enter in the Host field if it's not included. Note that you must include "@" before you enter your value. For example, `jdbc:oracle:thin://@connectionstring` `jdbc:oracle:thin://@((description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.us-*****-1.oraclecloud.com))(connect_data=(service_name=**************_tylerlampatteradw_high.adb.oraclecloud.com)(security=(ssl_server_dn_match=yes))`
Username *	Enter your user name for the database authentication.
Password *	Enter your password for the database authentication.
Configure properties	Define additional configurations for the database connection. For example, you can configure the connection timeout if the server you are trying to connect to is slow. This setting will be supported in a release subsequent to the 2023.8.1 release.
Borrow concurrency from	Select another connection from the list. By default, all data flowing through a connection record is submitted to the respective endpoint application at the Concurrency level configured for that connection record. There are cases, however, where multiple integrator.io connections need to share the same concurrency level, and this field allows you to specify which connection you would like to borrow from. With borrowed concurrency, the data flowing through both connections will be submitted to the endpoint application together, via a shared concurrency model.
Concurrency level	Set this field to limit the number of concurrent HTTP requests (up to 25) allowed by the connection resource at any one time, or leave this field blank to use burst mode. With burst mode, integrator.io will make HTTP requests as fast as possible, with high levels of concurrency.
Configure encrypted fields	Store all sensitive fields required by your imports and exports to access the app you are connecting to. Click the Expand window ( ) button to modify the JSON sent to the app in the Encrypted Advanced Field Editor. For example, enter `{"secretKey": "someSecretKeyValue"}`. (You can also retrieve these sensitive values elsewhere, such as How to test this connection?, via the example handlebars format `{{{connection.http.encrypted.secretKey}}}`.) Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s encrypted fields safe. When editing this form later, you must enter this value again; it is stored only when the connection is saved and never displayed as text. This setting will be supported in a release subsequent to the 2023.8.1 release.

After configuring the settings, click Test Connection. When the connection is verified, you will receive the following message:

The connection is added to your account.

You can see it listed under Resources > Connections.
If a connection is part of an integration, you can see it listed under Home > Integration name > Connections, and you may proceed to register the connection.

Set up a connection

Related articles