Logical Data Warehouse

RATING:

5.0

(4)
Overview

About Logical Data Warehouse

Data Virtuality is a data integration solution that centralizes data from multiple sources. It can be hosted either in the cloud or on-premise. Key features include pre-built templates for retrieving data, customizable pipelines, incremental data extraction, data transformation and task automation. Data Virtuality synchronizes data model changes between multiple data warehousing instances such as staging, development and production. The solution enables users to create queries for real-time data and trigger actions based on live as well as historical data. Data Virtuality allows users to create configurable schedules for various tasks. Data and schedule updates can be accessed using CSV or XML/JSON query builders. The solution can import permission rules from ...
View sources

Logical Data Warehouse Reviews

Overall Rating

5.0

Ratings Breakdown

Secondary Ratings

Ease-of-use

5

Customer Support

5

Value for money

4

Functionality

5

Most Helpful Reviews for Logical Data Warehouse

4 Reviews

User Profile

Eran

Verified reviewer

Computer Software, 11-50 employees

Used daily for more than 2 years

Review Source: Capterra
This review was submitted organically. No incentive was offered

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

4

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed November 2018

Powerful data hub supporting stored procedures in SQL

Automating data work flows utilizing stored procedures Cutting down time to access data to minutes. Having a central data hub to describe the business logic was really critical for us. Overall, was easy to set up and is now a critical tool in our BI stack for all our analysis

PROS

We have partnered with Data Virtuality since 2016 and use the software as the central data hub in our business intelligence projects. In the first phase of our projects we connect to our clients' data sources. That takes only a couple of minutes and we can immediately proceed to start building dashboards. Its the enabler for ad hoc reporting and rapid prototyping. The strength over other ETL tools are the pre-built connectors which cut down time for data access to minutes - and the virtual data layer. The concept of a virtual data layer that supports sophisticated SQL procedures is a game changer in the industry.

CONS

Time to on-board. We use the software in a way no other ETL tool operates. That required a rethinking.

Anonymous

11-50 employees

Used weekly for less than 12 months

Review Source: Capterra
This review was submitted organically. No incentive was offered

OVERALL RATING:

5

EASE OF USE

5

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed December 2018

Integrating marketing data sources for campaign management and attribution

Overall, we're very happy with it. It is a very sophisticated software that comes with a variety of features that helped us to build our marketing analytics stack and bring our infrastructure to the next level (coming from having tested a couple of dozen data pipeline tools out there)

PROS

The best and unique thing is really that Data Virtuality is fully SQL based which gives us full flexibility when working with our data other marketing integration pipeline tools could not provide us with. First, we connected our marketing partner sources. Data Virtuality has many connectors, so our facebook, linkedin, twitter, google ad, analytics and MySQL database was connected within 1,5h. Once we did this, we had access to the full API and could model and transform the data with SQL. That is really a game changer, because other marketing integration solutions only let us select from templates, where we always ran into limitations when building an attribution model. We have also stored a lot of SQL code that defines how our marketing data flows on Data Virtuality. It's basically the data brain behind our marketing operations.

CONS

Most advantages come with a disadvantage. Here, the price of flexibility comes with the fact that you need to know SQL well.

Anonymous

11-50 employees

Used daily for more than 2 years

Review Source: Capterra
This review was submitted organically. No incentive was offered

OVERALL RATING:

5

EASE OF USE

4

VALUE FOR MONEY

4

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed October 2018

Data Virtuality is the core of our reporting infrastructure feeding Tableau with data for reportings

Reporting for clients: Connecting to several APIs and databases on client side. Mostly Mailchimp, Google Analytics, Web Shop Data (Magento), MS SQL Server and MongoDB. Visualization with Tableau and automatically sending reports via email.

PROS

I am using Data Virtuality for 3 years now. The best about Data Virtuality is that it enables me, a non technical user, to access our client data sources and build reportings in a very short time completely autonomously. Previously, I needed developers to access our client data which took several weeks and did not always work. Support is also helpful.

CONS

The desktop frontend looks a bit dated for me. The web frontend introduced in 2.1 looks very promising for the future.

Anonymous

11-50 employees

Used weekly for less than 12 months

Review Source: Capterra
This review was submitted organically. No incentive was offered

OVERALL RATING:

5

EASE OF USE

5

VALUE FOR MONEY

4

CUSTOMER SUPPORT

5

FUNCTIONALITY

5

Reviewed November 2018

The must-have data infrastructure for my client companies

Data Virtuality is the single source of data truth for Business Intelligence tools at my client companies. I can easily access data sources and build out the business logic. I use data viz tools like Excel, Tableau or Metabase on top of Data Virtuality. Overall, the software enables me to have a complete data infrastructure that I can easily manage - versus taking time from developers away to constantly build out and maintain data pipelines.

PROS

I am consulting with high-growth startups that usually start with a clean sheet when it comes to Business Intelligence, but quickly need to set up an infrastructure for reporting and analytics for marketing, sales and operations. Best about Data Virtuality is the large number of connectors to access data sources. It saves me time on the integration part and let's me focus on working on the logic behind the numbers. Another important part is that I can pull all data, also custom fields for example for Salesforce. I can build out the specific business logic my clients need instead of just using templates for integration.

CONS

Sometimes I get error messages that are not self-explaining for me.