Data Migration


Back to List

Overview

A major element of cost for many companies that are implementing new enterprise-wide IT systems such as SAP, is that historical data must be moved from the old system to the new. We can bring our expertise and integration tools to facilitate this move, at substantially lower cost to you.

Scope And Deliverables

SatiStar can quickly and efficiently transform business processes by integrating existing data, applications, and environments with new systems and applications – including all popular ERP, CRM, and SCM application packages; messaging technologies such as MQSeries; application technologies like Java™/J2EE/JCA and XML; and new Internet technologies such as Web Services and .Net.

In the migration of data from one system to another, a data transformation converts data from a source data format into destination data.

Data transformation can be divided into two steps:

  • Data mapping maps data elements from the source to the destination and captures any transformation that must occur.
  • Code generation that creates the actual transformation program.

Data element to data element mapping is frequently complicated by complex transformations that requires one-to-many and many-to-one transformation rules.

In an automated migration activity, the code generation step takes the data element mapping specification and creates an executable program that can be run on a computer system.

What We Will Do

SatiStar provides expert design, systems architecture, implementation, and project management services for all your data integration projects. We will help you:

  • Design and implement your initial data migration.
  • On an on-going basis, distribute information between different applications to ensure accurate and reliable data across the enterprise.
  • Integrate information between mission-critical systems and Web applications so that employees, customers and partners have access to real-time information.
  • Consolidate financial data across systems in different regions, departments, or business units.
  • Improve the operational performance of systems that are adversely affected by shrinking nightly batch windows and expensive query and reporting functions.

What We Need You To Do

  • Provide a list of data sources and targets.
  • Provide us with access to key IT and business resources. (Knowledge workers, DBA’s and data architects.)
  • Provide us with relevant information on your existing IT structure and environment.

Back to list

 

Consulting Overview

Our Services

Performance Breakthrough

Management System Standards

Operational Effectiveness

Leadership and Cultural Transformation

Information Systems

Full Consulting List


WHAT PEOPLE ARE SAYING

SatiStar's Experience Makes The Difference!

  • . . . worked extremely well with the departmental and site managers . . . goal oriented and met the objectives set within the quoted budget and ensured the results were attained for the Company.

  • The guys from SatiStar did more in one week than we were able to do in 6 months.

  • Achieving ISO registration was far less onerous than we thought, our employees really rallied to the cause. The registration effort really brought us closer together as a team, and SatiStar really came through for us when we needed them.

  • We started this process a year ago with Mickey helping us create a spaghetti map of our processes on the whiteboard, and then his team guided us through their streamlining methodology and got us to where we are today. Our processes now look nothing like the spaghetti map – and we’re much more efficient today

  • This projected cycle time reduction of over 80% annual cost savings amounting to over 3% of sales, one-time savings of roughly $10 million, and working capital reduction of roughly $30 million really have us excited!

  • An outstanding success with Motorola’s vendor audit! What made this an exceptional achievement is that it typically takes 4 to 5 attempts to pass this audit. SatiStar’s expertise made it easy to avoid all the extra attempts.