# \#cdata-virtuality **URL:** https://community.cdata.com/tag/cdata-virtuality/455.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [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 Product Updates Q3 2025](https://community.cdata.com/t/cdata-product-updates-q3-2025/1237)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [November 13, 2025, 7:37pm UTC](https://community.cdata.com/t/cdata-product-updates-q3-2025/1237 "2025-11-13T19:37:44Z")
CData Product Updates Newsletter This quarter’s CData update is a little different. Instead of separate newsletters for each product, we’re sharing one combined view across the entire CData portfolio. --- ## [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… --- ## [CData Product Updates Q3 2025](https://community.cdata.com/t/cdata-product-updates-q3-2025/1168)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [September 3, 2025, 11:38am UTC](https://community.cdata.com/t/cdata-product-updates-q3-2025/1168 "2025-09-03T11:38:09Z")
CData Product Updates Newsletter This quarter’s CData update is a little different. Instead of separate newsletters for each product, we’re sharing one combined view across the entire CData portfolio. With Foundations 2… --- ## [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 Newsletter - Q2 2025](https://community.cdata.com/t/cdata-virtuality-newsletter-q2-2025/1114)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [June 20, 2025, 6:08pm UTC](https://community.cdata.com/t/cdata-virtuality-newsletter-q2-2025/1114 "2025-06-20T18:08:10Z")
CData Virtuality Newsletter Data teams today are asked to do more—faster, smarter, and without slowing down operations. This quarter, we delivered on that need: Strategic platform enhancements in the v25 release Expa… --- ## [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… --- ## [Connecting TIBCO Spotfire to CData Virtuality using JDBC](https://community.cdata.com/t/connecting-tibco-spotfire-to-cdata-virtuality-using-jdbc/1099)
**Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [May 26, 2025, 11:37am UTC](https://community.cdata.com/t/connecting-tibco-spotfire-to-cdata-virtuality-using-jdbc/1099 "2025-05-26T11:37:53Z")
Connecting TIBCO Spotfire Information Services to a CData Virtuality server requires a custom JDBC data source template. Below we outline the driver details and provide a correctly structured XML template (rooted at \ **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 … --- ## [CData Virtuality Newsletter - Q1 2025](https://community.cdata.com/t/cdata-virtuality-newsletter-q1-2025/1044)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [March 12, 2025, 8:26pm UTC](https://community.cdata.com/t/cdata-virtuality-newsletter-q1-2025/1044 "2025-03-12T20:26:49Z")
CData Virtuality Newsletter We’ve been hard at work enhancing CData Virtuality to improve usability, expand AI capabilities, and deliver new product innovations. In this newsletter, we present what’s new and what’s com… --- ## [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 … --- ## [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… --- ## [CData Virtuality Newsletter - Q4 2024](https://community.cdata.com/t/cdata-virtuality-newsletter-q4-2024/931)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [December 12, 2024, 3:29pm UTC](https://community.cdata.com/t/cdata-virtuality-newsletter-q4-2024/931 "2024-12-12T15:29:16Z")
CData Virtuality Newsletter Discover the latest highlights from CData Virtuality! From our debut in Gartner’s Magic Quadrant to exciting new product releases, there is plenty to explore. CData recognized in the G… --- ## [CData Virtuality Newsletter - Q3 2024](https://community.cdata.com/t/cdata-virtuality-newsletter-q3-2024/893)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [September 11, 2024, 1:23pm UTC](https://community.cdata.com/t/cdata-virtuality-newsletter-q3-2024/893 "2024-09-11T13:23:29Z")
CData Virtuality Newsletter Welcome to the latest edition of our CData Virtuality newsletter. Every quarter, we’ll bring you a brief overview of the key developments from the past quarter and what to expect in the coming… --- ## [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… --- ## [Show Running Queries on Redshift via Native Interface](https://community.cdata.com/t/show-running-queries-on-redshift-via-native-interface/851)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:12pm UTC](https://community.cdata.com/t/show-running-queries-on-redshift-via-native-interface/851 "2024-07-12T17:12:31Z")
When native queries are enabled in your Amazon Redshift data warehouse (this can be done by adding supportsNativeQueries=true as a translator property to the data source configuration), you can easily view the 200 most r… --- ## [Special characters in columns are in wrong encoding](https://community.cdata.com/t/special-characters-in-columns-are-in-wrong-encoding/850)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:10pm UTC](https://community.cdata.com/t/special-characters-in-columns-are-in-wrong-encoding/850 "2024-07-12T17:10:38Z")
Googles response from the server is in UTF-8 but some columns maintain their original charset, so your Umlauts or other special charaters will look defect ( e.g. campaignName). To fix it, you can use TO\_CHARS and TO\_BYT… --- ## [Facebook: Handle Paged Results](https://community.cdata.com/t/facebook-handle-paged-results/849)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 5:09pm UTC](https://community.cdata.com/t/facebook-handle-paged-results/849 "2024-07-12T17:09:22Z")
If you’re using Facebook API, it’s important to remember that by default, most responses to API requests are paginated by default. In this article, we describe how to work with paged results. Facebook will return a next … [Next page](https://community.cdata.com/tag/cdata-virtuality/455.md?match_all_tags=true&page=1&tags%5B%5D=cdata-virtuality)