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.

inside gcn

  • Phishing

    Phishing is still a big problem, but users can help shrink it

Reader Comments

Please post your comments here. Comments are moderated, so they may not appear immediately after submitting. We will not post comments that we consider abusive or off-topic.

Please type the letters/numbers you see above

More from 1105 Public Sector Media Group