Forum Discussion

dengyue's avatar
dengyue
New Member
7 years ago
Solved

Power BI with Greenplum

Hi experts, Our organization decided to use Greenplum as analysis database, but I can't find a connection for Greenplum. Does anyone has such experience or best practice to use Power BI with Greenplum? Thanks in advance. Regards, Yue
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi dengyue ,

    After I check the document of greenplum datasource, I found it is postgresql based on datasource. You can try to use postgresql connector to get data.

    About the Greenplum Architecture

    Greenplum Database is based on PostgreSQL open-source technology. It is essentially several PostgreSQL disk-oriented database instances acting together as one cohesive database management system (DBMS). It is based on PostgreSQL 8.3.23, and in most cases is very similar to PostgreSQL with regard to SQL support, features, configuration options, and end-user functionality. Database users interact with Greenplum Database as they would with a regular PostgreSQL DBMS.

    Connecting Power BI To PostgreSQL

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi dengyue ,

    After I check the document of greenplum datasource, I found it is postgresql based on datasource. You can try to use postgresql connector to get data.

    About the Greenplum Architecture

    Greenplum Database is based on PostgreSQL open-source technology. It is essentially several PostgreSQL disk-oriented database instances acting together as one cohesive database management system (DBMS). It is based on PostgreSQL 8.3.23, and in most cases is very similar to PostgreSQL with regard to SQL support, features, configuration options, and end-user functionality. Database users interact with Greenplum Database as they would with a regular PostgreSQL DBMS.

    Connecting Power BI To PostgreSQL

    Regards,

    Xiaoxin Sheng