Home Services Partners Company

Release–January 11, 2014

Progress DataDirect Cloud enables simple, fast connections to cloud data regardless of source—SaaS apps, big data stores, or social networks—using a single standards-based ODBC or JDBC driver. For example, an organization might want to use a reporting application to predict travel budgets by analyzing travel data stored in the cloud. DataDirect Cloud can provide connectivity with simple configuration instead of extensive coding. In addition, when you install the DataDirect Cloud On-Premise Connector on a machine behind your firewall, you can connect to on-premise data sources using DataDirect Cloud, without opening ports or otherwise configuring the fire wall. The On-Premise Connector establishes a secure connection back to DataDirect Cloud when needed to provide access to the on-premise data stores.

DataDirect Cloud – January 11, 2014

DataDirect Cloud provides these new features:

  • DataDirect Cloud On-Premise Connector. You can now connect to Progress OpenEdge 10.2B, 11.2, and 11.3 on-premise data sources using DataDirect Cloud, without opening ports or otherwise configuring the fire wall. The On-Premise Connector establishes a secure connection back to DataDirect Cloud when needed to provide access to the on-premise data sources.

DataDirect Cloud provides the following fix in:

  • On-Premise Connector. In some cases, the On-Premise Connector Configuration Tool was not able to locate a Java installation when launched.

The following data stores are available in beta form:

  • Oracle Eloqua
  • Marketo

For information about other data stores currently in Beta, go to http://www.datadirectcloud.com/solutions.

Known Issues

A few issues are bound to get by even the most exhaustive testing. We are working to fix the following:

  • OpenEdge 10.2b - Setting the MaxPooledStatements data source option in an OpenEdge data store to a value other than zero can cause statement not prepared errors to be returned in some situations.
  • When specifying the DataDirect Cloud User Id (Progress ID) and password during the install or in the On-Premise Connector Configuration tool, enter the user id in lower case. DataDirect Cloud user ids are case-insensitive; however, one of the DataDirect Cloud On-Premise components is treating the user id as case sensitive. Entering the user id as lower case works around this issue. DataDirect Cloud passwords are case sensitive and must be entered in the correct case.
  • The Beta On-Premise Connector will not work with this DataDirect Cloud update. The Beta On-Premise Connector must be uninstalled and the GA On-Premise Connector must be installed.

    NOTE : Reinstalling the On-Premise Connector changes the Connector ID. Any OpenEdge On-Premise data sources defined in DataDirect Cloud must be updated with the new Connector ID.
  • Access to the On-Premise Connector is now restricted such that only the DataDirect Cloud user that registered the On-Premise Connecter can establish a connection through that On-Premise Connector. For example, if the DataDirect Cloud username johndoe is specified during the installation of the On-Premise Connector, then the user must be logged into DataDirect Cloud as johndoe in order to be able to establish connections through the connector. The user johndoe can have multiple connections open going through the same On-Premise Connector.
  • Eloqua Data Store
    • The Eloqua data store is currently not mapping “large” fields as LONGWVARCHAR. All string fields are currently mapped as WVARCHAR.
    • Queries that SELECT fields longer than 16382 characters report the following error when the query result is large and needs to be processed on disk (typically when query contains ORDER BY, GROUP BY):

EloquaDisk cache error. Field length: 84448 exceeds maximum limit of 65535.10232

    • The Eloqua data store defines the length of the predefined text fields (not user-defined fields) as 100 and long text fields as 8000. If the actual data exceeds these lengths for multi-select and long text fields, data returned will be truncated.
    • For queries on ACCOUNT and CONTACT tables that are processed as bulk queries , the Eloqua data store may report the following error.

Query Execution Failed. Error invoking Service, Response Error Code: 404, NOT_FOUND
This error can occur when the query takes longer than 3600 seconds (1 hour). Set the bulktimeout custom property in the data source to a larger value and run the query.

  • Marketo Driver
    • Queries on Marketo Views for ACTIVITYRECORD child tables can report the following error:

ServiceResults from your query have timed out. Please execute the query again
This error can occur when a query takes longer than two hours to process. Modify the query to select activity information for specific Leads.

  • See the files d2cjdbcreadme.txt and d2codbcreadme.txt for the latest notes and known issues when accessing DataDirect cloud through the DataDirect Cloud ODBC and JDBC drivers. These files are located in the installation directory for the ODBC and JDBC drivers.

Read Next

What's new