Release Notes


Release Notes


May 10, 2024

Changes, improvements, and bug fixes

General

  • Excel Add-in now offers the option of viewing output in the current sheet or a new sheet.

Connectors

  • ADP (Fix): Fixed issue retrieving columns from Workers Work Assignments.

May 3, 2024

Changes, improvements, and bug fixes

General

  • Added support for the $count query string parameter to our OData service.

Connectors

  • Amazon Marketplace (Fix): Fixed SUM and FORMAT queries for OrderMetrics view.

  • Monday (Fix): Fixed issue with parsing date values with times.

April 26, 2024

Changes, improvements, and bug fixes

General

  • Published an updated AWS Glue connector.

  • Added the following Excel Add-in enhancements:

    • Improved scrolling
    • Sortable column headers
    • Improved ability to select and deselect fields
    • Ability to reference internal Excel sheets and columns to SQL statements

Connectors

  • Odoo (Update): Updated to return both id and name for an integer datatype column.

April 19, 2024

Changes, improvements, and bug fixes

General

  • Added the ability to duplicate custom reports.

  • Fixed an issue in Excel for the web Add-in to allow users with a Mac to use Connect Cloud.

Connectors

  • Netsuite (Update): Added support for custom segments.

  • LinkedIn (Update): Added the Organizations view for reading LinkedIn organizations’ data when you are not the admin for that organization, renamed the CompanyLocations view to OrganizationLocations, and renamed and added columns to the OrganizationLocations view.

April 12, 2024

What’s New

Caching

Say goodbye to slow data connections with CData Connect’s new caching feature. The user selects tables to be cached, or saved to a database. CData Connect then fetches data for the selected tables on a scheduled basis, ensuring swift and reliable access to data whenever you need it.

With caching, you no longer have to wait while the driver retrieves live data. When you enable caching on a table, CData Connect runs database queries against the cached data, not the live data.

The caching feature allows for incremental updates, improving performance. When you create a caching job, CData Connect tries to find date or date+time columns in the database that show which rows are new or have changed since the last run. CData Connect can then run the caching job for those rows only. Otherwise, CData Connect runs a full update.

March 29, 2024

Changes, improvements, and bug fixes

General

  • Added ability to reference cells in other sheets in the Excel Add-in. As you change the values in the sheet, the Excel Add-in executes a new query. For example, the following filter criteria references the @InputSheet!A2 parameter, which is cell A2 of the sheet InputSheet. The @ prefix indicates that Industry is a required parameter.

     SELECT BillingState, Name FROM Account WHERE Industry = @InputSheet!A2
    
  • Improved the way in which a user selects columns for import in Excel for the web Add-in by allowing checkbox selection and sortable column headers.

  • The API Connector now displays the Callback URL for OAuth connection.

  • The API Connector has the added ability to specify custom repeat elements in the connector setup. This is an advanced feature that gives users more flexibility over controlling how data from the API is parsed.

Connectors

  • PayPal (Fix): OAuth issue fixed.

  • Sage Intacct (Fix): Support for LIMIT functions fixed.

  • Zoho Projects (Fix): Fixed length string error with Projects table metadata.

  • Monday (Update): Users can now specify which API version to use to connect to Monday.com.

  • Oracle (Fix): Fixed an issue when listing tables where the selected schema was not being sent to Oracle and performance was impacted.

March 22, 2024

Changes, improvements, and bug fixes

General

  • The Name field for Custom Reports has been moved to its own section for ease of identification and access.

  • The Virtual Datasets feature is now available for query users. Query users can access all the workspaces for which they have permission.

  • In Data Explorer, the comments are now working correctly in the SQL editor.

  • In Data Explorer, improved the error handling when saving a derived view that contains multiple columns with the same name. When attempting to create a derived view with this condition, consider using aliases for the common column names.

Connectors

  • Sage Intacct (Fix): Fixed issue with AccountType table querying.

  • HubSpot (Fix): Fixed issue with WebAnalytics view where too much data was causing an error.

March 8, 2024

Changes, improvements, and bug fixes

General

  • Fix: Fixed an issue when retrieving derived views in Azure Data Factory.

Connectors

  • ADP (Update): Added support for using PEM certificates for TLS client authentication.

  • Blackbaud FE NXT (New): Blackbaud FE NXT has been added as a new connector.

  • NetSuite (Fix): Resolved a problem when querying tables using SuiteScript that returned no results.

March 1, 2024

Changes, improvements, and bug fixes

General

  • Fix: Fixed an issue that prevented previewing API Connector tables with spaces in their names.

  • Fix: Fixed an issue preventing virtual dataset OData endpoints from being queried before the $metadata endpoint was queried for the first time.

  • Fix: Fixed an issue with CASE statements when joining two tables.

February 23, 2024

Changes, improvements, and bug fixes

Connectors

  • ADP (Update): Added new connection property of SSLClientCertType.

  • HubSpot (Update): Added support for subqueries to the WebAnalytics table.

  • LinkedIn (Update): Added support for v2 of Legacy API.

  • Square (Fix): Fixed an issue authenticating to Square.

  • Zuora (Update): Added support for RevenueSchedule and PaymentMethodSnapshot.

February 16, 2024

Changes, improvements, and bug fixes

General

  • Update: Users can now create connections and sign up for a new account from the Excel Add-in.

February 9, 2024

Changes, improvements, and bug fixes

General

  • Update: v23 is now available for all connectors, with the exception of Query Federation.

  • New: SAS Viya is now supported as a client tool for Connect Cloud. SAS Viya is a leading platform for transformative analytics solutions in today’s data-driven landscape. With Connect Cloud, you can connect SAS Viya to live data from hundreds of different data sources.

  • New: You can now define primary keys for views in OData. This allows for better integration with tools like Salesforce Connect and SAP Analytics Cloud.

February 2, 2024

Changes, improvements, and bug fixes

General

  • Updated OData fix for Salesforce Lightning Connect so that OData entities which do not have any Key properties will always return a composite Key made up of all properties.

Connectors

  • Twitter (Removed): We regret to inform you that this connector is currently unavailable. For more information or assistance, please reach out to our dedicated support team. Thank you for your understanding.

  • Dynamics CRM (Deprecated): Customers should instead use the Dynamics 365 connector when connecting to Dynamics CRM.

January 26, 2024

Changes, improvements, and bug fixes

General

  • Update: Added support for composite keys in OData entities.
  • Fix: Fixed an issue where OData queries against null literals were failing.
  • Update: Added a prompt to inform users when their pop-up blocker is preventing them from authorizing a connection in the Connections Settings page.
  • Fix: Fixed an issue on the Users tab to allow sorting by clicking on the column header.
  • Update: Added functionality to inform users how to access their data after successfully authenticating their connection.
  • Update: Users can now access virtual datasets in the Looker Studio plug-in.

Connectors

  • Kintone (Fix): Resolved a problem when making LIKE queries to the Kintone connector.
  • Zuora (Update): Some views in Zuora were updated to work without providing specific date range criteria by not including the Id in the view. This is due to logic in Zuora’s API.

January 19, 2024

Changes, improvements, and bug fixes

General

  • Fix: Fixed an issue in the Excel Add-in when updating a field that has a decimal type.
  • Fix: Resolved an issue in the Excel Add-in where it was incorrectly sending an INSERT command when the user was updating a document.
  • Update: Query users are now able to refresh the metadata cache for a connection in the Data Explorer.

Connectors

  • ALL (Update): The custom reports tab is now disabled if you have not authenticated to the data source.
  • Xero (Update): Updated the login button for Xero to include Xero branding.

January 12, 2024

Changes, improvements, and bug fixes

General

  • Update: In the onboarding wizard, the documentation for the connection configuration page is displayed automatically to help users set up their connections.
  • Fix: Resolved an issue that could cause a Data Explorer error when querying data if the schema contained too much data.
  • Fix: Resolved an issue in the Excel Add-in where Update queries could fail.
  • Informational: Display a banner in the OData page, informing users that this page will be deprecated in the future, and that users should use the Virtual Datasets feature instead.

Connectors

  • Netsuite (Update): Fixed an issue where search fields in saved search custom reports were returning empty values.

January 5, 2024

Changes, improvements, and bug fixes

General

  • Fix: Resolved an issue in the Data Explorer where queries were timing out after 100 seconds.
  • Fix: Removed the Sign In button in the onboarding wizard from the connection pages when OAuth is not the default auth scheme.
  • Fix: Fixed an issue in our billing system so that failed queries are not counted against row usage.
  • Fix: Resolved an issue in the Excel Add-in where updates were not generating logs.
  • Update: Added support in the Excel Add-in to delete and update tables in a workspace.
  • Update: Updated our OData service to report more informational error messages to users when querying the service.

Connectors

  • DocuSign (New): DocuSign has been added as a new connector.
  • Shopify (Update): Added support for the IN operator in the DELETE clause of the Shopify connector. This allows users to delete rows from the Excel Add-in and push those changes back into Shopify.

December 22, 2023

What’s New

AI Generator

We have released a new feature called AI Generator. This innovative feature allows Connect Cloud to decode language naturally, comprehend nuances, and translate them into SQL queries seamlessly navigating through diverse data sources. The convergence of AI and ML technologies within the cloud-based data virtualization tool eliminates the need for intricate technical knowledge, simplifying and streamlining data connectivity across your organization.

Connect Cloud AI Generator’s allure stems from its intuitive, user-centered design. The days of grappling with complex SQL queries are over. Imagine a business user asking, “Find me the highest growth customers compared to the same period last year.” AI Generator springs into action, translates the question into SQL instructions that tap into diverse sources, applies time-based filters, and presents insights.

New Connector

  • Quickbase has been added as a new connector.

Changes, improvements, and bug fixes

General

  • Update: Added a prerequisites section to the docs that explains which IP ranges to whitelist for certain connection types.
  • Improvement: Improved the error handling of our OData service endpoint to include more information about failures, to facilitate easier problem diagnostics.
  • Fix: Resolved a problem with Databricks connections when using the Azure Service Principal auth scheme.

Connectors

  • Databricks (Update): Moved catalog to the main settings page to support their release of Unity Data Catalog.
  • Excel (Fix): Resolved a problem where setting TypeDetectionScheme to ‘ColumnFormat’ resulted in incorrect data types being reported for some columns.
  • NetSuite (Fix): Fixed an issue when using SuiteQL where parsing a long value in the ‘externalid’ column from custom record lists resulted in an error.
  • Shopify (Update): Added support for deleting items from the Excel Addin.

December 15, 2023

What’s New

Virtual Datasets

We have released a new feature called virtual datasets which is a data catalog that streamlines the accessibility of diverse data sources by applying an innovative way to manage your data. Virtual datasets provide a sleek way to organize, catalog, and control access to specific data in CData Connect Cloud. You can bundle related data items separately in a simple and scalable way. Virtual datasets offer an intuitive and customizable organization scheme that streamlines data analysis across numerous business functions.

The core functionality of virtual datasets provides a structured organizational scheme to access data items. Virtual datasets architecture is a data management approach that favors synergy across teams and reduces data silos. It establishes a powerful structured framework for organizations to treat their data as a product and provide access to their valuable data resources. As each business domain assumes responsibility for its respective data sources, teams are empowered to operate efficiently, collaboratively, and consistently with their data.

Changes, improvements, and bug fixes

  • Update: Added a prerequisite section in the Sage Intacct documentation to inform users how to connect to Sage Intacct from Connect Cloud.
  • Improvement: The Excel Add-in and Google Sheets Add-in both now escape column names when building queries. This allows columns with special characters to be used in select and filter criteria.

December 8, 2023

Changes, improvements, and bug fixes

General

  • Update: Improved the search bar behavior when navigating to different connections and folders.
  • Fix: Resolved an issue with user-defined connections where some users were unable to query the data source.
  • Excel Addin (Update): When selecting columns, the Excel Addin will now escape column names properly to avoid errors for columns with spaces.

Connectors

  • NetSuite (Fix): Added two columns ‘zip’ and ‘addrphone’ to the customerAddressbookEntityAddress table.
  • NetSuite (Fix): Resolved an issue when filtering on the ‘IsYear’ column of the accountingperiod table was failing.
  • NetSuite (Fix): Fixed a problem where NULL results were being returned when querying a saved search with SUM, AVG, or MAX summary types.
  • PowerBI XMLA (Update): Power BI XMLA connector now supports multiple values for the Workspace property.
  • Sage Intacct (Fix): Fixed an issue when updating the ItemAggregate column of the Glbatch table.

November 17, 2023

What’s New

Virtual SQL Server now supports connections from Dataverse.

Changes, improvements, and bug fixes

Connectors

  • QuickBooks (Fix): Added support for empty values of enum types in custom reports for the QuickBooks Online connector. Instead of only being able to pick a single transaction type when creating a custom report, users have the option to provide an empty value to get a report that includes all transaction types.

November 3, 2023

Changes, improvements, and bug fixes

Connectors

  • Adobe Analytics (Fix): Fixed a problem causing the OAuth auth scheme to not work with Adobe Analytics.
  • API Connector (Fix): Resolved a problem where a NULL value was being returned when specifying a value from a JSON array as a column.
  • ZohoBooks (Fix): Corrected the data type for the ProductNumber column in the InvoicePayments view to be a varchar.

October 28, 2023

What’s New

Two new connectors are live on CData Connect Cloud: Greenplum and Outreach.io.

Changes, improvements, and bug fixes

Connectors

  • Airtable (Fix): Resolved an issue when loading tables from Airtable.
  • Azure AD (Fix): Fixed an issue when requesting metadata for some column types. In some cases, the isNullable field returned an invalid value.
  • Google BigQuery (Fix): Resolved an issue where the function JSON_EXTRACT_SCALAR was returning an unknown data type.
  • NetSuite (Fix): Fixed a problem when querying a saved search with a summation function. Queries using SUM, AVG, & MAX were incorrectly returning a null value for saved searches.
  • Sage Intacct (Improvement): The GLaccountNo column’s data type in the AccountBalance table has been changed to a string from a double.
  • Zuora (Fix): Resolved a problem when using a CASE WHEN statement in a GROUP BY clause.

October 20, 2023

What’s New

Two new client tools are now supported on CData Connect Cloud: Google Data Fusion and Microstrategy.

SQL API

CData Connect Cloud now provides a full-featured API that can query data, perform batch operations, and execute stored procedures across all data sources configured in your account. Any REST-compatible application or client tool capable of creating HTTP requests can integrate with the API. For more information, see the REST API docs.

Changes, improvements, and bug fixes

General

  • Fix: Resolved a problem when editing a derived view while multiple derived views were open in the data explorer.
  • Improvement: Added a new success message when saving derived views.
  • Fix: Fixed a bug that was preventing users from making changes to derived views.
  • Improvement: Added support for creating derived views from JOIN queries that combine data from multiple data sources.

Connectors

  • Exact Online (Fix): The connector was unable to authenticate for several regions in Europe.
  • Adobe Analytics (Fix): Resolved an issue when authenticating with an Adobe Analytics account. Adobe is deprecating their JWT authentication method in favor of their Server to Server authentication method.

October 13, 2023

Changes, improvements, and bug fixes

  • Excel Add-in (Fix): Resolved a problem when updating values of type Integer from Excel back to the data source.
  • Excel Desktop (Improvement): Added support for the Excel Desktop client for Connect Cloud Starter Tier users. This client supports Excel macros.

October 6, 2023

Changes, improvements, and bug fixes

General

  • Improvement: Users can now change their email login.
  • Fix: Resolved an issue where logs from the test connection were not being properly generated for a short period of time.
  • Fix: Resolved a problem with custom reports where editing a report was not loading values.
  • Fix: Fixed an issue in the Excel Add-in client where auto-generated queries were missing single-quotes.

Connectors

  • API Connector (Improvement): Added a Documentation link to the Add Table page to make it easier to navigate to the documentation when setting up tables.
  • API Connector (Improvement): Improved the table settings UX and added helper descriptions for some settings.
  • Fix: Fixed an issue in API Connector where trailing spaces in headers or parameters fields could result in invalid authentication.
  • Exact Online (Fix): Resolved an issue where the “Use Bulk API” setting was not being saved properly when turning it off.
  • QuickBooks Online (Alert): Resolved a problem where customer credentials became invalid. All customers were required to reauthenticate to QuickBooks after this change.
  • Snowflake (Fix): Resolved an issue where a metadata request for the SIGN function was returning an invalid data type.
  • Zuora (Fix): Fixed a problem in the Zuora connector which caused CASE WHEN inside of GROUP BY queries to fail.

September 29, 2023

What’s New

API Connector

CData is excited to announce a new and highly requested feature to improve your data integration and analysis experience: API Connector. You can now directly connect your own API to CData Connect Cloud.

CData understands the value of making data available from various data sources, and we know that your proprietary APIs matter just as much as separate app connections. Our new API Connector is a powerful bridge between CData Connect Cloud and your custom and proprietary APIs. Now, you can connect to any cloud-based API that produces XML or JSON. You can run queries and even manage user access to your APIs right from your CData Connect Cloud account. The server-side filtering option can even improve execution speeds.

Changes, improvements, and bug fixes

  • Fix: Fixed an issue where PowerBI successfully connected over TDS but failed to retrieve data.
  • Fix: Fixed a problem with filters in OData where columns with boolean or datetime types were not being applied properly to the results. These filters were not resulting in failures but were not properly being applied as filters .
  • Fix: Fixed a bug where authentication was being refused when switching credentials in the CData Connect Cloud UI from a shared account to a personal one.
  • Fix: Fixed a bug related to complex Exact Online queries which caused the UseBulkAPI property inside a filter to freeze as True.