Ab Initio ETL Graph Extraction Prerequisites
This topic briefs about the prerequisites required for Ab Initio ETL Graph extraction.
In This Topic:
Introduction
LeapLogic’s Assessment profiles existing inventory, identifies complexity, draws lineage and provides comprehensive recommendations for migration to modern data platform.
LeapLogic requires Ab Initio ETL graphs in the .ksh format to perform an assessment. Follow the below given steps to achieve the same. It can be done using two different options or methods as described below.
- Option 1: Run LeapLogic (this will require air command access on the sandboxes)
- Option 2: Generate KSH files using “Generate Script” capability on the GDE.
Option-1: CLI-based Approach
Use Impetus’ “abi-generate-script.sh” to export the Ab Initio graphs in the required format. This script calls “air” command with “-script-only” mode and does not actually execute the graphs.
Copy and extract AbinitioKSHExtraction.zip
There are two versions of ABI KSH extraction utilities which are available in separate directories.
- shell Directory – contains shell-based wrapper to call “air” command with “-script-only” for all .mp files.
- java_wrapper Directory – contains java-based wrapper. It does handle dynamic parameters in graphs. This version should be used when there is any error related to missing parameters.
Option-2: GDE-based Approach
Use the ‘Generate Script’ capability in GDE to export the Ab Initio ETL graphs in the required format.
- If there are errors at the end of the exported code, then write access to the temporary file system of the sandbox is needed.
- If there are no errors, the code will have mp commands and dml/xfr code under #+Script Start+ and #+Script End+ tags.
Copy the ‘generated script’ output in a text file.
If KSH contains “prohibit-legacy-codegen” at the end, then, using GDE:
- Go to Settings > Graph Settings > Script Generation and set Dynamic > GDE Compatible to 1.x
- Edit > Scripts > Generate Scripts.
- Copy the ‘generated script’ output in a text file.
- Copy external DML, XFR, SQL scripts called from graph.
- Share complete package containing the exported graph text file, external DML, External XFR and SQL scripts.
Getting Help
Contact LeapLogic technical support at info@leaplogic.io
Leaplogic