RE: Can we connect SSAS,SSIS,SSRS to PostgresSQL DB ?

Hello

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<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Avadhut Narayan Joshi<mailto:AJoshi7(at)sensiaglobal(dot)com>
Sent: 28 June 2021 10:06
To: Jayson Hreczuck<mailto:jayson(dot)hreczuck(at)studentuniverse(dot)com>
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<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Jayson Hreczuck<mailto:jayson(dot)hreczuck(at)studentuniverse(dot)com>
Sent: 25 June 2021 19:02
To: Avadhut Narayan Joshi<mailto:AJoshi7(at)sensiaglobal(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)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(at)sensiaglobal(dot)com<mailto:AJoshi7(at)sensiaglobal(dot)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<https://urldefense.com/v3/__https:/go.microsoft.com/fwlink/?LinkId=550986__;!!JhrIYaSK6lFZ!8UWVDxeQmFMyTy2cfbuejyrLjoUTPGJcvm010CQg2dz5PKEfITXTTFz4idtbCq-2Se4$> for Windows 10

--

[http://images.studentuniverse.com/new/emails/needaplacetostay2/studentuniverse_badge.png]

Jayson Hreczuck | Principal Database Administrator

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