JDBC Driver not loaded - Amazon Redshift Database

[Gideon van Zyl1]

Hi,

I have a Redbase database in which a customer is keeping data that we want to import on a regular basis for their Change process.

The JDBC Driver is not supported by default, so I uploaded the Redshift JAR file for the MID server, and created a datasource with the specific Database type added (with the correct Driver Class correctly defined). 

I am however getting an error when I test the database and try to import the data from the Database:

MID Server reported error: java.sql.SQLException: com.snc.automation_common.integration.exceptions.InvalidConnectionParameterException: Unable to load JDBC driver: 

I have searched through the Community and docs server, and from all I can see my configuration is correct. 

Has anybody created a JDBC connection for Redshift, and if so, are there any gotchas you encountered? If so, How have you resolved them?

-Gideon-

[DrewW]

Did you manage to get something to work?  I'm working on this now an getting data if you still need help.

[michaelslabodni]

Hey Drew!

Can you post information how you got this to work? I've been working on a JDBC Redshift connection too and keep getting errors related to the SSO. The driver I loaded to the MID server seems to be working, so I'm not sure on why it's trying to use SSO vs using database authentication.

Cheers,

Michael

[DrewW]

I used database auth to get it to work I did not use SSO.  I then had to have a MID Server setup with 24gb of ram with 16gb allocated to the MID Server instance and at least 100gb of free disk space so I could pull down 16,000,000 rows of data.

[michaelslabodni]

Did you use the JDBC driver located at Configuring a JDBC driver version 1.0 connection - Amazon Redshift? And did you load all the dependent libraries with the driver, or just the driver itself?