Forum Discussion
Connecting to PostgresSQL hosted on AWS RDS?
Anonymous the PostgresSQL connector doesn't work out of the box, you need to do quite a few things first
1. Install Npgsql which allows .NET access to PostgresSQL. I installed it using the Pakagae Manager Console in Visual Studio; detailed instructions are here: https://www.nuget.org/packages/Npgsql/
You need to connect over SSL to AWS which isn't setup by default (on my Windows 10 machine anway)
2. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7/P7B)
4. Import that certificate to the Trusted Room Certificate described here http://www.cs.virginia.edu/~gsw2c/GridToolsDir/Documentation/ImportTrustedCertificates.htm
5. Test access from Power BI desktop using the PostgresSQL connector and it should work
In conclusion it's possible to connect to PostgresSQL on AWS RDS databases but it isn't easy
Hi aqavi10 , I've got the same problem than Anonymous, can you help me? please
Hi Anonymous ,
Please check your inbox. I'll try doing whatever I can.
Cheers!
Hi everybody, I solve my issue following these steps:
1.- Install Npgsql using Visual Studio.
First, create a new project by default options.
Second, in References select Manage NuGet packages...
Third, Browse Npgsql and install it.
2. Download the AWS public key from here https://s3.amazonaws.com/rds-downloads/rds-combined-ca-bundle.pem
3. Convert that to a certificate using https://www.sslshopper.com/ssl-converter.html (convert to PKCS#7)
4. Install certificate using right-click in the mouse.
5. Move certificate from Current user to Local computer using MMC command.
Sorry, I can't add pictures to steps 4 and 5.
So, in step 4 right-click and select install certificate
Select where you want to put all certificates, I select Trusted Root Certification Authorities
5. Move the certificate from Current user - Trusted Root Certification Authorities to Local Computer - Trusted Root Certification Authorities using MMC command.
Hello everyone,
thanks Anonymous this is great help. It is working on my local computer with my local gateway - just perfect. However after installing everything to my remote server (also windows 10 frontend) with the same steps involved. I will always get an error code when I want to enter my credentials for this dataset. It is not working.
I am using the latest Gateway version
Do you have a clou why?
