Re: Microsoft Report Builder

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