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