CData Software Acquires Data Virtuality to Modernize Data Virtualization for the Enterprise
Data Virtuality brings enterprise data virtualization capabilities to CData, delivering highly-performant access to live data at any scale.
Explore how you can use the Data Virtuality Platform in different scenarios.
Learn more about the Data Virtuality Platform or to make your work with Data Virtuality even more successful.
Insights on product updates, useful guides and further informative articles.
Find insightful webinars, whitepapers and ebooks in our resource library.
Stronger together. Learn more about our partner programs.
Read, watch and learn what our customers achieved with Data Virtuality.
In our documentation you will find everything to know about our products
Read the answers to frequently asked questions about Data Virtuality.
In this on-demand webinar, we look at how a modern data architecture can help data scientists to be faster and to work more efficiently.
Learn more about us as a company, our strong partner ecosystem and our career opportunities.
How we achieve data security and transparency
While many platforms offer mere Python connections—which still force you to switch between different environments—Data Virtuality takes it a step further. We provide native Python integration, allowing you to say goodbye to the hassle of environment-hopping.
With Data Virtuality‘s native integration, eliminate the tedious process of switching between your Python environment and your data management tool. Focus more on coding and less on logistical headaches.
Run Python 3 scripts directly from SQL in our Code Editor. No separate Python environment required! Boost your productivity by seamlessly managing your data workflows in a single, unified platform.
Check out some examples below:
This script evaluates an expression and obtains the results by using Python’s functions:
SELECT *
FROM (
ObjectTable (
language 'python'
'import math
a = math.exp(3)'
COLUMNS "a" integer 'a')
AS x);;
This script evaluates multiple columns with multiple return:
SELECT *
FROM (
ObjectTable (
language 'python'
'a = 1 + 1
b = a + 1
c = b * 2'
COLUMNS "a" integer 'a',
"b" integer 'b',
"c" integer 'c')
AS x);;
This more complex script with the PASSING keyword uses multiple user-defined variables. Results are returned for each row mentioned in the COLUMNS field:
SELECT *
FROM (
ObjectTable (
language 'python'
'a = 1 + two
b = 2 + three
c = 3 + four
d = teststring
e = f
g = charhere'
PASSING '2' as two,
'3' as three,
'4' as four,
'''hello''' as teststring,
'25.0' as f,
'''s''' as charhere
COLUMNS "a" integer 'a',
"b" integer 'b',
"c" integer 'c',
"d" string 'd',
"e" double 'e',
"g" char 'g')
AS x);;
Go beyond the basics! With native Python integration, you get access to an extensive array of Python libraries. Dive into data visualization, machine learning, statistical analysis, and much more. The sky’s the limit!
For more information and examples, check out our documentation at Data Virtuality Documentation.
Don’t miss the opportunity to streamline your data workflows like never before. Start your free 30-day trial today – no credit card required, and signing up is a breeze.
Data Virtuality brings enterprise data virtualization capabilities to CData, delivering highly-performant access to live data at any scale.
Discover how integrating data warehouse automation with data virtualization can lead to better managed and optimized data workflows.
Discover how our ChatGPT powered SQL AI Assistant can help Data Virtuality users boost their performance when working with data.
While caching offers certain advantages, it’s not a one-size-fits-all solution. To comprehensively meet business requirements, combining data virtualization with replication is key.
Explore the potential of Data Virtuality’s connector for Databricks, enhancing your data lakehouse experience with flexible integration.
Generative AI is an exciting new technology which is helping to democratise and accelerate data management tasks including data engineering.
Leipzig
Katharinenstrasse 15 | 04109 | Germany
Munich
Trimburgstraße 2 | 81249 | Germany
San Francisco
2261 Market Street #4788 | CA 94114 | USA
Follow Us on Social Media
Our mission is to enable businesses to leverage the full potential of their data by providing a single source of truth platform to connect and manage all data.