In order to use this connector, you must install the proper database driver. For instructions, refer to How to Install Database Drivers.
Configuring Oracle as a Connection
In order to import and export from Oracle, you must first create a connection.
- Click the + (plus) button and select Connection or right-click in the browser and select Create new > Connection.
- From drop-down list, select Oracle as the connection type. Click Next.
- Fill in the Connection String field with the connection to your Oracle database.
- Select whether credentials should be provided or asked for. Add the required user name and password.
Indicate whether the connection should be used for import, export, or both.
As of Datameer X v6.3
A separate authentication section has been added.- Click Next.
- If required, add a description and click Save.
Importing Data with an Oracle Connector
For step-by-step directions for database connectors, refer to Importing Data from a Database.