Analyzer

Summary

Bleep Bridge Analyzer is a powerful tool that rapidly assesses the complexity of ETL and database code assets, tasks typically taking months to complete. It ingests metadata to generate detailed spreadsheets with tabs for complexity summaries, mapping details, transformation occurrences, and cross-references, aiding impact analysis. The Database Analyzer offers a similar scope, focusing on database code assets, providing insights into the complexity levels, dynamic SQL, function calls, and object references. This tool is invaluable for software vendors and customers to gauge the complexity of their integration and data ecosystems before undertaking large-scale projects, and is available for purchase or as a benefit for partnering SIs and vendors.

Takeaways

• 🛠️ Bleep Bridge Analyzer is a tool designed to summarize and score the complexity of ETL and database code assets.
• ⏱️ It can accomplish tasks that usually take organizations over a month, in just a few hours.
• 🔍 The Analyzer ingests metadata from integration and database landscapes to perform its analysis.
• 📊 It produces a spreadsheet with multiple tabs, providing centralized information about the code assets.
• 📈 The 'Complexity Summary' tab categorizes code objects based on their level of complexity.
• 🗂️ 'Mapping Details' creates an inventory of mappings and their complexity levels.
• 🔄 'Transformations' breaks down the number of transformation occurrences in the integration tool.
• 🔗 'Mapping Transformations Cross Reference' summarizes the relationship between mappings and transformation types.
• 📝 'Mapping Objects Cross Reference' is useful for impact analysis, summarizing the relationship between jobs and database objects or files.
• 📋 'Functions' lists all functions and their occurrences, aiding in identifying frequently used elements.
• 📑 'Subject Areas' typically represents folders in an ETL environment, organizing the code assets.
• 📝 'Sequel Statements' produces an inventory of SQL statements and their lengths for complexity assessment.
• 🔢 'Transformation Expressions' includes an inventory of all formulas for conversion specialists to assess additional complexities.
• 🗂️ 'Database Analyzer' offers a similar analysis scope but is focused on database code assets.
• 🔍 'Dynamic SQL' identifies places in the code where SQL is formed dynamically, as opposed to static SQL statements.
• 📊 'Functions' in the database context provides a count of function calls, indicating usage frequency.
• 🔗 'Objects' and 'Program Object Cross-Reference' tell how many references a particular object has and for what purpose.
• 🔍 'Reference Variables' and 'Program Variable Cross-Reference' are used to understand dependencies between variables and scripts during conversion.
• 🛒 Bleep Bridge Analyzer can be purchased from the Blade Bridge website, and free access is a benefit for partnering SIs or software vendors.

Q & A

What is the primary function of the Bleep Bridge Analyzer?

The Bleep Bridge Analyzer is designed to build a summary of ETL and database code assets, score their complexity, and generate a spreadsheet with multiple tabs that provide central information for various aspects of the integration and database landscape.

How does the Analyzer reduce the time required for complexity analysis?

The Analyzer reduces the time required for complexity analysis by ingesting metadata from the integration and database landscape, which can take organizations over a month to resolve, and completes the task in just a few hours.

What kind of information is provided in the 'Complexity Summary' tab?

The 'Complexity Summary' tab categorizes code objects based on their level of complexity, providing an overview of the complexity levels present in the ETL or database code assets.

What is the purpose of the 'Mapping Details' tab?

The 'Mapping Details' tab creates an inventory of mappings and their complexity levels, which helps in understanding the intricacies of data mappings within the ETL process.

How does the 'Transformations' tab assist in understanding the integration tool?

The 'Transformations' tab breaks down the number of transformation occurrences in the integration tool, offering insights into the frequency and types of transformations used.

What insights does the 'Mapping Transformations Cross Reference' tab provide?

The 'Mapping Transformations Cross Reference' tab summarizes the relationship between mappings and transformation types, which is useful for understanding how different mappings are associated with specific transformations.

What is the significance of the 'Mapping Objects Cross Reference' tab for impact analysis?

The 'Mapping Objects Cross Reference' tab summarizes the relationship between jobs and database objects or files, providing valuable information for conducting impact analysis on changes within the system.

What information does the 'Functions' tab include?

The 'Functions' tab is a list of all functions used in the ETL or database code along with their number of occurrences, helping to identify frequently used functions.

How does the 'Subject Areas' section help in organizing ETL environments?

The 'Subject Areas' section, typically a set of folders in an ETL environment, helps in organizing and categorizing the ETL processes, making it easier to manage and analyze.

What does the 'Sequel Statements' tab provide in terms of database code assets?

The 'Sequel Statements' tab produces an inventory of all SQL statements used in the database code assets along with their respective lengths, aiding in the analysis of SQL code complexity.

How can the 'Dynamic SQL' tab assist in identifying dynamic versus static SQL code?

The 'Dynamic SQL' tab shows places in the code where SQL is formed dynamically, as opposed to static SQL statements, which can be important for understanding the flexibility and complexity of the database code.

What is the benefit of being a partnering SI or software vendor to Blade Bridge in terms of the Analyzer?

Being a partnering SI or software vendor to Blade Bridge provides free access to the Analyzer, which is a significant benefit as it allows these partners to leverage the Analyzer's capabilities without additional cost.