Search

Release Notes

Release Notes

November 29, 2024

Changes, improvements, and bug fixes

General

  • Added Grafana as a client tool.

  • Improved Excel Add-in support for large datasets.

  • You can now update a nvarchar type in Excel Add-in.

  • Improved Data Explorer user interface for cells containing long values (option to truncate or scroll).

  • Fixed varchar casting for the Google Sheets add-on.

  • When an update fails in the Google Sheets add-on, the color of the changed fields now remains red, as expected.

Connectors

  • Salesforce (Improvement): The default value for Include Reports is now True.

  • Dynamics 365 Business Central (Update): The property MinimumColumnSize is now available in CData Connect Cloud.

  • HubSpot (Update): The property ExpandAssociations is now available in CData Connect Cloud.

November 15, 2024

Changes, improvements, and bug fixes

General

  • The Query Builder now persists when navigating away from it and then returning.

  • Improvement in how OData truncates data types.

  • In the Excel Add-in, formula references now persist when you refresh the data.

  • The Google Sheets data changes back to black after a successful update.

  • java.math.BigDecimal class can now be cast to the java.lang.Integer class, as long as it is a specific column with a specific table in the data source.

Connectors

  • ADP (Update): The connector now allows mutiple filters on the ADP timecard table.

November 8, 2024

Changes, improvements, and bug fixes

General

  • Improved messaging with the Google Sheets batch update feature.

Connectors

  • Dynamics 365 (Fix): Fixed an issue where CData Connect Cloud was not allowing incremental updates with caching.

  • Jira Service Management (Fix): Fixed an issue where the RequestSLACycles view was only returning service requests in which the configured user was a request participant.

November 1, 2024

Changes, improvements, and bug fixes

General

  • Minor user interface and logging improvements for the Google Sheets add-on.

October 25, 2024

Changes, improvements, and bug fixes

General

  • Added new filter to the Looker Studio add-on to support filtering by email.

  • You can now connect Metabase to CData Connect Cloud via SQL Server.

  • SQL Server endpoint fix for large data volumes.

Connectors

  • API Connector (Fix): Fixed an issue with OAuth 2.0 sign in.

October 18, 2024

Changes, improvements, and bug fixes

General

  • Added ReTool and Axios as client tools.

  • Google Sheets add-on now performs batch record updates.

  • Incremental caching is now supported for all supported data sources.

  • Fixed an issue with OAuth connections for Excel Add-in for the Mac.

  • Minor user interface improvement for client tool endpoints.

  • Data now caches properly when you change the cache database.

Connectors

  • Bullhorn CRM (Fix): Minor driver fix for queries.

  • Snowflake (Fix): Fixed Snowflake partner integration.

  • QuickBooks Online (Update): Reconnect changed to Disconnect, as per a compliance review.

October 11, 2024

What’s New

  • The onboarding wizard now gives new users different options after successfully setting up a connection.

Changes, improvements, and bug fixes

General

  • Added Mode as a client tool.

  • Added Databricks as a client tool.

  • The Google Sheets add-on can now automatically determine primary keys and update the display.

  • You can now move assets between workspaces.

  • Fixed an issue with Power BI returning a null value.

Connectors

  • API Connector (Update): Improved OAuth functionality for certain use cases.

  • API Connector (Fix): Fixed an issue related to connecting to NetSuite.

  • NetSuite (Fix): Fixed decimal value in account view.

October 4, 2024

What’s New

  • You can now navigate away from Data Explorer and return to your queries.

  • The Connections overview page now contains a connection status column.

Changes, improvements, and bug fixes

General

  • Added Workato as a client tool.

  • You can now perform a single record update in the Google Sheets add-on.

  • Fixed an issue with jobs not caching.

Connectors

  • Bullhorn CRM (Fix): Exposed a field to fix a connection issue.

  • Zoho Creator (Fix): Fixed an issue with IN condition.

  • OData Connector (Fix): URL validation fix.

September 27, 2024

Changes, improvements, and bug fixes

General

  • Added Zapier as a client tool.

  • UseSSL is now enabled for all relevant drivers.

  • The Google Sheets add-on improved the performance of inserting records by completing the update in batches.

September 20, 2024

Changes, improvements, and bug fixes

General

  • Fixed an issue with the OpenAPI spec file.

  • Fixed an issue where SSO users were not able to invite others to their account.

  • The OData driver now contains the property Exclude Control Information Root Type.

  • The Google Sheets add-on now displays newly-updated cells in a different font color.

  • Fixed an issue for drivers that use the OAuth Client authentication scheme.

  • Changed the way federated queries are handled for sub-select queries. They are now executed as a dependent join instead of a merge join.

September 13, 2024

Changes, improvements, and bug fixes

General

  • Added ThoughtSpot as a client tool.

Connectors

  • Reckon Accounts Hosted connector (New): Reckon Accounts Hosted has been added as a new connector.

September 6, 2024

Changes, improvements, and bug fixes

General

  • You can now perform a single record insert in the Google Sheets add-on.

  • You can now see which tables/views are being cached in the Data Explorer and in Virtual Datasets.

Connectors

  • Zoho CRM (Fix): Fixed issue with retrieving Subforms for all records.

  • Sage Intacct (Fix): Fixed issue with Reportingbook field data.

  • NetSuite (Update): Exposed the rowscandepth property in the Advanced Settings tab.

August 30, 2024

Changes, improvements, and bug fixes

General

  • Added Jitterbit as a client tool.

  • Added Azure Logic Apps as a client tool.

August 23, 2024

Changes, improvements, and bug fixes

General

  • CData Connect Cloud now offers connectivity for the following client tools:

    • Redash
    • MicroStrategy
    • Node.js

  • Users can now specify local IP addresses so that SSH tunnels work.

  • Distinguished NULL values in data tables for better clarity.

  • Fixed issue in OpenAPI for tables with multiple primary keys.

Connectors

  • SurveyMonkey (Improvement): Added an option to bypass SurveyMonkey API request limitations.

  • Amazon Redshift (Fix): Fixed logo.

August 16, 2024

Changes, improvements, and bug fixes

General

  • CData Connect Cloud now offers connectivity for the following client tools:

    • SnapLogic
    • SAP Crystal Reports
    • Metabase

  • OAuth Client authentication was added to the API Connector.

August 2, 2024

Changes, improvements, and bug fixes

Connectors

  • Xero (Fix): Fixed an issue where the PKCE authentication scheme was not working.

July 26, 2024

Changes, improvements, and bug fixes

General

  • The Overview page now contains the row count of data for each connection.

Connectors

  • Query Federation (Fix): Fixed an issue where JOINs with derived views were failing.

  • MYOB (Improvement): The OAuthClientId and OAuthClientSecret fields are now exposed in the CData Connect Cloud settings.

  • SAP Success Factors (Improvement): The OAuthClientId and OAuthClientSecret fields are now exposed in the CData Connect Cloud basic settings. Also fixed an issue where the Learning API was returning errors.

  • JIRA (Fix): Changed the default authentication scheme to OAuth.

July 19, 2024

Changes, improvements, and bug fixes

General

  • Updated the Caching feature so that it is only allowed for certain data sources.

July 12, 2024

Changes, improvements, and bug fixes

General

  • Added Mulesoft as a client tool.

  • Added Salesforce External Services as a client tool.

  • Google Sheets add-on now provides users with the ability to remove scheduled queries from a spreadsheet.

  • Added ability to click on information in the Overview page to view details, such as query logs.

  • Corrected the link to the OpenAPI specification document in the workspace Endpoints dialog.

  • The metadata cache can now be refreshed per connection, instead of globally.

  • You can now adjust the width of the results columns in the Data Explorer.

Connectors

  • QuickBooks Online (Fix): Fixed issue where custom reports were not displaying in Data Explorer. (Click Save again to get your custom report to appear.)

June 28, 2024

Changes, improvements, and bug fixes

General

  • API was added to the main navigation bar to make it easier to navigate to the CData Connect Cloud SQL API.

Connectors

  • Sage 300 (Update): Added Sage 300 as an available driver.

  • Tsheets (Improvement): Added support for Project Activities, Project Activity Read Times, Project Activity Replies, and Project Notes tables.

  • Zoho CRM (Update): Renamed Events to Meetings.

  • Sage Intacct (Fix): Fixed stored procedure for creating custom reports.

June 21, 2024

Changes, improvements, and bug fixes

General

  • Added Cloud Data Fusion as a client tool.

  • Google Sheets add-on now includes operator types of ‘greater than or equal to’ and ‘less than or equal to’.

June 7, 2024

What’s New

OpenAPI Support

CData Connect Cloud now supports OpenAPI 2.0 and 3.0, allowing you to connect no-code/low-code applications that integrate with OpenAPI easily, such as Microsoft Power Apps. Simply go to CData Connect Cloud Virtual Datasets and download an OpenAPI specification (version 2.0 or 3.0) for the desired workspace. Then import the OpenAPI specification into your application and connect to your data.

Changes, improvements, and bug fixes

General

  • Added the ability to export Data Explorer results as a CSV file. Simply execute your query and click Download CSV.

May 31, 2024

Changes, improvements, and bug fixes

General

  • Added Delete functionality to Google Sheets add-on.

May 24, 2024

Changes, improvements, and bug fixes

General

  • Excel Add-in now includes operator types of ‘greater than or equal to’ and ‘less than or equal to’.

  • Fixed an issue with the Virtual Dataset OData endpoint by prepending an underscore instead of replacing the first character.

May 17, 2024

What’s New

Bubble

You can now connect from Bubble to CData Connect Cloud with Bubble’s plugin.

Changes, improvements, and bug fixes

General

  • Updated Excel Add-in to update tables with multiple primary keys. Also fixed column sorting to sort by primary key rather than alphanumerically.

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 Cloud’s new caching feature. The user selects tables to be cached, or saved to a database. CData Connect Cloud 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 Cloud 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 Cloud 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 Cloud can then run the caching job for those rows only. Otherwise, CData Connect Cloud 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.