Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago

ODBC connection in PostgreSQL

Hello,

 

One Power BI report was based on Sybase but some tables need to use more database which based on PostgreSQL. Do I need to create a new queries or where build a connection. Do I need use 

to ODBC:

 

Source= Odbc.Query("driver={PostgreSQL Unicode(x64)};server=server_name;port=5432;database=db_name", "select … ")

So how to resolve it?

Need Help

4 Replies

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Hello,

       

      I would like to convert Sybase SQL query to PostgreSQL query. I have working Sybase query but I don't get how apply it to PostgreSQL database. I tried to modify the Sybase query in order to get PostgreSQL query, but getting many syntax errors which I can't fix.

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Here is the sql with wrong syntax, so how to fix it? I am tring to convert sybase sql to postgresql. Below is picture with errors:

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Analitika ,

        Please update PostgreSQL query as below and check whether it can run successfully without error:

        SELECT ZUO_KOD,
       DID_NR,
       ADM_VAR,
       DID_DAT,
       Eil.skaicius
FROM
  (SELECT rows.ZUO_KOD AS ZUO_KOD,
          rows.DID_NR AS DID_NR,
          rows.ADM_VAR AS ADM_VAR,
          rows.DID_DAT,
          count(1) AS Eil.skaicius
   FROM
     (SELECT ot.ZUO_KOD,
             ot.DID_NR,
             ot.ADM_VAR,
             ot.DID_DAT
      FROM
        (SELECT ID_VIDP AS ID_VIDP2,
                ZUO_KOD AS ZUO_KOD,
                DID_NR AS DID_NR,
                ADM_VAR AS ADM_VAR,
                DID_DAT AS DID_DAT
         FROM [DBA].VIDP
         WHERE DID_DAT >= '" &sFilterDate&"') ot
      LEFT OUTER JOIN DBA.VIDP1 ine ON (ot.ID_VIDP2 = ine.ID_VIDP)) ROWS
   GROUP BY ZUO_KOD,
            DID_NR,
            ADM_VAR,
            DID_DAT)

        You can  refer the content in the following link to write PostgreSQL query and use pgFormatter to format your PostgreSQL query.

        PostgreSQL Tutorial

        Best Regards