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
