Oracle
Connect & Ingest data from / to an Oracle database
The following credentials keys are accepted:
host
(required) -> The hostname / ip of the instanceuser
(required) -> The username to access the instancepassword
(required) -> The password to access the instanceschema
(optional) -> This is the default schemasid
(optional) -> The Oracle System ID / Service Name of the instancetns
(optional) -> The Oracle TNS string of the instanceport
(optional) -> The port of the instance. Default is1521
.ssh_tunnel
(optional) -> The URL of the SSH server you would like to use as a tunnel (examplessh://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>
export ORACLE='oracle://myuser:[email protected]:1521/<sid>'
Last modified 1mo ago