Azure Analysis Service use postgresql as Data Source

ZDUAN 1 Reputation point
2020-07-28T12:55:03.637+00:00

Hello, I want to use the Azure Analysis Service (AS) with an on-premise postgresql database. To do this, I tried two approches :

  1. Create a tabular model on Azure AS. Migrate my local postgresql to Azure db for postgrsql. Then connect the Azure AS with this one.
  2. Directly connect Azure AS to my on-premise postgrsql.

For the first approch, I'm stucked in the step of processing my database (get data from Azure postgres to Azure AS). The error indicates that I need an on-premise gateway to connect the data source. I tried to install a vm on Azure for hosting the gateway as suggested in this post. But I got many errors in the configuration of gateway on vm and it seemed that using gateway could be very limiting in performance which made me abandon this approach.

Thus I started the second approach. However, it seems that postgresql can not be used as datasource.

I want to have an explicite response to whether postgresql on-premise or on cloud could be used as a datasource for Azure AS? If so, can you give me more hints of how can I do that?

Thanks

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2020-07-29T20:24:53.843+00:00

    Hi @ZDUAN ,

    Welcome to Microsoft Q&A and thanks for your query.

    As per this doc, Azure Database for PostgreSQL is not a supported data source of AAS. But you can connect to on-prem PostgreSQL as data source for import or in-memory tabular models for 1400 or later. In order to do this please choose the ODBC data source option (start a new import connection , choose ODBC option, then pick the ODBC source name), and AAS will treat it similar to SQL Server.

    Please refer to Notes section in this doc to know about the limitations: Other data sources supported in Azure Analysis Services

    Hope this helps. Do let us know if you have further query. If you encounter any error, please do share the error message for further assistance.

    Note: On the gateway server, the user needs to create the ODBC DSNs in the ODBC 64-bit

    Configuring the SQL Server ODBC Driver - Add a Data Source

    ----------

    Thank you
    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.