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 made Production ready ?
  • Will it then be available in the gateway ?

Many thanks

Dave WOOD

 

 

8 Replies

  • 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