Man, when things begin to suck, they really begin to suck. We have SAP/Business Objects here. Our back-ends are all either PostgreSQL or PostgreSQL Advanced Server (from EnterpriseDB). The problem is that we have both Business Objects and Data Services (formerly Data Integrator) and only Business Objects supports PostgreSQL (nominally anyway) and Data Services does not. Except that Data Services supports ODBC connectivity to databases when fully compliant ODBC Level II drivers are used. They recommended Progress software's DataDirect PostgreSQL ODBC driver. In order to use that on our BO/DS hosts, there's a 5K/core license fee. At minimum we'd need 60K in ODBC driver licenses. The biz won't go for that. So, I'm supposed to look for a solution. I did recommend we use what every single BO Rep/Partner/even a BO VP recommended - that we use MS Sql Server for the SAP/BO stuff. That, too, is a no go here. (Aside: I don't want any grief about recommending the Beast's db server. BO loves MS Sql Server and no other back-end works well with it. It's support for IBM DB2 UDB also blows huge chunks. I'm all about using what works. If I'd had any say in this, we'd use Pentaho which works perfectly well with PostgreSQL back-ends).
So, I am in search of an ODBC driver for PostgreSQL that has full ODBC Level II compliance. The open source drivers I've tried are Level I only and we've talked to the guys at EnterpriseDB and there is virtually no interest in getting their Level I driver to Level II. Aside from the Progress offering, does anyone know of another Level II ODBC driver for PostgreSQL.
Any help appreciated.