Thread: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?
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.9861
130 Turner St, Ste 530, Waltham, MA 02453Hello
Can we pass SSRS report parameters to PostgreSQL query ?
With ? as a parameter , how can we differentiate between parameters?
With many reports and different logic for queries , stored procedures / functions is not a efficient solution for us .
So any trick/ way to pass SSRS report parameters to PostgreSQL query ?
Regards
Avadhut
Sent from Mail for Windows 10
From: Avadhut Narayan Joshi
Sent: 28 June 2021 10:06
To: Jayson Hreczuck
Subject: RE: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?
Hello Jayson ..
Thank you so much for your response . Is it possible for you to connect and help me set up this ?
Regards
Avadhut
Sent from Mail for Windows 10
From: Jayson Hreczuck
Sent: 25 June 2021 19:02
To: Avadhut Narayan Joshi
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?
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.9861
130 Turner St, Ste 530, Waltham, MA 02453