DataVirtuality Logical Data Warehouse
The smartest way to integrate data
The DataVirtuality advantage
Agile data integration for data champions
According to Gartner the majority of data warehouse projects fail. Current data integration approaches using classical Extract-Transform-Load (ETL) processes fail to deliver results due to their inability to meet modern data infrastructure requirements.
Projects with classical ETL based data integration
project failure rate
6-9 months development cycles
ETL-based data integration is a labour-intense manual process following a strict 4-step procedure: (1) discover (2) conceptualize (3) develop and (4) test, leading to several months of implementation time.
Inflexible to changes
The need to manually develop and adapt connections to data sources strongly limits the speed of which changes to the data infrastructure can be made. The greater the number of interconnected systems, the more complicated and inflexible the data infrastructure is.
The concept of moving large amounts of data in a batch-oriented manner limits the possibilities to refresh data in the data warehouse. At best, the warehoused data is a few hours old stopping any opportunity of live data analysis or task automation.
Projects with DataVirtuality Logical Data Warehouse
project success rate
Complete set up in 1 day
With more than 100 connectors DataVirtuality enables users to access data from any database, API, analytical database and BI tool in minutes. All data instantly appear in one virtual layer accessible with any BI tool.
Agile data infrastructure
When new requirements arise users can integrate new data with DataVirtuality in minutes - without involving developers. We provide one platform to connect, transform, query and join data from mutliple data sources in one language: SQL.
DataVirtuality unifies all connected data in one virtual layer enabling live-data access and in-memory processing of queries for real-time reporting and data triggered task automation. Data can be moved with one click making it available with the highest performance to hundreds of users.
DataVirtuality Logical Data Warehouse marries two distinct technologies to create an entirely new manner of integrating data. Combining data virtualization and next generation ETL enables for the first time in history an agile data infrastructures with high performance.
Connect all your data sources, analytical databases and Business Intelligence tools. Manage the flow of your data across all systems using SQL.
DataVirtuality is a java-based software solution that connects to your data sources, analytical databases and Business Intelligence tools managing the flow of data between the systems. DataVirtuality Server can be deployed on-premise and in the cloud.
Integrate data from more than 100 data sources. Connect to JDBC, ODBC, RestAPI, SOAP, XML, JSON and CSV. DataVirtuality’s virtualization engine enables to query and join live-data in SQL from any connected data source.
Use any analytical database to speed up your queries by extracting data from DataVirtuality’s virtual layer. Using next generation ETL, DataVirtuality builts fully automated ETL tracks to load data into your analytical database.
Connect your favorite Business Intelligence tools to DataVirtuality using JDBC or ODBC. DataVirtuality acts as a database for your Business Intelligence tools providing a unified data layer of all connected data sources.
Matthias Korn (Head of Solution Engineering @DataVirtuality) explaining DataVirtuality's next generation data warehouse architecture.
Select from over more than 150 connectors. Access your data in 5min.
Quickly connect to your databases and API’s using DataVirtuality connectors. Simply fill out the parameters in the wizard and access the data on the connected data source in only 5 minutes.
DataVirtuality transforms connected databases and API’s to SQL tables. Join and query all data from connected data source using SQL.
Matthias Korn (Head of Solution Engineering @DataVirtuality) explaining how to connect to data sources using DataVirtuality.
Retrieve live-data from your analytics tools. DataVirtuality enables you to query data from multiple analytics tools to build your reports in Business Intelligence tools like Tableau or Looker.
Connect to Business Objects through an easy to use wizard in 5 minutes. Instantly see all definitions of tables. Join and query live-data with other connected data sources. Use your favorite Business Intelligence tools like Tableau or Looker to query data from Business Objects through DataVirtuality.
Connect to R through an easy to use wizard in 5 minutes. R can be connected DataVirtuality as a front-end and/or data source. Supported procedures include assign and eval.
Connect to Splunk through an easy to use wizard in 5 minutes. Instantly access all views created in Splunk. Query and join data from Splunk with any other data within your organization.
Connect to SAS with a few clicks in 5 minutes. Instantly see all definitions of tables. Join and query live-data with other connected data sources. Use your favorite Business Intelligence tools like Tableau or Looker to query data from SAS through DataVirtuality.
Build an agile and scalable data infrastructure using DataVirtuality's powerful features.
DataVirtuality puts one virtual layer around connected data sources enabling users to query real-time data. Perform joins across multiple data sources on the fly.
With the ability to write to connected data sources DataVirtuality Server enables you to trigger actions based on data.
Access data and schedule updates from any web service using DataVirtuality’s CSV or XML/JSON query builder. DataVirtuality automatically applies a relational structure and enables you to modify the output format with a few clicks. Easily add data from web services to your data model by creating views.
Set rules for automated decision making and execute them. Automate any SQL statement and call external tools to interact with your data.
Use and analyze historical data.
Get data from binary logs without affecting the transactional performance of your databases. Synchronize this data to your analytical database.
Create a company-wide logical data model. Based on virtual views all data can be instantly modeled and the data model flexibly adapted to changing business needs.
Set up flexible schedules and choose from a variety of scheduling options: (1) intervals down to 1 minute and (2) dependent schedules on other jobs. Gain full control with DataVirtuality’s transparent documentation of all schedules and jobs.
DataVirtuality has a sophisticated user management system consisting of role based permissions. Assign certain permissions to roles and add them to users. Track actions by users in the audit log. Import existing permission rules from Active Directory and LDAP.
What our customers say
Being able to work productively right away is a big advantage for us compared to the usual month-long implementation times of traditional data warehouse projects.
Head of BI, Finance and HR
Before DataVirtuality we had to go into each of our databases, pull the data and stick it somehow with Excel together. Now we can access data at all times, set up reports in DataVirtuality, schedule data import jobs and make the reports available to everyone who needs it.
Senior Business Intelligence Manager
We can make considerably better use of our data systems. The transparency of information is significantly higher. Decision making is no longer based on intuition, but driven by data and is, therefore, well-founded.
Head of eCommerce