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 12, 2015
- The OData API now provides beta functionality for write operations. The beta functionality provides new APIs to create, update, and delete entities using OData.
- A new option OData Read Only on the OData tab of the data source configuration dialog controls whether write operations are enabled for that data source.
- By default, write operations are enabled for new data sources.
- Existing OData-enabled data sources are read only (write operations are disabled). To enable write operations for an existing OData enabled data source, clear the OData Read Only option on the OData tab. Then, on the Data Sources tab, regenerate the OData model for the data source by clicking on the OData model icon (). The icon is located to the right of the description of the data source. Write operations will work only if the model is regenerated.
Oracle Service Cloud
- Added the ability to specify whether the Name attribute of NamedID fields is exposed in the relational model, using the new NamedID Behavior mapping option on the Mapping tab.
- When set to 1, the Id and Name attributes of the NamedID fields are exposed in the relational model. This means that they will be included in the results for the queries. However, including these columns in certain queries can cause Oracle Service Cloud to return a “poor performing query” error if the table has a large number of rows.
- When set to 2, only the Id attribute of the NamedID fields is exposed in the relational model. This setting may improve performance of queries that use NamedID fields.
- Support for write operations to Oracle Service Cloud, using the Read Only option on the Advanced tab.
- If the Read Only check box is selected (set to true), write operations are not allowed.
- If the check box is not selected (set to false), write operations are permitted if the Oracle Service Cloud Database option is set to operational. Write operations are not supported if the Oracle Service Cloud Database is set to report.
- Added the ability to configure whether external events and business rules are run on the server side when performing a Create, Destroy, Get, or Update operation. Use the new Processing Options field to specify which are run.
- If set to 0, external events and business rules run after a Create, Destroy, Get, or Update operation completes.
- If set to 1, external events do not run after a Create, Destroy, Get, or Update operation completes.
- If set to 2, business rules do not run after a Create, Destroy, Get, or Update operation completes.
- The set of SSL/TLS cipher suites that are enabled by default has changed. Older cipher suites that were used with SSLv3 have been disabled by default.
DataDirect Cloud ODBC Driver
- The DataDirect Cloud ODBC Driver has been updated to use version 1.0.2d of the Open SSL library.
- Resolved an issue where a Google Analytics user would see multiple views with the same name. This occurs when a user account has access to multiple web properties, and within each a view of the same name exists. Now, the Google Analytics dialog prepends the web property name to the view name in order to differentiate the two view names.
Oracle Service Cloud
- Fixed a problem where fields were no longer present. (PSC00337716) Use the NamedID Behavior mapping option on the Mapping tab to specify whether the Id and Name attributes of NamedID fields are exposed in the relational model.
Even with exhaustive testing, not all issues can be immediately resolved. The following issues have been noted:
All Data Sources
- 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.
- 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.
In addition, you must update Connector Id wherever it was used, such as the definitions of Group Connectors and Authorized Users.
- 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.
- Once a Google Analytics OAuth profile is created for a specific Google account, changing the Google Account associated with the profile results in "the configuration options used to open the database do not match the options used to create the database" error being returned for any existing data sources.
- In this release, creating a Google Analytics OAuth profile with the Data Source Management API is not supported.
- $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
OrderItems, the query must be rooted at Orders. For example:
- When manually editing the ODataSchemaMap value, the table names and column names specified in the value 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.
Note: It is highly recommended that you use the OData Schema Editor to generate the value for the ODataSchemaMap data source option. The Schema Editor takes care of table and column name casing and other syntactic details.
- 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
- When you create a custom object, your Oracle Service Cloud administrator must enable all four columns of the Object Fields tab of the Object Designer, or you cannot query against the custom objects.
- 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
- Testing has shown the following two errors from Microsoft Dynamics CRM Online when executing queries against the ImportData and TeamTemplate tables:
Note: We have filed a case with Microsoft and are waiting to hear back about the cause of the issue.
- 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
- 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.
- 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.
- Data source connections by default now use Export Mode to communicate with the Sugar CRM server, providing increased performance when querying large sets of data.
Bulk export mode causes NULL values for currency columns to be returned as the value 0. Because of this, there is no way to differentiate between a NULL value and 0, when operating in export mode. This can be a problem when using currency columns in the SQL statements, because DataDirect Cloud must satisfy some filter conditions on queries, such as with operations like =, <>, >, >=, <, <=, IS NULL and IS NOT NULL. For example, suppose a currency column in a table in SugarCRM has 3 null values and 5 values that are 0. When a query is executed to return all NULL values (SELECT * FROM <table> WHERE <>currency column> IS NULL), then 3 rows are returned. However, if a query is executed to return all rows where the column performs an arithmetic operation (SELECT * FROM <table> WHERE <currency column> + 1 = 1), then all 8 records are returned because the 3 NULL values are seen as 0.
DataDirect Cloud JDBC Drivers
- The JDBC 32-bit silent installation fails on Windows 10. Use the standard installer, instead.
- See the file d2cjdbcreadme.txt for the latest notes when accessing DataDirect Cloud through the DataDirect Cloud JDBC drivers. These files are located in the installation directory for the JDBC drivers.
DataDirect Cloud ODBC Drivers
- See the file d2codbcreadme.txt for the latest notes when accessing DataDirect Cloud through the DataDirect Cloud ODBC drivers. These files are located in the installation directory for the ODBC drivers.
Third Party Acknowledgments
Third party acknowledgments are listed on the following Web page.