Data from AWS Postgres database?

[Juan]

Hello, new guy here.

Sorry if this is a dumb question, but I am not an IT person.

I am trying out Telerik Report Server. I have a Postgresql database that is hosted in the AWS cloud.

Is it possible to establish a connection to such database to load data into my reports?

If yes, can someone please provide me instructions on how to establish the connection? I am testing in a Windows 11 pc.

Thank you.

[Dimitar]

Hello Juan,

Yes, you will be able to connect to a PostgreSQL database as long as the necessary data provider is installed on the machine where the Report Server is used and the data provider is correctly selected in the data connection settings - Data Connections Management - Telerik Report Server.

For a PostgreSQL database, you may install the Npgsql data provider following our documentation - How to Configure Postgres with Npgsql? - Telerik Reporting. If the data provider does not appear in the dropdown menu when you attempt to create a new connection, it may mean that it is not available to all users and in such case, you may follow the Error Data source name not found - Telerik Report Server KB article to resolve that issue.

Lastly, you may have some issues with configuring the connection string and for that, I recommend looking at PostgreSQL connection strings - ConnectionStrings.com which has many examples of what the format of the connection string should be.

I hope that the provided information will help, please do not hesitate to let me know if you have any further questions.

Regards,
Dimitar
Progress Telerik

[Juan]

I followed your instructions, but I just cant get it to work. This is so difficult, I have been using the different types of connection strings provided by Azure and also the website you suggested but none of them work. Same thing with AWS. You really need to improve your data connection options by allowing users to input the database parameters instead of trying to guess an appropriate configuration for a connection string.

[Dimitar]

I am sorry to hear that you have been experiencing issues with the setup.

Please note that we always recommend first testing the connection strings in the most common database management tool for the given database. A connect string that works there should also work on the Report Server as long as the correct data provider is selected. Speaking of which, we you able to install the Npgsql data provider and did you see it in the dropdown when adding a new connection?

Could you please also record and share with me a Fiddler Jam log where you attempt to set up one such connection? You may do so by following the instructions from the First Steps with the Chrome Extension - Fiddler Jam (telerik.com) article.

Once done, I recommend sharing it in the private ticket thread so that no information is revealed to the public.

I will be looking forward to your response.