XTIVIA analyzed the requirements and a mutually agreed upon data architecture was defined as follows: The project team chose talend* Open Studio for ETL and data migration. XTIVIA resources quickly put together prototype workflow jobs, to attain common understanding. Each data flow was discussed and best practices principles were applied. The team integrated historical and current data in support of data consistency. Jobs were deployed, including ETL and data synchronization/replication. The team framed benefits and risk reviews for both the executive and technical perspectives. A transition plan was created for business critical processes moving forward, including future recommendations with risk review and follow-up actions, as well as a timeline targeting specific milestones.
XTIVIA delivered smooth and on time migration of legacy data. SCA’s risks were analyzed thoroughly and the best solution options were chosen. The mechanism to implement data synchronization was implemented. Team resources were properly aligned to business objectives. The job was completed at a fraction of the cost typically incurred with high cost ETL tools, as SCA did not have to incur any costs for software. The completed project finished on time and under budget.
Faced with the daunting challenge of deploying a multi-faceted data migration strategy to have the utmost positive impact for their new ERP platform, the client called in XTIVIA to unravel the details, to assess the legacy data and integration issues, and to build a manageable timeline that mapped out the mission critical milestones — all informed by industry best practices. As expert process partners in this endeavor, XTIVIA not only defined the data flow architecture using talend* Open Studio (Community Edition), XTIVIA also built the sub-system required for migration and synchronization of data. Being aware that all plans must be dynamic and responsive, XTIVIA also provided senior resources, as needed, within a very short period of time which lead to a successful conclusion of the project that was delivered on-time and under budget. In addition to this, XTIVIA provided standards and best practices for transformation processing, performance requirements and data quality. Knowing that data is not useful unless it is current, usable,and reportable, XTIVIA partnered with the client on the data migration.
Windows® Server talend* Open Studio (Community Edition)
SQL Server® 2008
Informix® 7.x and 11.x
Two Senior ETL Architects
10 week engagement
Download the Case Study PDF here