Data Virtualization/Federation Platform
August 17, 2018

Data Virtualization/Federation Platform

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with TIBCO Data Virtualization

It is used within several departments and supports several use cases. It's also used asa real-time federated query engine. Another operation - periodically refreshed cache, primarily database-based cache. It is also used for prototyping in ETL projects. It is also used for provisioning of data from systems of record, systems of origin and other authorized data sources to downstream applications and data marts.
  • Scales out horizontally and vertically to support federated queries against growing data volumes
  • Integrates well with BI/Reporting technologies like Tableau and MicroStrategy
  • Supports a wide range of data sources, including relational, no-SQL, message queues/streaming, and big data
  • No very robust metadata and data lineage support
  • Poor integration with data modeling tools, for forward- and reverse-engineering
  • Response times are not always consistent and adequate in real-time queries
  • Great speed to market
  • Developer productivity
  • No need to deal with DB/DW creation and mainteance
TIBCO/Composite Data Virtualization tool competes against Denodo and Red Hat data virtualization tools. While they have comparable features. The TIBCO product is stronger as far as performance and scalability. Denodo was superior when it comes to metadata capabilities, as well forward-engineering and reverse-engineering using data modeling tools such as ERwin or Sybase PowerDesigner.

It is well suited in cases when there are many upstream heterogeneous sources, and the data sets are persisted in periodically refreshed cache, preferably database-based cache (although file-system or in-memory cache are options as well).

It is less appropriate for time-series analysis because the history is limited to the amount of history in he underlying source data repositories.