Accessing postgres DB for Excel reports

RT Users
1

Hi all,

I have a manager, one of those pointy haired things, that wants to be
able to do an ODBC query of the postgres db we have running as the
back-end to an RT implementation. He wants to be able to use Excel so
he can deliver pretty graphs and stuff to the weekly PHB convention
showing how wonderful his team is functioning, and how he deserves more
of the budget than anyone else.

Does anyone have any experiences/pointers/documentation/etc… that
might point me in the right direction?

By the way, this is a serious question despite the cynicism.

Thanks,
BenR

2

Does anyone have any experiences/pointers/documentation/etc… that
might point me in the right direction?

What exactly is your issue? Getting ODBC talking to postgres? What
queries to run? Please elaborate on exactly what your problem is.

You might be best off by defining some views in postgres for your PHB
to query, so he doesn’t have to do any complex query configuration.

Vivek Khera, Ph.D.
+1-301-869-4449 x806

smime.p7s (2.42 KB)