Analyzer is designed to interrogate data platforms to reveal the complexities in their deployment. By leveraging the analyzer, project estimates and plans can be made which are more in line with the actual source system metadata and code. Thus both Customers and Systems Integrators can prepare more accurate forecasts. The Analyzer is is often used during the strategy phase of a conversion project.
Conducting an ETL/ELT migration is no trivial task. Organizations embarking on such a difficult project are like Columbus setting sail for an unknown end game. Analyzer changes all that…
Analyzer interrogates metadata and development code which has accumulated over the years in the Legacy ETL/ELT platform. This interrogation enables Analyzer to produce detailed multi-tabbed reports in Excel that inventory all the artifacts needing to be migrated. Additionally, Analyzer produces a summary of complexity which it breaks down into Low, Medium, Complex, and Very Complex buckets. The categorization for these buckets is well documented so customers and system integrators are aware of why the tallies are broken down the way they are. Additional analysis include:
Many MPP databases and large enterprise deployments have opted to leverage code as their primary mechanism for deploying their data integration and conformity architecture. This is especially the case the larger the deployment becomes, as the desire to natively push data computation to the database becomes a priority. Thus the ability to interrogate the existing legacy SQL code and understand its complexity is critical for successfully forecasting a database migration.
Analyzer has the ability to profile SQL code and surface conversion complexity for refactoring the code to operate on another database platform. In addition to the complexity summary, the analyzer produces a number of useful analyses including:
We had a complex migration we were quoting. This helped us leapfrog our competing bids for migrating Netezza to Snowflake. The other SI bids were almost 10X our cost but their discovery artifacts were far less detailed than what we produced from the Analyzer. Ultimately they decided on us because we made a more compelling case for less money.
Sales Exec of Major SI