After you have placed your request for data access to Intilery Support, you will receive a response with the required details for connection. You will then need to open an SSH tunnel on your device, before using your preferred SQL client to run your queries.
Opening the SSH tunnel
Once you have provided the public key to Intilery Support using the instructions above, you will be provided with the required server details and database connection credentials.
For Mac/Linux OS
You can use a single terminal command to open the SSH tunnel for Mac/Linux.
The /Path/To/Private/Key should be replaced by you with the path to the private key that you generated previously, corresponding to the public key that was sent to Intilery. All other placeholder values will be provided by Intilery Support.
ssh -i /Path/To/Private/Key <Username>@<Hostname>:<Port> -L5439:<DatabaseIP>:5439
If you see an error similar to the following:
Permissions xxx for '/Path/To/Private/Key' are too open. It is recommended that your private key files are NOT accessible by others. This private key will be ignored.
You will need to modify the permissions of your private key (/Path/To/Private/Key). To do this run the following terminal command:
chmod 600 /Path/To/Private/Key
For Windows OS
For Windows, we recommend using PuTTY. The following settings need to be set in the PuTTY window, all values shown wrapped in <> should be replaced by the relevant value provided to you by Intilery Support.
The <Hostname> and <Port> placeholders should be replaced with the values provided to you by Intilery Support.
Connection > SSH > AuthYou should browse to your private key that you generated previously, corresponding with the public key that was sent to Intilery.
Connection > SSH > Tunnels
You will need to add a new forwarded port by filling out the details as here, then clicking add. The placeholder <DatabaseIP> should be replaced by the value provided to you by Intilery Support.
Connecting To The Database
The following details will be provided to you by Intilery Support to enable your connection to the database (through the previously opened tunnel).
- JDBC URL
You will also need to provide a driver. The database we use is Amazon Redshift and you can download the latest driver file here.
Our recommended SQL client is SQL Workbench/J, but you can use these details with any SQL client if you have a preference.
Adding The Redshift Driver
First, you will need to configure the redshift driver that you previously downloaded in by clicking "Manage Drivers" in the bottom left corner.
From here, you can add a new driver by clicking the icon in the top left and using the following details:
- Name : Redshift
- Library : /Path/To/Downloaded/Driver.jar
- Classname : com.amazon.redshift.jdbc41.Driver
- Sample URL: jdbc:redshift://host:port/name_of_database
Click OK to save this driver.
Adding Your Connection Profile
To add a new connection profile, click the icon in the top left corner, give it a name, and use the following details.
- Driver : Redshift
- URL : <JDBC URL provided by Intilery Support>
- Username : <Username provided by Intilery Support>
- Password : <Password provided by Intilery Support>
- Autocommit : true / checked
Click OK to connect using this profile. If the connection is successful you will simply see the window open with a window ready for you to begin writing SQL to query the database. You will be prompted upon quitting the application to save the connection profile, click yes to remember the details for future.