Postgres Pro
Downloads
Home   >   mailing lists

Re: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ? - Mailing list pgsql-admin

From Jayson Hreczuck
Subject Re: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?
Date
Msg-id CAHg7=h7voqHRq1tnN+Dp0TJPidNgWhaD2TtH6XZqUb_LxTye1g@mail.gmail.com
Whole thread Raw
In response to Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?  (Avadhut Narayan Joshi <AJoshi7@sensiaglobal.com>)
List pgsql-admin
Tree view
Yes.

No idea on the documentation.  What I did is install the microsoft postgresql drivers and then have the process access the db directly via ODBC referencing the registered DB on the server.

We currently have SSRS reports directly quering a postgresql db and it works rather well.  I do have plans for SSIS packages too.

On Fri, Jun 25, 2021 at 4:19 AM Avadhut Narayan Joshi <AJoshi7@sensiaglobal.com> wrote:

Hello Team

 

Can we connect to PostgreSQL database from SQL Server SSAS, SSRS and SSAS ? if yes what is the link for documentation ?

 

Regards

Avadhut

 

Sent from Mail for Windows 10

 



--


Jayson Hreczuck | Principal Database Administrator

C: +1 617.571.9861130 Turner St, Ste 530, Waltham, MA 02453

pgsql-admin by date:

Previous
From: Avadhut Narayan Joshi
Date:
Subject: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?
Next
From: Yambu
Date:
Subject: Pgbadger