Introduce the "CatalogOptions" parameter in the Greenplum ODBC driver - DataDirect Connect - Products Enhancements - Progress Community

 DataDirect Connect

Introduce the "CatalogOptions" parameter in the Greenplum ODBC driver

We have a customer who is looking for the "CatalogOptions" parameter in the ODBC Greenplum driver.

The "CatalogOptions" is implemented in the JDBC Greenplum driver and can improve performance.

See http://media.datadirect.com/download/docs/jdbc/alljdbc/help.html#page/jdbcconnect%2FCatalogOptions_9.html for details on the option as implemented in the JDBC driver.

Comments
  • Customer Issue: When Crystal Reports runs a report it calls the ODBC driver function "SQLGetTypeInfo" for each query. For Pivotal Greenplum this is translated into catalog queries. This can cause a bottleneck on the Master Server when to many reports are called from the users.

    Please add an option to the ODBC connection string to set off these checks against the DB-Catalog. This is implemented for JDBC driver:

    media.datadirect.com/.../help.html