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

[Avadhut Narayan Joshi <AJoshi7@xxxxxxxxxxxxxxxx>]

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 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@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx> 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