Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dataflows - Redshift Connector - "An exception occurred: 'ProviderName' is not a valid Amazon"...

Hi everyone! Since yesterday we are having troubles to build up Dataflows from scratch. If we want to create a new Dataflow connecting to Redshift, we have to re-use Dataflows because we get this...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Connector has been updated and now is working fine. Thanks all!

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous

What happens if you try and use an ODBC connection instead of the Amazon Redshift option and see if that works?

 

You can use the blog post here to show how to configure the ODBC connection: Using Azure Analysis Services to connect via an ODBC Source (Redshift) - Reporting/Analytics Made ea...

 
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-yalanwu-msft , thank you for your response.

    First of all, the connector is still failing when trying to build new DataFlows, but its working fine with already created ones. 

    We have not access to the GateWay machine, so we cannot install the redshift driver -> we cannot use the ODBC connector with Redshift.

    Anyway, from my point of view, using ODBC connector while having an official connector that we use everyday(Redshift) that is kind of broken is not a valid solution. 

    I really don´t know yet if anything changed in the official Redshift connector, but seems so. Any clue?

    Regards.