Oracle Database
Connect to your Oracle database.
Getting Started
Prerequisites to create an Oracle Database based workflow. You will need
A source Oracle Database connection.
(optional) A list of tables OR SQL queries.
(optional) A destination Oracle Database connection OR object storage connection.
For the source database connection, we recommend using a backup or clone with read-only permissions, instead of connecting directly to your production database.
Do not use your input database connection as an output connector. This action can result in the unintended overwriting of existing data.
Create a Connection
A oracle
connection is created using the following parameters:
Connection Creation Parameters
name
Display name of your choosing used to identify your connection within Gretel.
my-oracle-connection
username
Unique identifier associated with specific account authorized to access database. The connection will be to this user's schema.
john
password
Security credential to authenticate username.
...
host
Fully qualified domain name (FQDN) used to establish connection to database server.
myserver.example.com
port
Optional Port number; If left empty, the default value - 1521
- will be used.
1521
service_name
Name of database service to connect to.
my_service_name
(optional) instance_name
Optional Name of specific database instance for this connection.
instance_id
(optional) params
Optional JDBC URL parameters that can be used for advanced configuration.
key1=value1;key2=value2
Creating Connections
First, create a file on your local computer containing the connection credentials. This file should also include type
, name
, config
, and credentials
. The config
and credentials
fields should contain fields that are specific to the connection being created.
Below is an example Oracle Database connection:
Now that you've created the credentials file, use the CLI to create the connection
Permissions
Source Connection Permissions
The Oracle source action requires enough access to read from tables and access schema metadata. The following SQL script will create an Oracle user suitable for a Gretel Oracle source.
Destination Connection Permissions
The following SQL script will create an Oracle user suitable for a Gretel Oracle destination. It will write to its own schema.
Last updated
Was this helpful?