On 2/11/22 22:22, Kim Foltz wrote:
I am trying to configure Microsoft Report Builder to run against a mainframe PostgreSQL database. The ODBC connection tests as good and manually entered SQL Select statements properly return data. The problem is the Query Designer in the software doesn't support the normal graphical display of available tables and fields with PostgreSQL. All I find in Microsoft's documentation is the statement some data sources don't support graphical tools in Report Builder.
More than likely there are better report generators than Microsoft's tool but our agency is very fond of Microsoft solutions. Anyone know of a way to get the graphical tools working in Report Builder? In the alternative, is there an alternative Windows report generator to try if Microsoft's software isn't repairable?
Well, there is a fish to achieve just that:
https://babelfishpg.org/
The problem is that you will have to build PostgreSQL from source with some specific hooks for Babelfish. On the other hand, this extension is supported by AWS:
https://aws.amazon.com/blogs/database/migrate-sql-server-to-amazon-aurora-postgresql-using-best-practices-and-lessons-learned-from-the-field/
That means that it will continue to be developed and that you will not waste all that effort.
Regards
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com