Why Assessment Is Necessary?

One of the most common problem statements during migration to the cloud is where to start with? Many CTOs tried solving this problem by engaging with their own company-wide Subject Matter Experts. However, this approach solves the above problem in isolation without having a larger view.

The second problem that is generally faced is what all objects to migrate. I remember one of our clients had 10K+ tables and views in the database and they had very little information on how many are really required for migration. It was clear that many tables were created temporarily and with no specific name convention and that added to the problem of identification of objects to be migrated. To some extent the DBAs can help, but in my experience, this generally solves only 15 to 20% of the overall problem.

The third problem is what should be the order of objects for migration? How would an exercise of such a large extent be foolproof to cater to different Business Unit in every iteration and bring true value to the Organization in terms of entirety and surety. An Organization would love to migrate objects in an iterative method instead of the Big Bang approach.

Eagle, The Planner an innovative product of Datametica, solves the above problems very precisely.The product scans through logs for the past N-days and hashes out relationships between different objects in the database. It identifies the access patterns on objects. It is a two fold solution.

First, it intelligently builds lineage (pipeline) of objects and graphically displays it. These visuals aids to find complexity in terms of joins and data hops. These visual representation of ELT and ETL processing clears out the problematic areas and measures the overall efforts required for migration.

Secondly, Eagle also groups these objects (called clusters) into sizable migration iterations, thus outputting a precise plan. The size of each cluster is configured and fits into a typical Sprint. The output plan has keys and handles to re-prioritize the Sprints depending on what the customer would require.

Eagle, the Planner, this way accelerates the migration activity and cuts down the overall cost and time by nearly 50%. It helps organizations to invest the time and effort in the right way to plan for the migration.

Supported Technologies Datametica offers a wide range of technologies in support for migrating from Teradata, Netezza, Oracle, Datastage and more and more are being added as I am writing this blog. By the end of Q1 2020 support for top 10 data warehouse platforms and associated technologies will be available in Eagle.