Step 3. Create Transformation Pipeline and See Results

The workload transformation pipeline enables you to create a migration workflow for data and source code from source to target. The pipeline produces verified results through the validation stage.

This topic provides the steps to create and execute a pipeline.

Create connection to the server instance (Repository) and databases (Data Source) through the Data Catalog.
Drag-drop the data warehouse transformation stages onto the workspace, for example:
- Migration stage to convert schema and migrate data.
- Transformation stage to transform source code – DML scripts, stored procedures, ETL scripts, scheduler/orchestrator scripts.
- ETL Conversion stage to convert ETL scripts.
- Validation to validate the migrated dataset, transformed queries and schema.
- Execution to execute the transformed code in the target environment.

Steps:

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

Connect them to create a workflow.

Configure stages as per your requirement for instance select the tables that you want to migrate, upload the scripts to be transformed, and apply validation on the selected data and code.

Note:

The subsequent stages take the inputs from the previous stage by default. However, additional parameters can be configured as required.

Execute the pipeline.
Access your pipeline from the listing page. Click on it to see reports.

Next Step:

Step 4. Edit or Optimize the Transformed code