Forum Discussion

meyerovb's avatar
meyerovb
New Member
5 years ago

Amazon Redshift connectivity issue for data flows

I try to create a data flow, add table, choose amazon redshift as data source, enter server name and database exactly as it was in the on-premise gateway, the gateway instantly populates into the dro...
Dataflow
meyerovb's avatar
meyerovb
New Member
5 years ago

I'm using the website, not desktop

 

Tried odbc connection string, selected the on-premise gateway in the drop down, tried anonymous or same sql user login as on-prem gateway

 

Driver=Amazon Redshift (x64); Server=...; Database=...; Port=5439

Immediately Returns Unexpected Error

 

Tried x86 instead of x64, got this after like 30 seconds:

An exception occurred: The 'Driver' property with value 'Amazon Redshift (x86)' doesn't correspond to an installed ODBC driver.

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi meyerovb ,

 

Did you install both 32bit and 64bit odbc driver for  Redshift on the server that hold the gateway? It could be a permission issue in Amazon Redshift based on your error message in your original post. You may need to check forums that specialize in RedShift.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai