Progress DataDirect Cloud™
Progress DataDirect Cloud enables simple, fast connections to cloud and on-premise data regardless of source—SaaS apps, big data stores, or social networks—using a single standards-based ODBC or JDBC driver, or OData enabled application. 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– September 20, 2014
- Oracle Service Cloud
- Now supported with Oracle RightNow CX API version 1.2 against sites whose version is August 2014. Versions earlier than February 2014 are not supported.
- The default value of the Web Service Call Limit connection parameter is now -1. The DataDirect Cloud connectivity service uses the default value that is configured in the service when connected to a site whose version is August 2014 or later. When connected to sites whose version is prior to August 2014, the connectivity service sets the default Web Service Call Limit to 100.
- The new Enable Paging with OrderBy ID connection parameter specifies whether the DataDirect Cloud connectivity service can inject the Order By clause in the Select query for each JDBC call. Enabling this connection parameter provides a stable paging mechanism for retrieving result sets that are larger than 10,000 rows. Note: If your application does not retrieve large result sets, consider disabling this feature, because adding the Order By clause can have a negative performance impact on queries.
- Google Analytics
- The localhost Redirect URI is now http://localhost/DataDirectCloud.This local server instance is required for the Token Tool. The redirect URL must be updated in the Google Developer's Console for your Google project. Refer to the DataDirect Cloud help topic "Defining OAuth Authentication for Google Analytics" for more information.
- The new showDeprecatedObjects mapping option allows you to show dimensions and metrics that Google Analytics has marked as deprecated. Enabling this workaround means that your queries can continue to work while you work on rewriting the queries and table definitions to migrate from the deprecated objects.
- The new defaultView mapping options was previously a connection option. It allows you to set a valid view name. At connection time, the DataDirect Cloud connectivity service looks up the name and adds a WHERE viewid= to each WHERE clause that supports viewId and does not have an explicit viewId in the user's query.
- You must set the map option createMap=forcenew for any data sources that have already been created.
- MySQL – Specifying NULL in a select list when accessing a MySQL data source via the ODBC driver returns the error "NULL SQL type not supported".
- OData – The documentation for the current release indicated that OData access is supported for Marketo and Apache Hive data stores. However, DataDirect Cloud does not support OData access for these data stores at this time.
Even with exhaustive testing, not all issues can be immediately resolved. We are working to fix the following:
- OData –
- $expand only supports one level deep.
For example, with the entity hierarchy:
| |- OrderItems
The following queries are supported:
However, this query is not supported:
OrderItems is a second level entity with respect to Customers. To query Orders and OrderItems, the query must be rooted at Orders. For example:
- The table names and column names specified in the ODataSchemaMap data source option are case-sensitive. The case of the table and column names must match the case of the tables and column names reported by the data source.
- When using the substring function on properties that map to a CHAR column in the data source, it is data source dependent as to whether the substring function treats the trailing spaces as significant. When going against Oracle, the trailing spaces are preserved. When going against other data sources, the trailing spaces are discarded.
- The $expand clause is not supported with OpenEdge data sources.
- The day scalar function is not working when specified in a $filter clause when querying a DB2 data source.
- Oracle Service Cloud – The initial connection when the relational map is created can take some time. It is even possible to receive an error "504: Gateway Timeout". When this happens, DataDirect Cloud continues to build the map in the background such that subsequent connection attempts are successful and have full access to the relational map.
- Microsoft Dynamics CRM – The initial on-premise connection when the relational map is created can take some time. It is even possible to receive an error "504: Gateway Timeout". When this happens, DataDirect Cloud continues to build the map in the background such that subsequent connection attempts are successful and have full access to the relational map.
- Reinstalling the On-Premise Connector changes the Connector ID. Any On-Premise data sources defined in DataDirect Cloud must be updated with the new Connector ID.
- On-Premise Connector
- Upgrading an existing installation causes new On-Premise Connecter services to be installed but does not remove the existing services. This causes problems with the On-Premise Connector operation. It is recommended that either the On-Premise Connector be installed to a new directory, or the existing On-Premise Connector be uninstalled and then the new version installed.
- Uninstalling and re-installing the On-Premise Connector causes the Connector Id of the On-Premise Connector to change. Any DataDirect Cloud data sources using the old Connector Id must be updated to use the new Connector Id. Installing to a new directory allows both the old and new On-Premise Connector to exist side-by-side. However, you must update the Connector Id option in previously-defined DataDirect Cloud data sources to point to the new On-Premise Connector.
- Changing the name used to register an On-Premise Connector using an older On-Premise Connector Configuration Tool may cause the connector to fail to register itself with D2C and cause 504 Gateway timeout errors to be returned. Installing the latest On-Premise Connector may resolve this issue.
- It is recommended that Login Timeout not be disabled (set to 0) for a Data Source.
- Using setByte to set parameter values fails when the data source does not support the TINYINT SQL type. Use setShort or setInt to set the parameter value instead of setByte.
- Testing has shown the following two errors from Microsoft Dynamics CRM Online when executing queries against the ImportData and TeamTemplate tables:
- Attribute errortype on Entity ImportData is of type picklist but has Child Attributes Count 0
- Attribute issystem on Entity TeamTemplate is of type bit but has Child Attributes Count 0
Note: We have filed a case with Microsoft and are waiting to hear back about the cause of the issue.
- 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.
- See the files d2cjdbcreadme.txt and d2codbcreadme.txt for the latest notes 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.
Third Party Acknowledgments
Third party acknowledgments are listed on the following Web page.