...
...
A fast exporting method by loading your data into your S3 server and then copying the data to your Redshift database.
| Note |
|---|
In order to use this connector, you must install the proper database driver. For instructions, refer to How to Install Database Drivers.first download the following JAR file: This JAR file must then be added to your custom-jar folder located in the path: <Your path to Datameer>/modules/dap-conductor/build/<Datameer Version>/etc/custom-jars |
Configuring Amazon Redshift as 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.
Info As of Datameer v6.3
A separate authentication section has been added.
- Click Next.
- If required, add a description and click Save.
...