| |
USA:European retail clothing giant Grupo Cortefiel
employees Sunopsis data integration tool |
|
2004-12-28
|
|
 |
Europe''s leading fashion clothes retailers Grupo Cortefiel, has successfully implemented a data integration tool from Sunopsis as part of its business intelligence solution.
As a global company operating in the fast-paced retail sector, Grupo Cortefiel required a business intelligence tool that provides real-time information to drive the business. Upon evaluating various solutions, the company found the standard business intelligence models did not address the company''s unique business requirements.
With over 3 terabytes of data in the company''s data warehouse, it was important to find a data integration solution that could manage the massive data volumes and complex architecture of the fashion intelligence model. Grupo Cortefiel opted for the Teradata database to support its data warehouses, due to its scalability and performance. Combined with MicroStrategy software for the analysis and reporting front-end, the company had an end-to-end real-time business intelligence solution.
Jose Francisco Calero, Development Manager at Grupo Cortefiel comments: "The biggest technical challenge was to identify an ETL tool with the scalability to load the Teradata platform. The fact that Sunopsis first loads the data on Teradata and then executes the transformations in bulk mode helps us leverage the power of the Teradata engine. This type of solution provides an excellent cost/performance ratio."
While traditional ELT tools operate with proprietary engines, Sunopsis generates native SQL for each database engine involved in the process, including all sources and targets.
Another factor that drove Grupo Cortefiel to choose Sunopsis is the built-in Message Oriented Middleware Sunopsis MQ. "In a second phase of our Fashion Intelligence project, we envision a need for certain data to be loaded in real-time to the Data Warehouse." Jose Francisco Calero explains. "Sunopsis MQ gives us the flexibility to expand this solution, without having to redesign our data flows."
Sunopsis is currently the only data integration vendor to combine a Message Oriented Middleware with powerful data transformation features and changed data capture on sources.
Grupo Cotrefiel identified Sunopsis as the best technical solution, but prior to investing in the technology sought input from leading system integrator, Accenture it would fulfill the company''s business requirements. Julio Garcia Florez, director of information technologies at Grupo Cortefiel, explains: "We have benefited from first class support and training from Sunopsis'' distributor for Spain, Etica Software, which has reinforced our decision to choose Sunopsis."
Data is extracted from production applications running on IBM AS/400 (iSeries) and AIX servers, running respectively DB2/400 and DB2 UDB, as well as Windows systems running Microsoft SQL Server. Sunopsis connects natively to all these heterogeneous systems, as well as the Teradata Data Warehouse.
In parallel to the project, Grupo Cortefiel operates Hyperion Financial Planning Applications in their Finance Departments. "Sunopsis also provides connectivity to Hyperion Essbase, which is a very interesting proposition for Grupo Cortefiel," explains Julio Garcia Florez. "It means that we can standardise around one single data integration solution for the entire group, and that Sunopsis will even increase its already-high return on investment."
Another benefit of Sunopsis is its impressive project reporting and documentation capabilities. "Sunopsis is a fantastic tool to document data integration projects," explains Jose Francisco Calero. "Our user teams use the Sunopsis Web-based metadata access to understand the lineage of data, how transformations are defined, etc. And with always-increasing regulatory requirements such as Basel II and Sarbanes Oxley, Sunopsis gives us the peace of mind that our financial data is completely traceable."
"The ease of use of Sunopsis, its extensive capabilities that go well beyond ETL and broad connectivity have made of Sunopsis our choice for all data integration processes at Grupo Cortefiel," concludes Julio Garcia Florez. |
|
|
|
|
|
浙公網安33010602010414
