Amazon Redshift
In order to use this connector, you must install the proper database driver. For instructions, refer to How to Install Database Drivers.
Configuring Amazon Redshift as a Connection
In order to import and export from Amazon Redshift, 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 Amazon Redshift as the connection type. Select either JDBC or PostgreSQL depending on your driver. 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 Amazon Redshift Connector
For step-by-step directions for database connectors, refer to Importing Data from a Database.