Redshift

🐕‍🦺 Setup guide

Prerequisites

1. Active Redshift cluster
2. Allow connections from Zenksar to your Redshift cluster

⚙️ Set up the QuickBooks data source in Zenskar

⚙️ Set up data source and type

1. Log into your Zenskar account.
2. In the left navigation bar, navigate to Metering > Data Sources. In the top-right corner, click + ADD DATA SOURCE.
3. In the Set Up Source section of the Add New Data Source page, enter a name for the MongoDB data source connection.
4. Select Redshift from the Source Type dropdown.

⚙️ Configure data source

In the Source Config section of the Add New Data Source page, do the following:

📖

JDBC URL

The JDBC URL has the following format:

jdbc:redshift://<endpoint>:<port>/<database>.

• Host: The host is the JDBC URL without the <port> and <database>.
• Port: The port number that you specified when you launched the cluster. If you have a firewall, make sure that this port is open for you to use. Default is set to 5439.
• Database: The database that you created for your cluster.
• Password: The password that you created for your cluster.
• Username: The user that you created for your cluster.
• JDBC URL Params: Please refer AWS Redshift documentation regarding building the JDBC connection URL and options for JDBC driver version 2.1 configuration.