Showing posts with label ETL. Show all posts
Showing posts with label ETL. Show all posts

Saturday, September 3, 2011

Queplix Offers Best Practices for Data Integration by Author: Michael Zuckerman, CMO, Queplix


The explosion in information technologytools and capability has accelerated. Our information technology environment is moving at absolute light-speed. Yet, the back of data integration is broken. 90% of customers are using 20-year old ETL technology designed to move batch files into the data warehouse at 1:00 am. It is a manual process. Worst of all, is that some vendors have even put this 20-year old technology in their newly minted 1-year old cloud. Who wants 20-year old technology in a 1-year old cloud?

To add insult to injury, data quality is … “another product.” I humbly submit that without resolving data quality issues and providing for their ongoing maintenance, you cannot integrate even two applications, load your data warehouse, consider a future Virtual MDM deployment.

The cause of this is simple. Look at the revenue mix for the two major vendors that control the market for large enterprise. Their business is about professional services – not software tools. They are in business to sell you, their customer, as much professional services at the highest rates you can imagine. Legacy ETL technology is a bonanza to a company that sells your company services by the hour.
Even worse, they don’t offer you the right mix of services and technology. The integration was done to specification but it doesn’t seem to work. I guess we’ll just have to sell you additional consulting to do the data quality clean-up.

The five best practices in data integration break this model. Queplix turns the model upside down. By using advanced data virtualization, and pushing back at the legacy monopoly attached to your wallet, you can reduce your costs and speed your time to implementation.

To learn more, visit http://bit.ly/oroH0f and download the "Five Best Practices for Data Integration" white paper. Go here http://bit.ly/oD7xA2 to see the video.

For parties interested in Queplix, data integration, data management, data virtualization, data integration software, master data management, businessintelligence, ETL, informatica, IBM cast iron

Tuesday, June 28, 2011

Technology Evaluation Finds Quecloud™ Data Integration And Data Management Cloud To Be Innovative And Well-Suited To Solve Complex Data Integration Challenges

Report Praises Queplix for Innovative Approach to Connecting, Moving, and Harmonizing Data Across Enterprises with High Degree of Automation and Simplicity

In contrast, "Batch oriented bulk data movement ... best served by the traditional ETL model" offered by companies such as Informatica.

SUNNYVALE, Calif., June 28, 2011 – Queplix™ Corp., a leader in data integration and data management, today announced the availability of a report on data integration solutions by IdealNet, a provider of professional business expertise and technical services to some of the world's largest pharmaceutical, medical device, health insurance and financial services companies. The report, An Analysis of Data Integration Technologies, summarizes the findings of an evaluation comparing ETL and open source solutions, and offers recommendations as to which technologies would be most appropriate based on an organization's data integration requirements.

IdealNet has managed numerous data integration software selection projects, including Master Data Management (MDM), on behalf of multiple customers. In order to ensure "current and comprehensive" results for its clients, IdealNet, Inc. expanded the number of possible solutions to be examined during these selection projects, and was "pleasantly surprised at the variety of new and different approaches which have emerged that improve on the ubiquitous ETL model. 
The report evaluates product offerings across 59 areas within 11 specific categories, which represent the most common and most difficult segments of data integration challenges faced by companies today:

·       Business Application
·       Platform Deployment
·       Connectivity to Data Sources
·       Synchronization
·       Transformation
·       Data Movement
·       Test, Development and Operations Environments
·       Data Modeling
·       Data Quality and Data Governance
·       Architecture
·       Standards

Findings and Recommendations: Queplix the Greatest Surprise of All
The report suggests that data integration and movement between two discrete sources can be well served, perhaps with differing costs and implementation models, by all technologies reviewed. Batch oriented bulk data movement is an area which continues to be best served by the traditional ETL model.

However, the report asserts that once an organization needs to integrate disparate data types (relational, object, on-premise, cloud, nosql) or more than two sources, there are compelling incentives for the use of technology other than ETL, and that "this is where the divergence occurs and where the most telling and interesting results reside."

The following summarizes IdealNet's evaluation between established ETL vendor Informatica®, open source platforms offered by Talend™, Pentaho™, and Apatar™, and "new and different solution vendor" Queplix™.

·       Large, Established ETL Vendor: According to IdealNet, Informatica® was selected to represent the ETL segment, as it has long been a standard bearer for ETL and, more recently, has expanded its footprint further into the niche MDM area via its acquisition of Siperian®. "As the gorilla of the bunch, this offering suffers from similar issues as compared to any vendor its age, scope, and size. The firm must continue to support a large user base on varying levels of its technology, while attempting to continue to move its products forward simultaneously. While this situation encapsulates recurring revenue streams via long term customer relationships, it can also easily serve to mute the possibility of significant innovation. Based on our examination, we can see that the Informatica® suite of products continues to lead in core ETL specialty areas, but does, in fact lag behind the others within this study in terms of certain key areas of differentiation."

·       New and Different Solution Vendor: The report states that, "Queplix undoubtedly provided the greatest surprise of all" and that "the firm has demonstrated a truly refreshing and innovative approach to connecting, moving, and harmonizing data across enterprises. The high degree of automation and the attendant ease-of-use can potentially offer users significant labor and implementation savings over the use of alternate technologies, perhaps on the order of 50 percent or more. If the integration were to involve 3, 4, 5 or more sources, the savings would potentially be much higher. We were impressed with the fact that the technology base of Queplix has so effectively been structured so as to allow the company to rapidly and effectively expand the scope of what can be done with the product. Even some of the most complex and onerous data tasks are handily placed directly under the control of end users via the product’s 'virtual' architecture coupled with a clean and predictable user interface."

"As a partner of industry-leading life sciences and financial services organizations, IdealNet, Inc. is entrusted with having the best knowledge of available technologies to meet its clients' data integration and data management requirements," said Mark Cashman, CEO, Queplix. " IdealNet is certainly well-positioned to make informed, intelligent purchasing recommendations to its clients to ensure their satisfaction and success. We couldn't be more pleased that it found Queplix to be a solution of choice for companies with more complex data integration challenges looking to spend their project dollars more wisely, and avoid long service engagements, manual processes, and the constant wholesale movement of entire data sets."

About the Author
Christopher C. Biddle, CEO of IdealNet, Inc., has delivered expert business and technical services to the life sciences and finance industries for 20 years, and established two corporations to provide key solutions to clients in the areas of revenue management, finance, and sales force automation. He has provided consulting services to C-level executives at companies such as Deutsche Bank, Bankers Trust New York Corporation, Société Générale, Pfizer, Merck, Johnson & Johnson, Novartis, Sanofi, AstraZeneca, TEVA, Wyeth, and GlaxoSmithKline. In addition, he has held partner and vice president positions with Computer Sciences Corporation (NYSE: CSC), Global Healthcare Exchange (GHX), and iMany, Inc. Biddle has authored numerous papers, articles, and book chapters on business and been invited to speak at select industry conferences including those sponsored by CBI and IIR.

To download the full report, visit:
http://www.idealnetinc.com/IdealNet_Analysis_of_Data_Integration_Technologies.pdf
Tweet This: Technology Evaluation Finds Queplix Quecloud Well-Suited to Solve Complex Data Integration Challenges - http://bit.ly/m4SL8e

Follow Queplix on Twitter at: http://www.twitter.com/QueplixCorp

Resource library: For more information about data virtualization and application integration, visit the Queplix Resource Library.
Instant Video Link:  Data Virtualization Basics
About Queplix Corp.
Queplix™ is a leader in data integration and data management. Our products enable customers to securely integrate, deploy and manage cloud and on-premise applications and data with speed, simplicity and automation. Uniquely, no programming or SQL is required. Our data virtualization and powerful data management automatically harmonize the data between applications. Our customers benefit from greater cost savings, a rapid return on investment and the strategic benefits of true data mobility. Queplix has thousands of users around the world, serving customers such as The Home Depot, Homesite and Sony Ericsson. Please visit http://www.queplix.com for more information.

# # #

Queplix, Quecloud and the Queplix logo are trademarks of Queplix Corp. All other brands, products, or service names are or may be trademarks or service marks of their respective owners.

For parties interested in Queplix, data integration, data management, data virtualization, data integration software, master data management, business intelligence, ETL, informatica