DataDirect Connect - Products Enhancements - Progress Community

 DataDirect Connect

  • Inefficient query generated when making use of Take() or Top() - implement FETCH...

    When using “Take(100)” for example then the dataprovider maps this to a SQL statement that uses row_numbers. These row numbers are then used to select the rows where row_num smaller than the 100 (in this case). This is not efficient and is...
  • Bulk Data download from SFDC Adapter

    • Coming Soon
    • 1 Comments
    Hi Team, Currently the Bulk mode option provides ability to mass upload data into SFDC, whereas there is no bulk download from SFDC. We have few requirement where we load the history tables from SFDC into HANA and these tables have 15-25 millioin records...
  • Add support for LOB Data Prefetching in Oracle

    • Coming Soon
    • 1 Comments
    Prefetching LOB data with no extra round trip would greatly improve performance for query results containing LOB data. Oracle provides the possiblity to prefetch LOB Data by setting the connection parameter defaultLobPrefetchSize. For more information...
  • Add SKIP operator to Connect for ADO.Net Sybase Entity Framework provider

    • Coming Soon
    • 1 Comments
    Actually the SKIP operator is not supported by the ADO.Net Sybase Entity Framework provider. It's a critical feature to enable paging results.
  • Add .NET System.Transactions support for DataDirect Connect JDBC driver

    Right now the Java Transaction API (JTA) is supported in the DataDirect Connect JDBC driver. However, at the moment it's not possible to use the .NET Systems.Transaction (distributed transaction management) in combination with an OpenEdge database...
  • Support JNDI validationQuery for branded drivers

    • Under Review
    • 0 Comments
    Currently, validationQuery is not supported in JNDI resource for branded drivers. However, JNDI pool is controlled by app server. Without validateQuery, it is possible JNDI connection pool would return timeout connection. Is it possible that branded driver...
  • Support implicit result sets returned by Oracle 12 stored procedures

    • Under Review
    • 0 Comments
    Now that Oracle 12 supports implicit result sets being returned from stored procedures, the JDBC (and ODBC driver) should support the implicit result set return. It seems like an obvious improvement to any driver that is reported to support Oracle 12...
  • Teradata Wire Protocol Driver

    • Under Review
    • 0 Comments
    Currently there is no Teradata Wire Protocol Driver. The ODBC Driver which is currently offered is dependent on several Teradata libraries which need to be installed. In the Teradata Tools and Utilities (TTU) newer installers the support libraries and...
  • ODBC Oracle Wire Protocol driver does not support LDAP

    • Under Review
    • 2 Comments
    Please add support for this. Our users are using your drivers to perform specific tasks such as streaming data to Teradata. They can't use another driver and if LDAP is not supported then they are unable to use your drivers in our product. Thank you...
  • Not able to execute a callable statement which has CURSOR as out parameter with JDBC...

    By Using the Data Direct DB2 JDBC driver, we are not able to execute a callable statement which has CURSOR as out parameter. Problem is that this is big limitation and we are not able to use the driver where customers are using cursors in their store...