Oracle
Connect & Ingest data from / to an Oracle database
Setup
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 of the instanceservice_name
(optional) -> The Oracle Service Name of the instancetns
(optional) -> The Oracle TNS string of the instance (example:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=my-oracle-database.provider.com)(PORT=1521))(CONNECT_DATA=(SID=my_service)))
).port
(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:password@db.host:22
)ssh_private_key
(optional) -> The private key to use to access a SSH server (raw string or path to file).ssh_passphrase
(optional) -> The passphrase to use to access a SSH server.jdbc_str
(optional) -> The JDBC connection string to use. No need to provideuser
,password
orhost
sqlldr_path
(v1.3.0)-> The path to thesqlldr
binary. This is useful if you need to specify a custom path forsqlldr
.
Additional Parameters
auth_type
(optional) -> The auth type to use. Options include:OS
,TCPS
auth_server
(optional) -> The Windows auth server to use. Options include:NTS
os_user
(optional) -> The Windows operating system user (withauth_type=OS
)os_password
(optional) -> The Windows operating system password (withauth_type=OS
)domain
(optional) -> Windows system domain name (withauth_type=OS
)proxy_client_name
(optional) -> to use proxy authentication
Using sling conns
sling conns
Here are examples of setting a connection named ORACLE
. We must provide the type=oracle
property:
Environment Variable
Sling Env File YAML
Oracle Client Dependency
Last updated