Data integration tool lets users pick virtual view

Data integration tool lets users pick virtual view

By Florence Olsen

GCN Staff

The Virtual DB 3.0 data integration tool from Enterworks Inc. supports bulk loading and incremental changes to a data model.

Virtual DB users can build virtual views from any given virtual view, 'reusing transformations and data cleansing, maybe adding more mappings,' said Lenley Hensarling, vice president of marketing at Enterworks in Ashburn, Va.

The software will play a key role in the Government Computer-based Patient Record program under a contract awarded last fall to Litton PRC.

'From very disparate data sources including systems written in M, we were able to prototype a Virtual DB model and have Java applications running on top,' Hensarling said.

The Army chose Virtual DB to integrate data for its Ammunition Materiel Release Order Tracking System.

The service is 'playing the data where it lies, and populating data marts and data warehouses,' he said.

Deep impact

Hensarling said different groups within the Defense Department have built Virtual DB metacatalogs for specific data sources, and other organizations have reused the metacatalogs.

The newest Virtual DB release supports the Common Object Request Broker Architecture, Open Database Connectivity, native Java Database Connectivity and X.509 authentication certificates.

Through the ODBC interface, users can run Microsoft Excel or Access programs against data in mainframe VSAM or IMS systems, Hensarling said.
A Java-based administration tool can connect to any server anywhere to update metacatalogs, load new transformations, assign new users or add users, he said.

Virtual DB 3.0 for Microsoft Windows and Unix starts around $50,000, depending on number of data sources and users.

Contact Enterworks at 703-724-3800.


  • business meeting (Monkey Business Images/

    Civic tech volunteers help states with legacy systems

    As COVID-19 exposed vulnerabilities in state and local government IT systems, the newly formed U.S. Digital Response stepped in to help. Its successes offer insight into existing barriers and the future of the civic tech movement.

  • data analytics (

    More visible data helps drive DOD decision-making

    CDOs in the Defense Department are opening up their data to take advantage of artificial intelligence and machine learning tools that help surface insights and improve decision-making.

Stay Connected