Forum Discussion

rldekkers's avatar
rldekkers
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Copy Data activity from Amazon Redshift via VNet Gateway fails with ODBC Driver Error

I have been trying without success to use an Amazon Redshift database as a source in a Copy Data activity, which needs to be done through a VNet gateway, because the database allows only whitelisted ...
Need Help
Pipeline
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    Solution:

    Deploy a self-hosted IR inside your VNet.

    Install the Amazon Redshift ODBC driver on that IR machine.

    Configure your Copy Data activity to use this IR.

    This will fix the driver error and let Copy Data connect via VNet.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

Solution:

Deploy a self-hosted IR inside your VNet.

Install the Amazon Redshift ODBC driver on that IR machine.

Configure your Copy Data activity to use this IR.

This will fix the driver error and let Copy Data connect via VNet.