Important
The previous combined connector Oracle Autonomous Database / NSAW is now listed as two separate connectors, that is Oracle Autonomous Database and NetSuite Analytics Warehouse (NSAW), in the Celigo platform.
This article is common for both connectors; but, we plan to create separate articles soon.
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 Data Warehouse (OADW) and NetSuite Analytics Warehouse (NSAW).
Note: Celigo uses a JDBC connection to connect to Oracle Autonomous Database / NSAW; 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 the idea on the Celigo Connective.
Start establishing a connection to Oracle Autonomous Database / NSAW in either of the following ways:
-
From the Resources menu, select Connections. Then, click + Create connection at the top right.
– or –
-
While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination.
In the resulting page the opens, enter the following details
Application (required): Based on your requirement select Oracle Autonomous Database or NetSuite Analytics Warehouse (NSAW). For example, if you start typing "Oracle" in the box, you will see Oracle Autonomous Database in the list, and if you start typing "NetSuite" you will see NetSuite Analytics Warehouse (NSAW) in the list.
Name (required): 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.
Based on the database application you choose, the settings shown vary.
If you choose Oracle Autonomous Database, enter the following details:
Host (required only for Custom JDBC authentication type): Enter the connection string/URL to connect to the server that hosts the database.
-
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. -
You must include "@" before you enter your value. For example,
jdbc:oracle:thin://@connectionstringjdbc: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))
If you choose NetSuite Analytics Warehouse (NSAW), enter the following details:
Credentials .zip file (required only for Cloud Wallet authentication type): Upload the credentials.zip file (wallet file) for authentication. if you are a database administrator, you can follow the instructions and download client credentials. If you are not a database administrator, you can request your administrator to provide the file.
Service Name (required only for Cloud Wallet authentication type): Select the service name based on your workload. Each service provides a different level of performance and concurrency. For details, see the database service names.
Username (required): Enter your user name for database authentication.
Password (required): Enter your password for 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.
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.
Once you have configured the Oracle Autonomous Database / NSAW connection, click one of the following options:
-
Save – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account
-
Save & close – click to test and save the connection and exit the Create connection pane
-
Cancel – click to exit without saving any new changes
-
Test connection – click this button to verify that your new connection is free of errors
When you test or save the connection, you will receive a confirmation 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.