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
  • 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
      • 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
  • 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
          • LeapLogic Express
        • 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
        • LeapLogic Express
      • 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
    • Default Quota Limits
    • Product Usage Metrics
  • License
    • EDW
    • ETL
  • 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 4.8) 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  »  FAQs

Technical/Product Related FAQs

Will the target environment leverage cloud capabilities to optimize performance and costs?

Yes! In addition to native optimization, LeapLogic supports capacity planning on the target environment so that the price-performance ratio is controlled and optimized. The transformed cloud-native stack ensures performance between the different services and workloads running on them.

Additionally, our cloud architecture team supports designing the optimum architecture for your needs, either through designing it themselves or working with your architecture team to recommend guidelines. This means that, no matter what, you’ll have a cloud architecture that will scale elastically while being cost-effective.

Will I be able to operate easily on the modern target system?

Yes! As a part of LeapLogic’s end-to-end modernization solution, operationalization is key. LeapLogic helps coordinate all workloads to run at scheduled times and on allocated cloud infrastructures. This ensures that all workloads are executable on the cloud, have the time they need to run, and deliver the same results as in the legacy environment. This provides a 100% assurance that end-to-end migration has been successful.

Will I be able to maintain the target system?

Yes! Transformed workloads would already be optimized to the target platform’s nuances and capabilities. LeapLogic applies optimization at every step, including schema conversion, code transformation, and orchestration. All of this makes it easier to maintain workloads on the modern cloud platform. Also, LeapLogic’s end-to-end approach, including operationalization, ensures that every aspect is rolled out through infrastructure as code. This automates the new environment set up and makes it seamless. Additionally, the cloud platform will inherently abstract operations to a certain extent, which helps with long-term maintenance.

What about my data security?

All data is secured at rest and in motion, and it is encrypted and masked using format-preserving encryption.

Is generated code proprietary, or is there any lock-in?

There is no lock-in or proprietary code. Workloads modernized with LeapLogic can run on any cloud-native stack.

What is the deployment model? Is LeapLogic a hosted solution? Can I license LeapLogic?

LeapLogic offers a variety of deployment models. That could vary from deployment on the customer’s premises along with onsite support, to an end-to-end offsite or cloud-hosted solution, or a combination of the two. The product is directly used by the conversion team, and the microservice-based architecture allows the tool to be licensed in various ways. Customers can choose required features and functionalities, ‘source and target’ combinations, required query/script conversion quotas, and more.

What is LeapLogic not?

LeapLogic is not:

  • Just a query or code converter
  • Services/frameworks marketed as automation
  • Meant for just a few legacy sources
  • A tool for just one target cloud

Rather, LeapLogic enables end-to-end transformation of the most widely used legacy stacks to diverse cloud-native technologies to optimize modern workloads.

What do you mean by end-to-end modernization of legacy data warehouses, ETL, and analytics systems?

We mean that we make the best use of target platform native technology capabilities for all steps of the modernization journey to assure a well-architected cloud-native solution. LeapLogic automates the migration, transformation, validation, and orchestration to accelerate modernization from start to finish.

What do you mean by superior automation? What percentage of out-of-the-box automation does LeapLogic offer?

70-95% of your legacy code can be converted and modernized automatically. The LeapLogic platform can also be quickly trained to support any code that is not automatically converted.

How does LeapLogic make a difference?

Transformation can be risky-we understand. You’re setting out to shift from a system that has worked for ten, fifteen years into one that can support the next few decades. To make modernization successful, you need to mitigate as many risks as possible. That’s where LeapLogic comes in.

Our system reduces risk by automating tasks that would otherwise need to be done manually. This means there’s a lower chance of human error. Superior automation at every step of the process, accompanied by visibility, transparency, and speed, means that every transformation paves the way for your teams to enter your digital future stronger, better prepared, and with less downtime than other migration strategies. Explore how Leap can bring value to your enterprise.

Who is LeapLogic for?

LeapLogic is made for teams looking to undergo a tech modernization at faster speeds, lower risk, and lower cost-it’s as simple as that. This technology supports teams moving from data warehouses, ETLs, and analytics systems to a variety of cloud environments. Discover what transformation can look like for you.

LeapLogic is also a great partner for cloud services and systems integration experts to support delivering on transformation targets. Contact us to see how we can deliver on your initiatives.

Do you have a trial version for LeapLogic?

Yes. You can access the trial here.

How to register new organization and create user?

To create a new organization, you have two options:

Option-1: Using SQL script

insert into gv_organization values((select max(id) + 1 from gv_organization),’NAME’,’DESCRIPTION’);

Option-2: Using REST API

Submit a HTTP POST request – https:///idw-gov-application/organization

Request Payload – {“name”:”Organization”,”description”:”Organization”}

Browsing the list of existing Organizations:

Submit a HTTP GET request – https:///idw-gov-application/organizations

Creating a new user for an organization:

Login to LeapLogic application. Click Governance from the User menu.

By default, you’ll land on to Access Management. Click Users and then + to start creating a user.

Fill the mandatory details such as organization name (under Official tab) and assign roles and/or group (under access tab) to the user. Click ADD.

How to add a search metadata?

From the left navigation bar, go to Metadata and click Search.

Enter free text to directly perform a basic search and press Enter to click Search icon.

See all the results matching the given keyword along with the most commonly used repositories.

Click Advanced Search to explore more granular options for search.

How to add / update a repository / data source?

From the left navigation bar, go to Metadata and click Data Catalog.

Click ‘+’ to add a new repository which helps to connect to the server instance of your datastore.

Enter basic details of your server and click Create.

Add a data source for your repository. Specify the database you want to connect to and the valid credentials to establish a connection with that database.

Configure Email to keep you posted on any updates made on your repository or data source, may be by any other user.

To update a repository or a data source, click on the repository or the data source that needs to be edited.

A view page is opened, click Edit to update it. Make the required changes and click Save.

Click Open Data Catalog to browse the data sources within a repository or entities within a data source.

How to create and execute a notebook?

From the left navigation bar, go to SQL Transformation and click Transform.

Select the source query type and the target execution engine for your queries and click Create Notebook.

Enter or copy-paste your query in the original query Text box.

For faster and effective transformation, Click Configure and select live metadata (in the Metadata Configuration) to associate your notebook with a database for live metadata extraction or select offline metadata and upload offline DDL files.

Also, click Source Configuration and upload a pre-defined template to get the transformation output in that format.

Click Add New Transformation to add more queries in the notebook.

Either add all queries in one go and click Transform All that appears on the top rightmost of the screen or click Transform that appears below every Original Query Text box.

Click Transformation Difference to get the highlights of the differences between the original and the transformed query. The changes are highlighted using a color coding.

Once this is done, visit the created notebook anytime from the Notebook listing page. Add new transformation and again save the notebook or update configuration etc.

How to browse pipeline execution reports?

From the left navigation bar, go to Batch Transformation and click Pipeline.

See the status of the latest execution upfront on your pipeline tile.

Optionally, you can also change the view from the default card view to list view.

Click on your pipeline to directly navigate to the latest execution report where you’ll see report for all the stages.

Click Output tab and select the stage for which you want to see the reports.

A high-level summary report of that stage is displayed followed by a detailed report. Furthermore, a much detailed report can be downloaded for offline use.

How to create and execute a pipeline?

From the left navigation bar, go to Batch Transformation and click Design.

Expand the transformation library and see various options.

Drag-and-drop the required transformations onto the design workspace. Place the stages in the vicinity to connect them automatically. This would create a pipeline (workflow).

Double-click transformations to configure them.

A comprehensive field-level description of all the configurable parameters is provided on the Overview tab. Get a detailed idea about the configurations from there.

Click Validation to validate your pipeline, once you’re done with configuring it.

Save your pipeline.

Click Outline to see how various stages and transformations are connected with one another and in what sequence.

Directly execute it from the top navigation bar or schedule it using the scheduler.

How to create and execute an assessment?

Go to Assessment Dashboard and click ‘+’.

Give your assessment a name. Then, select the type of connection source.

You may want create an assessment from offline sources, or by connecting through database from where live query logs can be extracted or DML only or hybrid i.e. DML with live or offline sources. Additionally, you can also provide DDL files. Download sample files for a quick reference.

Also, configure thresholds for baselining the migration recommendations. These thresholds are basically “Filters” that baseline the recommendation of ideal migration candidates.

Save your assessment. Execute it from the context menu from the Assessment Dashboard.

How to browse an assessment?

Go to Assessment Dashboard and click on the assessment you want to browse through.

See the overview of your assessment on the Highlights page; delve deeper and see comprehensive analysis on the Analysis page; and see cost, risk and resource utilization based recommendations for migration on the Recommendations page.

Analysis page – shows the analysis of applications, users, queries, entities, views, sub-queries, statement types, and query constructs.

Recommendations page – shows the recommendations for migrating entities, views, queries, engine for efficient query execution and off-loadable schemas for different applications.


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 ↑