# Archives **URL:** https://community.cdata.com/c/archives/12.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the Archives category](https://community.cdata.com/t/about-the-archives-category/1442)
**Author:** [@system](https://community.cdata.com/u/system)\ **Replies:** 0\ **Last updated:** [October 21, 2026, 3:35pm UTC](https://community.cdata.com/t/about-the-archives-category/1442 "2026-10-21T15:35:16Z")
This section contains content that has been archived by CData. --- ## [How to enable specific SSH host key algorithm for SFTP connector (rsa-sha2-512)](https://community.cdata.com/t/how-to-enable-specific-ssh-host-key-algorithm-for-sftp-connector-rsa-sha2-512/1315)
**Author:** [@vgarcia](https://community.cdata.com/u/vgarcia)\ **Replies:** 0\ **Last updated:** [July 20, 2026, 8:31pm UTC](https://community.cdata.com/t/how-to-enable-specific-ssh-host-key-algorithm-for-sftp-connector-rsa-sha2-512/1315 "2026-07-20T20:31:38Z")
Description: We are using DataVirtuality 25.4 with an SFTP connector via JSch 0.2.7. After upgrading to DV 25.4, our SFTP connection to an external partner stopped working due to an SSH algorithm negotiation failure. T… --- ## [CData Virtuality 25.4: FIPS support for SSL connections, Git Integration improvements, and more](https://community.cdata.com/t/cdata-virtuality-25-4-fips-support-for-ssl-connections-git-integration-improvements-and-more/1257)
**Author:** [@Anna](https://community.cdata.com/u/Anna)\ **Replies:** 0\ **Last updated:** [December 24, 2025, 6:27pm UTC](https://community.cdata.com/t/cdata-virtuality-25-4-fips-support-for-ssl-connections-git-integration-improvements-and-more/1257 "2025-12-24T18:27:21Z")
In this release, we’ve implemented Federal Information Processing Standards (FIPS) support for SSL connections, ensuring that all cryptographic operations used by the CData Virtuality Server and JDBC driver can be perfor… --- ## [CData Virtuality 25.3: Clustering support on Azure, a new function, and much more](https://community.cdata.com/t/cdata-virtuality-25-3-clustering-support-on-azure-a-new-function-and-much-more/1228)
**Author:** [@Anna](https://community.cdata.com/u/Anna)\ **Replies:** 0\ **Last updated:** [October 30, 2025, 6:36pm UTC](https://community.cdata.com/t/cdata-virtuality-25-3-clustering-support-on-azure-a-new-function-and-much-more/1228 "2025-10-30T18:36:08Z")
On the Server side, we’ve added a new REGCLASS function and integrated two new CData JDBC drivers: SharePoint and Email. We’ve also updated the CData JDBC Driver for Jira to v25.0.9389.0 and the Neo4J JDBC driver to vers… --- ## [CData Virtuality 25.2: Many improvements and something more](https://community.cdata.com/t/cdata-virtuality-25-2-many-improvements-and-something-more/1210)
**Author:** [@Anna](https://community.cdata.com/u/Anna)\ **Replies:** 0\ **Last updated:** [October 2, 2025, 4:04pm UTC](https://community.cdata.com/t/cdata-virtuality-25-2-many-improvements-and-something-more/1210 "2025-10-02T16:04:15Z")
This release, which went out on August 5, is probably our most improvement-filled release, and, of course, it also includes several new features and a number of bug fixes. Speaking of improvements to the Server, most no… --- ## [CData Virtuality Cloud Agent: Simplifying Hybrid Data Connectivity](https://community.cdata.com/t/cdata-virtuality-cloud-agent-simplifying-hybrid-data-connectivity/1207)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [October 1, 2025, 11:06am UTC](https://community.cdata.com/t/cdata-virtuality-cloud-agent-simplifying-hybrid-data-connectivity/1207 "2025-10-01T11:06:30Z")
Hey CData Community! Got cloud apps that need to talk to on-prem data? CData Virtuality’s Cloud Agent is your secure, no-firewall-hacks-needed bridge between cloud deployments and private networks. Whether it’s SQL Ser… --- ## [Facebook Graph and Marketing API v23 connector update](https://community.cdata.com/t/facebook-graph-and-marketing-api-v23-connector-update/1182)
**Author:** [@Eugene\_Bykov](https://community.cdata.com/u/Eugene_Bykov)\ **Replies:** 0\ **Last updated:** [September 10, 2025, 11:10am UTC](https://community.cdata.com/t/facebook-graph-and-marketing-api-v23-connector-update/1182 "2025-09-10T11:10:15Z")
Facebook Graph and Marketing API version 21 ended life yesterday. There is no action required for you at this time. Note that starting May 2024, Facebook implemented the version auto-upgrade functionality. This means be… --- ## [Facebook Graph and Marketing API v23 connector announcement](https://community.cdata.com/t/facebook-graph-and-marketing-api-v23-connector-announcement/1165)
**Author:** [@Eugene\_Bykov](https://community.cdata.com/u/Eugene_Bykov)\ **Replies:** 0\ **Last updated:** [August 13, 2025, 12:40pm UTC](https://community.cdata.com/t/facebook-graph-and-marketing-api-v23-connector-announcement/1165 "2025-08-13T12:40:35Z")
Facebook Graph and Marketing API version 21, currently supported by the connector, will be available until September 9, 2025. To accommodate this change, the connector is currently being updated. Depending on our findin… --- ## [Google Ads API connector announcement](https://community.cdata.com/t/google-ads-api-connector-announcement/1164)
**Author:** [@Eugene\_Bykov](https://community.cdata.com/u/Eugene_Bykov)\ **Replies:** 0\ **Last updated:** [August 13, 2025, 11:36am UTC](https://community.cdata.com/t/google-ads-api-connector-announcement/1164 "2025-08-13T11:36:57Z")
The Google Ads API connector v18 is at its end of life. The sunset date for v18 is August 20. The earliest version of Virtuality Server, which natively supports v20 is 25.2, released last week. Recently Google updated t… --- ## [Fuzzy String Matching in SQL: Using Levenshtein Similarity in CData Virtuality](https://community.cdata.com/t/fuzzy-string-matching-in-sql-using-levenshtein-similarity-in-cdata-virtuality/1132)
**Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [July 18, 2025, 9:49am UTC](https://community.cdata.com/t/fuzzy-string-matching-in-sql-using-levenshtein-similarity-in-cdata-virtuality/1132 "2025-07-18T09:49:25Z")
Use case Compare strings that look similar but aren’t exactly the same — such as customer names, addresses, or product titles — in SQL queries. We are happy to announce that the development of built in functions to calc… --- ## [CData Virtuality 25.1: extended Python support on Windows and many improvements](https://community.cdata.com/t/cdata-virtuality-25-1-extended-python-support-on-windows-and-many-improvements/1104)
**Author:** [@Anna](https://community.cdata.com/u/Anna)\ **Replies:** 0\ **Last updated:** [June 6, 2025, 4:32pm UTC](https://community.cdata.com/t/cdata-virtuality-25-1-extended-python-support-on-windows-and-many-improvements/1104 "2025-06-06T16:32:04Z")
This release is packed with improvements: on the Server side, we’ve added support for Python code execution via OBJECTTABLE on Windows and implemented an Okta user storage provider for use with the CData Virtuality OAuth… --- ## [Google Ads API v18-19.1 connector announcement](https://community.cdata.com/t/google-ads-api-v18-19-1-connector-announcement/1101)
**Author:** [@Eugene\_Bykov](https://community.cdata.com/u/Eugene_Bykov)\ **Replies:** 0\ **Last updated:** [May 30, 2025, 2:24pm UTC](https://community.cdata.com/t/google-ads-api-v18-19-1-connector-announcement/1101 "2025-05-30T14:24:12Z")
The Google Ads API connector v17 is at its end of life. The sunset date for v17 is June 4. The earliest version of Virtuality Server, which natively supports v18 is 4.10. All 25.x versions also include v18 libraries. Ver… --- ## [How Do I Manage Data Lineage and Impact Analysis in CData Virtuality?](https://community.cdata.com/t/how-do-i-manage-data-lineage-and-impact-analysis-in-cdata-virtuality/1083)
**Author:** [@jessicashepherd](https://community.cdata.com/u/jessicashepherd)\ **Replies:** 1\ **Last updated:** [May 15, 2025, 11:37pm UTC](https://community.cdata.com/t/how-do-i-manage-data-lineage-and-impact-analysis-in-cdata-virtuality/1083 "2025-05-15T23:37:21Z")
Hi everyone, I’m working with CData Virtuality and I’m looking for an easy way to track data lineage and perform impact analysis on my virtual data layers. Basically, I want to: See where my data is coming from Unders… --- ## [Announcing CData Virtuality 25.0: our next major release](https://community.cdata.com/t/announcing-cdata-virtuality-25-0-our-next-major-release/1070)
**Author:** [@Anna](https://community.cdata.com/u/Anna)\ **Replies:** 0\ **Last updated:** [April 9, 2025, 11:52am UTC](https://community.cdata.com/t/announcing-cdata-virtuality-25-0-our-next-major-release/1070 "2025-04-09T11:52:05Z")
We are thrilled to announce the first release of the new version 25 of CData Virtuality. Along with it comes the brand-new version of the CData Virtuality Documentation to help you get the most out of the update. The im… --- ## [Announcing CData Virtuality 4.11: Key enhancements, fixes, and new integrations](https://community.cdata.com/t/announcing-cdata-virtuality-4-11-key-enhancements-fixes-and-new-integrations/1062)
**Author:** [@Anna](https://community.cdata.com/u/Anna)\ **Replies:** 0\ **Last updated:** [March 24, 2025, 7:58pm UTC](https://community.cdata.com/t/announcing-cdata-virtuality-4-11-key-enhancements-fixes-and-new-integrations/1062 "2025-03-24T19:58:35Z")
On the Server side, we’ve implemented a new feature – the “importer.defaultCatalog” model property. We’ve also enhanced Google BigQuery to allow setting partitioning and clustering options for recommended optimizations … --- ## [Exposing existing virtual views via OData](https://community.cdata.com/t/exposing-existing-virtual-views-via-odata/1028)
**Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [February 24, 2025, 10:39am UTC](https://community.cdata.com/t/exposing-existing-virtual-views-via-odata/1028 "2025-02-24T10:39:21Z")
To effectively utilize OData with CData Virtuality, it’s essential to meet specific requirements, including proper user permissions and the presence of primary keys in virtual views. This guide outlines these prerequisit… --- ## [Ensuring Data Quality in CData Virtuality: A Guide for Data Engineers](https://community.cdata.com/t/ensuring-data-quality-in-cdata-virtuality-a-guide-for-data-engineers/1023)
**Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [February 19, 2025, 12:26pm UTC](https://community.cdata.com/t/ensuring-data-quality-in-cdata-virtuality-a-guide-for-data-engineers/1023 "2025-02-19T12:26:55Z")
Why is Data Quality Important? In enterprise environments, data quality directly impacts operational efficiency, regulatory compliance, and decision-making. Poor-quality data can lead to inaccurate reports, financial los… --- ## [How to Utilise the Information Schema in Data Virtuality](https://community.cdata.com/t/how-to-utilise-the-information-schema-in-data-virtuality/1021)
**Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [February 13, 2025, 12:11pm UTC](https://community.cdata.com/t/how-to-utilise-the-information-schema-in-data-virtuality/1021 "2025-02-13T12:11:10Z")
Introduction One of the often overlooked features of CData Virtuality is the fact that it contains a complete and ready to use metadata repository containing all of the tables, views, columns and data types for all of … --- ## [GoogleSheets datasource setup](https://community.cdata.com/t/googlesheets-datasource-setup/886)
**Author:** [@ColdTrackTom](https://community.cdata.com/u/ColdTrackTom)\ **Replies:** 1\ **Last updated:** [February 10, 2025, 9:44am UTC](https://community.cdata.com/t/googlesheets-datasource-setup/886 "2025-02-10T09:44:37Z")
Looking for config details for the google sheets connector within DataVirtuality. I’m getting the error below: This app is blocked This app tried to access sensitive info in your Google Account. To keep your account sa… --- ## [How to perform quality control and vulnerability scans in Data Virtuality](https://community.cdata.com/t/how-to-perform-quality-control-and-vulnerability-scans-in-data-virtuality/859)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 2\ **Last updated:** [January 8, 2025, 8:20am UTC](https://community.cdata.com/t/how-to-perform-quality-control-and-vulnerability-scans-in-data-virtuality/859 "2025-01-08T08:20:50Z")
Introduction SQL code static code analysis is an essential practice that can assist in identifying coding issues, errors, and vulnerabilities in SQL code before it is executed. Static code analysis tools for SQL code can… --- ## [Let’s Discuss the Exciting New Features in CData Virtuality 4.8!](https://community.cdata.com/t/let-s-discuss-the-exciting-new-features-in-cdata-virtuality-4-8/906)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [September 26, 2024, 6:59pm UTC](https://community.cdata.com/t/let-s-discuss-the-exciting-new-features-in-cdata-virtuality-4-8/906 "2024-09-26T18:59:39Z")
Hey everyone, Great news! CData has just released Virtuality 4.8, and it’s packed with fantastic new features that could significantly enhance our data virtualization experience. I wanted to share some highlights and … --- ## [Delta lake support?](https://community.cdata.com/t/delta-lake-support/865)
**Author:** [@Rajesh](https://community.cdata.com/u/Rajesh)\ **Replies:** 1\ **Last updated:** [July 26, 2024, 8:39pm UTC](https://community.cdata.com/t/delta-lake-support/865 "2024-07-26T20:39:10Z")
Hi, I’m exploring the capabilities of CData Virtuality for our use, and am unable to find any information on support for delta lake on Azure Data Lake Store as a source. I don’t see any CData drivers for it either. I… --- ## [Announcing CData Virtuality 4.7: Role-based UI, UDF, and Trino Connector! ](https://community.cdata.com/t/announcing-cdata-virtuality-4-7-role-based-ui-udf-and-trino-connector/869)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 23, 2024, 1:54pm UTC](https://community.cdata.com/t/announcing-cdata-virtuality-4-7-role-based-ui-udf-and-trino-connector/869 "2024-07-23T13:54:07Z")
Hello CData Community! We’re thrilled to announce the release of CData Virtuality 4.7, bringing you innovative updates that will revolutionize your data management and governance. :glowing\_star: Key Highlights of C… --- ## [Connecting PySpark via JDBC using Jupyter Notebook](https://community.cdata.com/t/connecting-pyspark-via-jdbc-using-jupyter-notebook/858)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:35pm UTC](https://community.cdata.com/t/connecting-pyspark-via-jdbc-using-jupyter-notebook/858 "2024-07-12T17:35:05Z")
Install DataVirtuality JDBC driver Windows Download the latest DataVirtuality JDBC driver from here. Copy the jar file to your spark install folder: D:\\spark-2.3.1-bin-hadoop2.6\\jars Linux Download the latest DataVi… --- ## [Updating Data Virtuality Platform license for on-premise servers](https://community.cdata.com/t/updating-data-virtuality-platform-license-for-on-premise-servers/857)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:34pm UTC](https://community.cdata.com/t/updating-data-virtuality-platform-license-for-on-premise-servers/857 "2024-07-12T17:34:05Z")
There are two methods for updating the platform license. These methods do NOT require the server to be restarted. Web UI Copying the license file to the correct Data Virtuality folder Web UI In this example, my Data V… --- ## [Add a Column to a View That Uses Batch Job or Slowly Changing Dimensions (Simple Version)](https://community.cdata.com/t/add-a-column-to-a-view-that-uses-batch-job-or-slowly-changing-dimensions-simple-version/856)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:31pm UTC](https://community.cdata.com/t/add-a-column-to-a-view-that-uses-batch-job-or-slowly-changing-dimensions-simple-version/856 "2024-07-12T17:31:19Z")
The example first shows how to manually insert a default value and then gives the command to read the values via a subquery. There are a few things to keep in mind: The snippets assume that field “Status” of type “sho… --- ## [MSSQL ENDOFMONTH Replacement](https://community.cdata.com/t/mssql-endofmonth-replacement/855)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:26pm UTC](https://community.cdata.com/t/mssql-endofmonth-replacement/855 "2024-07-12T17:26:49Z")
Workaround procedure for ENDOFMONTH-Funktion (DAX) - DAX | Microsoft Learn CREATE VIRTUAL PROCEDURE views.endofmonth( IN getdate date ) returns (outdate date) asBEGIN DECLARE date monthlater = timestampadd( SQL\_… --- ## [Use Values Larger Than 2147483647 with FROM\_UNIXTIME](https://community.cdata.com/t/use-values-larger-than-2147483647-with-from-unixtime/854)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:25pm UTC](https://community.cdata.com/t/use-values-larger-than-2147483647-with-from-unixtime/854 "2024-07-12T17:25:38Z")
At present, Data Virtuality Server only supports integers in FROM\_UNIXTIME and TIMESTAMPADD. As 2147483647 is the maximum positive value for a 32-bit signed binary integer, this means that larger values won’t work. But w… --- ## [Improving Query Performance Using the Filter Parameter for Google Analytics](https://community.cdata.com/t/improving-query-performance-using-the-filter-parameter-for-google-analytics/853)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:15pm UTC](https://community.cdata.com/t/improving-query-performance-using-the-filter-parameter-for-google-analytics/853 "2024-07-12T17:15:58Z")
In some cases, query performance can be speedied up thanks to the filter parameter. In this guide, we’ll consider an example where it helped to reduce load time from 30 minutes to just one minute. Here’s the original re… --- ## [Google Analytics Historical Data Using Batch Update and Avoiding Sampling](https://community.cdata.com/t/google-analytics-historical-data-using-batch-update-and-avoiding-sampling/852)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:13pm UTC](https://community.cdata.com/t/google-analytics-historical-data-using-batch-update-and-avoiding-sampling/852 "2024-07-12T17:13:51Z")
Let’s suppose that we have a Google Analytics query like this, which however is subject to sampling by Google Analytics because the data are just too large. SELECT visitors, newVisits, percentNewVisits, visitorType, v… [Next page](https://community.cdata.com/c/archives/12.md?page=1)