Code Profiling Engine


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.

Sample Use Cases

ETL/ELT Conversion Estimation


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:

  • Mapping Details
  • Transformations
  • Mapping Transformations Xref
  • Mapping Objects Xref
  • Mapping Objects List
  • Functions
  • Subject Areas
  • SQL Statements
  • Transformation Expressions

SQL Code Conversion Estimation


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:

  • SQL Programs
  • Dynamic SQL
  • Functions
  • Referenced Objects
  • Program-Object Xref
  • Raw Program Object Xref
  • Referenced Variables
  • Program Variable Xref
  • Raw Program Variable Xref

Analyzer Pricing

Off Site
2500
Secure AWS S3 upload which our Analyst runs through the Analyzer
  • Upload your ETL/Database Metadata
  • BladeBridge will run the analyzer off-site
  • Lower Cost Option

BladeBridge

Analyzer Off-Site

On Site
5000
On site installation and running of the Analyzer tools
  • Local running of the Analyzer against your ETL/Database Metadata
  • BladeBridge resource engages on-site

BladeBridge

Analyzer On-Site

Custom Connectors
Contact us
 
Build a new connector to your custom database or data integration layer.
  • If you have a custom data type which needs analysis, we can still help. Reach out to us to discuss the specifics.
 

Feedback From Platform Vendors


Our Contacts