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.


  • Records management: Look beyond the NARA mandates

    Records management is about to get harder

    New collaboration technologies ramped up in the wake of the pandemic have introduced some new challenges.

  • puzzled employee (fizkes/

    Phish Scale: Weighing the threat from email scammers

    The National Institute of Standards and Technology’s Phish Scale quantifies characteristics of phishing emails that are likely to trick users.

Stay Connected

Sign up for our newsletter.

I agree to this site's Privacy Policy.