I am trying to connect to my Redshift db using the Data Direct Redshift ODBC driver. I have installed the trial version of it as i wanted to see the performance first. The ODBC connection is successfully established.
When i use the driver to load data into my Redshift db only one row is processed till target and then the job hangs. I am using BODS as the ETL tool. i created a Amazon redshift driver to test if there was any issue with the data flow but it runs fine though the performance is really poor. Can someone suggest what must be going wrong?
Appreciate your comments.
Ankit, we typically see a hang with BODS when the trial period is within 5 days of expiration. The driver throws a warning message, but the service never displays it resulting in a hang. You should contact us to get a trial extension to complete the testing if that is the case.
Check out my world famous blog on data connectivity