Data Virtuality Server supports querying different data sources by the use of specific connectors. In addition to the JDBC-Sources, SalesForce, AdWords and MongoDb can be queried in particular. With this system stored procedures and system tables (see System Schema) set you can easily create/remove/enumerate connections (i.e. data sources and resource adapters in terms of JBoss) and data sources (i.e. models in terms of Data Virtuality Server), as well as refresh metadata for particular/all data sources or only get metadata differences for particular/all data sources between current Data Virtuality Server state and actual state in the appropriate external data source.

All dynamically created data sources are restored on the start of the Data Virtuality Server, but if a data source can't be restored it is marked in SYSADMIN.DynamicModels system table with failed=true.

When you create a data source you specify no connection name. It means JNDI names of a connection and an appropriate data source should match.

Both getDataSourceMetadataDiff() and getAllDataSourcesMetadataDiff() procedures return a result set. Each line of the set represents a table column (the fields of the set are a subset of SYSTEM.Columns table) with an additional field “action” which contains ‘added’ or ‘dropped’ value depending on added or dropped the column was in the original data source which is represented by the line.