“Integration of data is quick, strong, and centralized.”
Use Cases and Deployment Scope
We use Data Virtuality, a fantastic concept that simplifies
mapping data structures to relational tables. It's brilliant to use a few lines
of SQL to connect to SFTP Server, query new JSON files, convert them to XML,
and map all acquired data to the relational model for the warehouse. About 20
lines of clean, well-structured SQL code are needed. There are pipes in place
for each potential data source. Pipes was the only option we found that met our
requirements, as it was both reasonably priced and included an integrated SQL
editor, making ETL a breeze. I like data replication and stored procedures
language (more than T-SQL)—customer support is excellent. If there's a bug,
they fix it quickly and send us the patch. Thus, I have a fair opinion of the
Data Virtuality Platform.
Pros
- ETL/ELT model building is flexible.
- The pipes' setup and use are intuitive.
- It lets us access various data sources, extract, and analyze data.
Cons
- Configuring data connectors can be tricky.
- Price could be more flexible and adapt to the use case.
- The ETL builder's user interface could be prettier.
Most Important Features
- Data accessibility.
- Rapid prototypes of BI.
- Centralized business logic data.
- Stored procedure data flow automation.
Return on Investment
- It has the capability of integrating data from a variety of different sources.
- It improved development and user interface to offer a robust MDM repository and strategy.
- It offers a comprehensive solution for processing and retrieving data, which is one of the ways it assists.
Alternatives Considered
Qlik Replicate
Other Software Used
Denodo, SAP HANA Cloud, Tableau Desktop, Adobe Illustrator CC, Keap