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

    Pandemic tests electronic records management

    Between the rush enable more virtual collaboration, stalled digitization of archived records and managing records that reside in datasets, records management executives are sorting through new challenges.

  • boy learning at home (Travelpixs/

    Tucson’s community wireless bridges the digital divide

    The city built cell sites at government-owned facilities such as fire departments and libraries that were already connected to Tucson’s existing fiber backbone.

Stay Connected