# CData Virtuality Reviews **Vendor:** CData **Category:** [On-Premise Data Integration Software](https://www.g2.com/categories/on-premise-data-integration) **Average Rating:** 4.7/5.0 **Total Reviews:** 20 ## About CData Virtuality CData Virtuality - Data Virtualization for Flexible Data Architectures By uniquely combining data virtualization and physical data replication, CData Virtuality provides data teams the flexibility to always choose the right method for the specific requirement. It is an enabler for Data Fabric and Data Mesh by providing the self-service capabilities and data governance features that are indispensable for these frameworks. Enterprises around the world, such as BSH, PGGM, PartnerRe or Crédit Agricole use CData Virtuality to build modern data architectures that meet today’s and tomorrow’s business requirements. Imprint: https://www.cdata.com/company/legal/impressum/ Privacy notice: https://www.cdata.com/company/legal/privacy/ ## CData Virtuality Reviews ### 1. Great ETL tool **Rating:** 4.5/5.0 stars **Reviewed by:** Pierre B. | Small-Business (50 or fewer emp.) **Reviewed Date:** April 10, 2024 **What do you like best about CData Virtuality?** We've been using Data Virtuality for more than 4 years to collect data from Salesforce into our datalake: setup has been easy, the service level was good, and the support team was up and ready to help when we happened to have some incidents on the pipeline. Also, the tool is very cost-effective in comparison to other ETL tools (Fivetran, Stitch, etc), which was one of the main reasons for us chosing it at the time. I warmly recommend this tool for any data team wishing to collect 3rd party data at a competitive price. **What do you dislike about CData Virtuality?** I did not see any real downside with this tool **What problems is CData Virtuality solving and how is that benefiting you?** Replication of Salesforce data in our datalake. Helped us build sales efficiency dashboars in Tableau to improve the performance of our Sales team. ### 2. Powerful Business Intelligence Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Stefan Z. | Data Warehouse Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** November 28, 2023 **What do you like best about CData Virtuality?** Data Virtuality is a powerful tool which easily integrates a wide range of different data sources. Every data source then can be accessed with SQL. It also has a powerful job scheduler and with its ability to write procedural SQL you can write complex ETL pipelines in a very short time. As a virtualization middleware it also allows real time access to data sources and cross data source joins to get ad-hoc insights. **What do you dislike about CData Virtuality?** More information about what happens "inside" the software would be great, especially when encountering a bug or unexpected behavior. But the customer support is always available for help, they have a very fast response time and provide solutions or short time workarounds if needed. **What problems is CData Virtuality solving and how is that benefiting you?** Data Virtuality helped us to integrate and consolidate a large number of data sources, internal and external ones. We were able to create a single point of truth for all data in our organization. It made data-driven business decisions very easy. ### 3. Easy and comfortable to use **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** March 27, 2024 **What do you like best about CData Virtuality?** We used data virtuality pipes. I liked that the setup is straight forward and that even in case of a problem, we always knew quickly what was wrong. Customer Support was also helpful in resolving issues quickly. **What do you dislike about CData Virtuality?** Nothing comes to mind. We did also use competitors for some edge cases, but if possible I would have used pipes for everything because of the better price. **What problems is CData Virtuality solving and how is that benefiting you?** We use it for data ingestion to tableau ### 4. - A powerful data virtualization & ETL tool **Rating:** 5.0/5.0 stars **Reviewed by:** Alex B. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 28, 2023 **What do you like best about CData Virtuality?** Enables real-time data access from any source. It essentially allows us to treat any connected sources as a SQL database Provides various caching capabilities and gives control over the methods of performance optimizations such as distributed query optimization, in-memory caching, and materialization in a 3rd party database I am using procedural SQL to automate workflows and it works well **What do you dislike about CData Virtuality?** Onboarding materials and best practices are rather scarce. Good skills using SQL and ideally knowing how databases work are required to be productive right out of the box **What problems is CData Virtuality solving and how is that benefiting you?** - Data Virtuality is the main data integration tool that we’re using for accessing our customer's data to run services on top of it, internally for self-service analysis, and providing datasets from various sources to internal stakeholders. It also supports our data integration and ETL/ELT processes, offering real-time data access when needed. ### 5. - The single source of data truth powering our BI & data science offering **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Mid-Market (51-1000 emp.) **Reviewed Date:** May 18, 2023 **What do you like best about CData Virtuality?** - The extensive library of connectors. The Data Virtuality team also develops them on request which we need occasionally for new clients - The powerful SQL engine. It lets us completely customize every aspect of the data flow from the sources to a variety of data tools - Data Virtuality allows us to move and migrate data as well which we need for certain APIs where live-querying data would run into API limits **What do you dislike about CData Virtuality?** Administrating the server can be somewhat complex, leading to the need for running scripts as opposed to using the GUI. **What problems is CData Virtuality solving and how is that benefiting you?** - We've found Data Virtuality to be an essential data integration tool for the BI and data science services we offer to our clients. Its compatibility with databases, APIs, and files has allowed us to work effectively with our clients data. - One notable aspect of Data Virtuality is the SQL editor, which has been particularly useful for data discovery and data modeling. This editor allows our team to create custom queries, streamline data transformation and manipulation processes, and derive insights from multiple data sources. As a result, we have been able to offer much more personalized and high-quality BI and data science services to our clients. ### 6. Excellent Amazon Functionality **Rating:** 5.0/5.0 stars **Reviewed by:** Jeff K. | CEO, Small-Business (50 or fewer emp.) **Reviewed Date:** March 22, 2022 **What do you like best about CData Virtuality?** The pipes are preconfigured with all the available data sources. **What do you dislike about CData Virtuality?** You need to know the data dictionaries to understand all the sources. **Recommendations to others considering CData Virtuality:** If you are looking for Amazon API access for Seller API and Advertising API there is no better solution. **What problems is CData Virtuality solving and how is that benefiting you?** API integration out of the box with no coding required. We were able to deliver business value to our clients with little to no overhead costs. ### 7. DataVirtuality Pipes automates your ETL with excellent support **Rating:** 4.0/5.0 stars **Reviewed by:** Nick S. | Mid-Market (51-1000 emp.) **Reviewed Date:** August 04, 2020 **What do you like best about CData Virtuality?** We used DataVirtuality for Salesforce and Jira data and were able to customize absolutely everything we needed to. Support was really excellent -- friendly and quick! **What do you dislike about CData Virtuality?** The Pipes Web UI was not very intuitive and sometimes totally inaccurate. Custom pipe definitions were tricky to get right and lacked version control. **What problems is CData Virtuality solving and how is that benefiting you?** Data transport (extract and load into a Redshift DWH) for Salesforce and Jira. DataVirtuality Pipes enabled us to get up and running very quickly without having to maintain our own infrastructure. ### 8. Fast and flexible Data Virtualization solution **Rating:** 5.0/5.0 stars **Reviewed by:** Frank N. | Director of Data Management, Mid-Market (51-1000 emp.) **Reviewed Date:** September 26, 2019 **What do you like best about CData Virtuality?** Data Virtuality has made the data management team so much more efficient and effective. It allows us to access different data sources, draw the data out and analyze it. The two main benefits for us are (1) the short time it takes to connect to our data sources and (2) the flexibility the virtual SQL layer provides to comply with the specific data needs of our end users. **What do you dislike about CData Virtuality?** Data Virtuality lets users see things they don't have access to when using a tool like DBeaver; this is on the roadmap to be changed so users only see what they have access to. **Recommendations to others considering CData Virtuality:** For those organizations who are trying to figure out how to get quicker with their data delivery, I advise you to look at data virtualization as a whole, but more specifically at Data Virtuality. It is ease to use, has all capabilities to manage data efficiently and provide it quickly to analysts, it’s very robust and has a great connector support. **What problems is CData Virtuality solving and how is that benefiting you?** We use Data Virtuality as our single source of data truth where we unite data coming in from different data sources in varying formats. We manage our data in Data Virtuality and enable our end users to use it as the single point to draw data from for their reporting and data science tasks. ### 9. Data replication made easy **Rating:** 4.5/5.0 stars **Reviewed by:** Supreeth M. | Senior BI Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** June 04, 2019 **What do you like best about CData Virtuality?** We were looking for an ETL tool which is cheap and didn't require extensive programming language. After searching in the marketplace that fits our need, Pipes was the only one that was affordable yet gave us the use of integrated SQL editor with which ETL can be easily done. **What do you dislike about CData Virtuality?** The price could be more flexible and adapt more to the current use case. **What problems is CData Virtuality solving and how is that benefiting you?** The most important use case for us is that we are building a data warehouse on dimension modelling techniques. Our production database is not at all suited for analytics (since it is optimised for operational purposes). We want to do an ETL process from our production database into a schema defined by our BI team so that we can read and aggregate data more easily ### 10. Simplifies data transfer to our data warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Taylor H. | Director, Information Services, Government Relations, Mid-Market (51-1000 emp.) **Reviewed Date:** May 28, 2019 **What do you like best about CData Virtuality?** Pipes has a very intuitive setup and is easy to use. The pre-developed data templates are also very helpful. The SQL editor to transform data and schemas seems very useful as well. **What do you dislike about CData Virtuality?** No real downside. It took a couple weeks to get the Stripe integration functioning entirely as we would like it to. On the upside, the Support and Development teams were AMAZING in getting every little issue and behavior dialed in. **Recommendations to others considering CData Virtuality:** Do a trial of the product and leverage the Support chat option for any issues and questions. Their support is wonderful to deal with! **What problems is CData Virtuality solving and how is that benefiting you?** Pipes automatically retrieves and loads stripe data into our DWH on schedule. This enables us to monitor incoming payments. We avoid a lot of manual effort with reconciling payments and accounts. ## CData Virtuality Discussions - [What is Data Virtuality used for?](https://www.g2.com/discussions/what-is-data-virtuality-used-for) - [View CData Virtuality pricing details and edition comparison](https://www.g2.com/products/cdata-virtuality/reviews/cdata-virtuality-review-1300894?section=pricing&secure%5Bexpires_at%5D=2026-05-21+10%3A34%3A14+-0500&secure%5Bsession_id%5D=82ae1e51-d261-4c5f-bb31-cd47b159dc11&secure%5Btoken%5D=73db965e7cf70210140f602d151668d78bdf2f6af6f94726ec4425f77f11f40d&format=llm_user) ## CData Virtuality Features **Administration** - Database Management - Access Control - Data Security **Management** - Reporting - Auditing **Data Sourcing** - Data Enrichment - Expandability - Multiple Devices **Management** - Real-Time Analytics - Solution Integration - Infrastructure Compatibility - Monitoring **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Management** - Disaster Recovery - Remote Backup - Storage Formats - Scheduled Backups - On-Demand Restoration **Federation** - Architecture - Provisioning - Orchestration - API / Integrations **Functionality** - Extraction - Transformation - Loading - Automation - Scalability **Intelligence** - Predictive Modeling - Recommendation Engine **Solution Provision** - System Failover - Pay by Usage - Service Provision **Integration** - BI Tool Integration - Data lake Integration **Reporting** - Activity Monitoring - Documentation - Alerts/Notifications **Transformation** - Data Visualization - Application Performance - Data Modeling **Deployment** - On-Premise - Cloud **Security** - Data Encryption - Security and Compliance - Deduplication **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization ## Top CData Virtuality Alternatives - [Denodo](https://www.g2.com/products/denodo/reviews) - 4.3/5.0 (39 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (688 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,157 reviews)