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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi rldekkers,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.

If yes, you are welcome to share your workaround so that other users can benefit as well.  And if you're still looking for guidance, feel free to give us an update, we’re here for you.

 

Best Regards,

Hammad.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi rldekkers,

Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.

 

Best Regards,

Hammad.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi rldekkers,
    We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.

     

    Best Regards,

    Hammad.