Forum Discussion

michaelanckaert's avatar
michaelanckaert
Regular Visitor
1 year ago

Connecting Data Pipeline to Postgresql: Server Certificates

For a large client I am investigating how feasible a migration from Databricks to MS Fabric is at this time. One issue I'm running into is connecting a Data Pipeline to a Postgresql server on AWS RDS...
Need Help
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
1 year ago

Hi. You can try the following post:

https://blog.ladataweb.com.ar/post/187904496250/conectar-power-bi-a-rds-postgres-en-aws

I'm not completely sure it works because it was tested just for PowerBi. However, it looks that it contains all you need for the certificate and Fabric Gateway should be almost the same. I don't think you can avoid the gateway. AWS RDS it's not like regular postgres. You can set up an EC2 for the gateway.

I hope that helps,