What is data virtualization software?

Healthnow has chosen Informatica data virtualization software in numerous products, while its rivals IBM and composite have been "in the process of falling out of business". Company managers revealed that the main reason for choosing Informatica is that it requires less SQL coding and improves the quality of data policies for insurance providers.

Rob Myers, an enterprise data warehousing solution Architect at Healthnow, said: "One of the reasons I don't like IBM and composite is that they're more code-driven." Basically you have to write a lot of SQL, or it will only generate SQL maps, not the kind of conversion engine that Informatica offers you. ”

What is data virtualization software?

Data virtualization technology creates middleware, or services, in which data can be aggregated, viewed, and analyzed from different sources. The technology wants to save time and expense from traditional integration methods, such as ETL and database consolidation, since the actual data has never been physically moved from the source system.

But Myers that Informatica's data services need to be upgraded in some areas. First, he wants to see software become more user-friendly over time. That would make it easier for healthnow business analysts to map the data source and create a simple report based on the information selected from the Virtual Data mart.

Myers also wants Informatica to seamlessly connect to the Enterprise Service Bus (ESB) technology from competitors. ESB Technology is a pillar of a service-oriented architecture that provides a consistent view of services and hides the complexity of underlying applications.

"You have to be able to interact with message queues," Myers said. I know that Informatica is already doing some queue functions, but IBM MQ has a larger share of the ESB sector and other competitors are doing it. I don't think this is the place where Informatica should try to compete. I think it will dilute their work in other areas. ”