Skip to the content
LeaplogicLeaplogic
  • Home
  • About Us
  • Contact
SIGN IN
  • Home
  • About Us
  • Contact

  • Getting Started
    • Before You Begin
    • Creating an Account
    • Logging into LeapLogic
    • Reset Password
    • Quick Tour of the Web Interface
    • LeapLogic in 15 minutes
      • Prerequisites
      • Step 1. Log into LeapLogic
      • Step 2. Create Assessment and Get Insights
      • Step 3. Create Transformation Pipeline and See Results
      • Step 4. Edit or Optimize the Transformed Code
      • Step 5: Complete the Transformation Lifecycle
  • Introduction to LeapLogic
    • Overview
    • High Level Architecture
    • Supported Legacy and Cloud Platforms
    • Key Features
  • LeapLogic Deployment Architecture & Prerequisites
  • Workload Assessment
    • Overview
    • Value Proposition
    • Creating Assessment
      • Prerequisites
      • Step 1. Provide Primary Inputs
        • Automation Coverage
      • Step 2. Add the Additional Inputs
        • Table Stat Extraction Steps
          • Teradata
          • Oracle
          • Netezza
      • Step 3. Update the Source Configuration
      • Step 4. Configure the Recommendation Settings
    • Assessment Listing
    • Understanding Insights and Recommendations
      • Volumetric Info
      • EDW
        • Oracle
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Vertica
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Snowflake
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Azure Synapse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Teradata
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Netezza
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Google Big Query
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Redshift
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • PostgreSQL
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Duck DB
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • ClickHouse
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • Exasol
          • Highlights
          • Analysis
          • Optimization
          • Lineage
          • Recommendations
          • Downloadable Reports
        • DB2
          • Highlights
          • Analysis
          • Optimization
          • Recommendations
          • Lineage
          • Downloadable Reports
      • ETL
        • Informatica
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Ab Initio
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • DataStage
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Talend
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSIS
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Informatica BDM
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Oracle Data Integrator
          • Highlights
          • Analysis
          • Downloadable Reports
        • Pentaho
          • Highlights
          • Analysis
          • Downloadable Reports
        • Azure Data Factory
          • ARM Template
          • Highlights
          • Analysis
          • Downloadable Reports
        • Matillion
          • Highlights
          • Analysis
          • Downloadable Reports
        • SnapLogic
          • Highlights
          • Analysis
          • Downloadable Reports
      • Orchestration
        • AutoSys
          • Highlights
          • Analysis
          • Downloadable Reports
        • Control-M
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SQL Server
          • Highlights
          • Analysis
      • BI
        • OBIEE
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Tableau
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • IBM Cognos
          • Highlights
          • Analysis
          • Downloadable Reports
        • MicroStrategy
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • Power BI
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • SSRS
          • Highlights
          • Analysis
          • Downloadable Reports
        • SAP BO
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
        • WebFOCUS
          • Highlights
          • Analysis
          • Downloadable Reports
      • Analytics
        • SAS
          • Highlight
          • Analysis
          • Lineage
          • Downloadable Reports
        • Alteryx
          • Highlights
          • Analysis
          • Lineage
          • Downloadable Reports
      • Shell
        • Highlights
        • Analysis
        • Lineage
        • Downloadable Reports
      • Integrated Assessment (EDW, ETL, Orchestration, BI)
        • Highlights
        • Analysis
        • Optimization
        • Lineage
        • Recommendations
    • Managing Assessment Reports
      • Downloading Report
      • Input Report Utility
      • View Configuration
    • Complexity Calculation Logic
    • Key Benefits
    • Ad hoc Query
  • Script/ Query Log/ Code Extraction Prerequisites
    • Cloud
      • Azure Data Factory
      • Snowflake
      • Azure Synapse
      • Google BigQuery
      • Redshift
      • Azure SQL Database Hyperscale
      • Aurora PostgreSQL
    • EDW
      • Oracle
      • Netezza
      • Teradata
      • Vertica
      • SQL Server
      • Db2
      • MySQL
      • PostgreSQL
    • ETL
      • DataStage
      • Informatica
      • SSIS
      • Talend
      • ODI
      • IICS
      • DBT
      • Pentaho
      • Matillion
      • SnapLogic
      • Ab Initio
      • SAP BODS
      • TAC
      • WebFOCUS
    • BI
      • IBM Cognos
      • OBIEE
      • Tableau
      • Metabase
      • MicroStrategy
      • PowerBI
      • LeapLogic Utility for SAP BO
      • SAP BO Universe and Web Intelligence
      • SSRS
    • Analytics
      • SAS
      • Alteryx
    • Orchestration
      • AutoSys
      • Control-M
      • SQL Server
    • Mainframe
  • Metadata Management
    • Overview
    • Introduction to Data Catalog
      • Managing Data Catalog
        • Building Data Catalog
        • Insights to Data Catalog
        • Managing the Repository and Data Source
      • Creating Repository (Repo)
      • Creating Data Source
    • Tag Management
    • Key benefits
  • Batch Processing using Pipeline
    • Introduction
    • Designing Pipeline
      • How to create a pipeline
        • Configuring Migration Stage
          • Schema Optimization
        • Configuring Transformation Stage
          • On-premises to Cloud
          • Cloud-to-Cloud
            • Assigning Roles
            • Intelligent Modernization
          • LeapFusion
        • Configuring Validation Stage
          • Data Validation
            • Table
            • File
            • File and Table
            • Cell-by-cell validation
          • Query Validation
            • Query Validation (When Data is Available)
            • Query Validation (When Data is Not Available)
          • Schema Validation
        • Configuring Execution Stage
        • Configuring ETL Conversion Stage
          • Ab Initio
          • Informatica
          • Informatica BDM
          • Matillion
          • DataStage
          • SSIS
          • IICS
          • Talend
          • Oracle Data Integrator
          • Pentaho
          • SnapLogic
        • Configuring Mainframe Conversion Stage
          • Cobol
          • JCL
        • Configuring Orchestration Stage
          • AutoSys
          • Control-M
        • Configuring BI Conversion Stage
          • OBIEE to Power BI
          • OBIEE to AWS QuickSight
          • Tableau to Amazon QuickSight
          • Tableau to Power BI
          • Tableau to Superset
          • Tableau to Looker
          • IBM Cognos to Power BI
        • Configuring Analytics Conversion Stage
          • SAS
          • Alteryx
        • Configuring Script Conversion Stage
    • Key Features
      • How to schedule a pipeline
      • Configuring Parameters
  • Pipeline Reports
    • Overview of Pipeline Report
    • Pipeline Listing
    • Reports and Insights
      • Migration
      • Transformation
        • On-premises to Cloud
        • Cloud-to-Cloud
      • Validation
        • Data
          • File
          • Table
          • File and Table
        • Query
          • Query Validation Report (When Data is Available)
          • Query Validation Report (When Data is not Available)
        • Schema
      • Execution
      • ETL
        • Ab Initio
        • Informatica
        • Informatica BDM
        • Matillion
        • DataStage
        • SSIS
        • IICS
        • Talend
        • Oracle Data Integrator
        • Pentaho
        • SnapLogic
      • Mainframe
        • Cobol
        • JCL
      • Orchestration
        • AutoSys
        • Control-M
      • BI
        • OBIEE to Power BI
        • OBIEE to Amazon QuickSight
        • Tableau to Amazon QuickSight
        • Tableau to Power BI
        • Tableau to Superset
        • Tableau to Looker
        • IBM Cognos to Power BI
      • Analytics
        • SAS
        • Alteryx
      • Shell Script
      • Common Model
    • Automation Level Indicator
      • ETL
        • Informatica
        • Matillion
        • DataStage
        • Informatica BDM
        • SnapLogic
        • IICS
        • Ab Initio
        • SSIS
        • Talend
        • Pentaho
      • Orchestration
        • AutoSys
        • Control-M
      • EDW
      • Analytics
        • SAS
        • Alteryx
      • BI
      • Shell Script
    • Error Specifications & Troubleshooting
  • SQL Transformation
    • Overview
    • Creating and Executing the Online Notebook
      • How to Create and Execute the Notebook
      • Supported Features
    • Configuring the Notebook
      • Transformation
      • Unit Level Validation
      • Script Level Validation
    • Notebook Listing
  • Operationalization
    • Overview
      • Basic
      • Advanced
      • Cron Expression
    • Parallel Run Pipeline Listing
  • Transformation Source
    • Introduction
    • Creating Transformation Source Type
  • Governance
    • Summary of Governance - Roles and Permissions
    • User Creation
      • Creating a new User Account
    • Adding Roles and permissions
      • How to add Roles and Permissions to a new user?
    • Adding Group Accounts
    • Manage Quota
    • Product Usage Metrics
  • License
    • Workload Assessment
    • EDW Conversion
    • ETL Conversion
    • BI Conversion
    • Orchestration Conversion
    • Data Migration
    • Data Validation
  • LeapLogic Desktop Version
    • Overview
    • Registration and Installation
    • Getting Started
    • Creating Assessment
      • ETL
      • DML
      • Procedure
      • Analytics
      • Hadoop
    • Reports and Insights
      • Downloadable Reports
      • Reports for Estimation
    • Logging and Troubleshooting
    • Sample Scripts
    • Desktop vs. Web Version
    • Getting Help
  • LeapLogic (Version 5.0) Deployment
    • System Requirements
    • Prerequisites
    • Deployment
      • Extracting Package
      • Placing License Key
      • Executing Deployment Script
      • Accessing LeapLogic
    • Uploading License
    • Appendix
    • Getting Help
  • Removed Features
    • Configuring File Validation Stage
    • Variable Extractor Stage
      • Variable Extractor Report
    • Configuring Meta Diff Stage
      • Meta Diff
    • Configuring Data Load Stage
      • Data Load
    • Configuring Multi Algo Stage
  • FAQs
  • Tutorial Videos
  • Notice
Home   »  Batch Processing using Pipeline   »  Designing Pipeline   »  How to create a pipeline   »  Configuring Transformation Stage  »  LeapFusion

LeapFusion

LeapFusion is LeapLogic’s AI-driven feature designed to accelerate the modernization of EDW workloads. It automatically converts the queries that are not handled by the default LeapLogic Core transformation engine into optimized, target-native equivalents. It further validates the transformed queries leveraging other LLMs, referred to as ‘Helper Models’, and also suggest any corrections as required. LeapFusion streamlines complex query transformation – reducing manual effort, improving accuracy, and accelerating migration. It ensures seamless transformation of legacy workloads into modern cloud platforms.

LeapFusion uses two model types: Base Model and Helper Model.

  • Base Model: Converts queries that are not handled by the default LeapLogic Core transformation engine to the target equivalent. It supports both offline (LeapLogic) and online (Amazon Bedrock) modes of transformation.
    • Online Models (Native integration with all Amazon Bedrock including Claude LLM models): LeapLogic provides seamless integration with Amazon Bedrock, including access to Claude and other foundation models. These are referred to as Online models within the platform, as they run natively in the cloud and are continuously updated by their providers. This integration allows you to take advantage of cutting-edge generative AI models without additional configuration or setup.
      By relying on Amazon Bedrock’s managed environment, you gain flexibility in choosing from multiple models while ensuring enterprise-grade scalability, availability, and security. The native support removes friction in adoption, making it easier to leverage generative AI for a wide range of transformation and modernization needs.
    • Offline Models (Open source LLMs adopted and trained on LeapLogic’s datasets and code formats): Alongside online integration, LeapLogic leverages open-source LLMs that are customized and trained on its own datasets and supported code formats. These are referred to as Offline models, offering more control and flexibility in environments where cloud-based models are not feasible or preferred.
      By aligning open-source LLMs with LeapLogic’s code and transformation patterns, the platform ensures consistent quality of outputs. This setup also helps organizations maintain compliance with specific data handling requirements while still benefiting from generative AI capabilities.
  • Helper Model: Validates the transformed queries generated by the Base Model and suggests corrections if needed.

In This Topic:

  • Key Features
  • LeapLogic Modernization Capabilities



Key Features

The key features of LeapFusion includes:

  • Native integration with all Amazon Bedrock LLM models (referred as Online models).
  • Plug-and-Evolve architecture – Auto-syncs with new LLM releases without manual updates or engineering effort.
  • Open source LLMs adopted and trained on LeapLogic’s datasets and code formats (referred as Offline models).
  • Dual-core, hybrid AI architecture that fuses deterministic pattern recognition (80–85%) with contextual generative reasoning (15–20%), compressing timelines & zeroing manual intervention.
  • Situation-aware and semantic-preserving prompt injection engine.
  • Intelligent cascading DQ checks and validations across multiple LLMs in a single conversion pipeline to ultimately generate the best output for LeapLogic customers.
  • Intelligent recommendations for conversational interfaces rationalizing analytics & BI workloads and reducing TCO.
  • Transparency & auditability into how and why code was transformed or rewritten using AI.
  • Responsible AI with session-level LLM fine-tuning only, no cross-customer learning or sharing.



LeapLogic Modernization Capabilities

LeapLogic delivers advanced, AI-driven capabilities to simplify and accelerate workload modernization, ensure consistency, and deliver highly accurate transformation outcomes.

Plug-and-Evolve architecture (Auto-syncs with new LLM releases without manual updates or engineering effort)

The Plug-and-Evolve architecture is designed to automatically align with new LLM releases, ensuring that LeapLogic users always have access to the latest advancements without needing manual intervention. This capability eliminates the operational burden of constant engineering updates or patch management, allowing teams to focus on business outcomes instead of infrastructure upkeep.

This approach also future-proofs AI-driven modernization pipelines. As new models become available, the platform automatically incorporates them, ensuring compatibility, performance improvements, and access to innovative features without disrupting existing workflows.


Dual-core and Hybrid AI Architecture

LeapLogic’s hybrid AI architecture combines deterministic pattern recognition (80–85%) with contextual generative reasoning (15–20%). This dual-core design ensures a balance between reliability and adaptability, producing outputs that are both accurate and context-aware.

The deterministic engine accelerates routine transformations with consistency, while the generative reasoning layer handles exceptions and nuanced scenarios. Together, they help compress project timelines, minimize manual intervention, and deliver more predictable modernization outcomes.


Situation-aware and Semantic-Preserving Prompt Injection Engine

The platform features a prompt injection engine that is both situation-aware and semantic-preserving. This ensures that prompts are tailored to the context of the transformation task while retaining the original meaning of the code or logic being converted.

By carefully constructing prompts, the engine reduces ambiguity and enhances the precision of LLM responses. This results in higher-quality transformations and lowers the risk of unintended changes during code modernization.


Intelligent Cascading DQ Checks and Validations

LeapLogic applies intelligent cascading data quality (DQ) checks and validations across multiple LLMs in a single conversion pipeline. This layered approach ensures that outputs are validated at different stages, ultimately converging on the best possible result.

By distributing checks across multiple models, the platform maximizes reliability and minimizes error propagation. Customers benefit from cleaner, more trustworthy transformations that reduce the need for rework.


Intelligent Recommendations for Conversational Interfaces

The system provides intelligent recommendations that extend to conversational interfaces, helping streamline analytics and BI workloads. These recommendations are designed to optimize query handling and resource utilization, which in turn lowers total cost of ownership (TCO).

By embedding AI-driven suggestions into conversations, LeapLogic helps users navigate complex workloads more efficiently. This improves both productivity and decision-making while keeping infrastructure and licensing costs in check.


Transparency and Auditability

LeapLogic ensures transparency and auditability into how AI transforms or rewrites code. Users can trace why a particular output was generated, which rules were applied, and how decisions were made during the process.

This visibility builds trust and enables teams to review, validate, or refine transformations with confidence. It also supports compliance with enterprise governance and audit requirements, making AI-driven modernization both explainable and verifiable.


Responsible AI Practices

Responsible AI is embedded into the platform’s design. LeapLogic applies fine-tuning only at the session level, ensuring that learning does not extend across customers or projects. This means no cross-customer sharing of data, knowledge, or transformations.

By isolating sessions in this way, the platform prioritizes privacy and confidentiality. Customers can rely on AI-powered transformations while knowing that their data and code remain fully secure and protected from external influence.


For detailed steps on transforming your workloads with LeapFusion, click here.


To learn more, contact our support team or write to: info@leaplogic.io

Copyright © 2025 Impetus Technologies Inc. All Rights Reserved

  • Terms of Use
  • Privacy Policy
  • License Agreement
To the top ↑ Up ↑