Forum Discussion

davewood's avatar
davewood
New Member
8 years ago

Vertica connector status ?

Hello,   I’m currently working on a project where we want direct query access to an on-premises Vertica database and would like to know a couple of things   When will the Vertica connector be ma...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

davewood,

Firstly, there is no timeline about that when the Vertica connector will be made production,

Secondly, it doesn't support Vertica data source in gateway currently. As stated in this article, data sources that are have (Beta) after their name are subject to change, they might not be supported after publishing a report to the Power BI service, which means that that opening a published report or exploring the dataset can result in an error.

In your scenario, you can consider to create ODBC connection for Vertica, then connect to the ODBC data source in Power BI Desktop, create report there and refresh the report in Power BI Service. There is a blog for your reference.

Regards,
Lydia

davewood's avatar
davewood
New Member
8 years ago

Thanks for your reply Lydia, unfortunately the ODBC connection doesn't support direct query so I really need the connector.

Regards

Dave

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    davewood,

    If you need to use DirectQuery mode, I am afraid that you would need to wait for the production release.

    Regards,
    Lydia

    • davewood's avatar
      davewood
      New Member
      8 years ago

      I guess I have no choice then. I hope it's coming soon as the Vertica connector has been a Beta for over 8 months now (October 2017)

       

      Regards

      Dave

      • davewood's avatar
        davewood
        New Member
        8 years ago

        How about putting the Beta Vertica connector in the gateway ?

         

        That way at least I'll be able to see if my proposal can work. 

         

        Thanks

        Dave