Oracle

Connect & Ingest data from / to an Oracle database

Sling CLI Setup
The following credentials keys are accepted:
host (required) -> The hostname / ip of the instance
user (required) -> The username to access the instance
password (required) -> The password to access the instance
schema (optional) -> This is the default schema
sid (optional) -> The Oracle System ID / Service Name of the instance
tns (optional) -> The Oracle TNS string of the instance
port (optional) -> The port of the instance. Default is 1521.
ssh_tunnel (optional) -> The URL of the SSH server you would like to use as a tunnel (example ssh://user:[email protected]:22)
ssh_private_key (optional) -> The private key to use to access a SSH server.
Here is an example of setting a connection named ORACLE. We must provide the type=oracle property:
$ sling conns set ORACLE type=oracle host=<host> port=<port> sid=<sid> user=<user> password=<password> schema=<schema>
​
# OR use url
$ sling conns set ORACLE url=oracle://myuser:[email protected]:1521/<sid>
Environment Variable
export ORACLE='oracle://myuser:[email protected]:1521/<sid>'
If you are facing issues connecting, please reach out to us at [email protected].

MySQL

Postgres

Last modified 1mo ago