In this chapter, we introduced the virtualization data management approach and established the main differences between ETL and data federation. We installed and set up a clean JBoss data virtualization development environment, and both Server and IDE features to build a custom virtual database step by step.
We explored source model creation from various JDBC connections: Postgres, MySQL, and MongoDB. In order to isolate and prevent our federate layer from source model modifications, we built Virtual Base Layer models, either from scratch or by transforming the existing source model. We set up a union model to combine data from two sources and deploy a virtual database.
At the end, to handle complex data processing, we created a virtual procedure to automatically compute transactions fees. We queried virtual databases with OData Rest and implemented a Teiid JBDC client...