Oracle
- Daniel Yanguas (Unlicensed)
Version: 1.0.0
Category: Database
Tier: 2
Type: Source, Target
Authentication:
Standard Authentication:
Host
Port
Schema
Username
Service name
Password
Supported Save Mode as Target:
Append
Overwrite
See: Target Connector Save Modes
Connection Properties:
Name | Mandatory | Description |
|---|---|---|
Connection Name | Yes | Name of the connection |
Description | No | Description of the connection |
Host Name | Yes | Host or “Endpoint“ |
Port | Yes | Port number |
Schema | No | Name of schema in the database |
Service name | Yes | Name of the database for the connection |
Username | Yes | Username of the database |
Password | Yes | Password of the database |
Steps to create connection:
There are two ways to create connection -
Choose the Oracle connector from Pipeline tab > Add Connection.
b. You can also add the connection via Connections tab>Add Connection.
Fill in the required details.
Input all the required connection properties that you got. The Host, Port, DBNAME, Username. The password is the one you set when creating your database. *Note that you will input the DBNAME in the “Service name” field. Contact your database admin for the required fields.Click on the Test connection button to confirm.
Click Create connection.