• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Ab Initio Tutorials

Ab Initio Tutorials

Ab Initio Overview

Welcome to the Ab Initio Tutorials. The objective of these tutorials is to get in depth understanding of Ab Initio. In these tutorials, we will cover various Ansible functions with examples. The tutorial starts with overview of Ab Initio, Installation of Ab Initio.

In addition to these tutorials, we will also cover common issues, Interview questions and How To’s of Ab Initio.

Ab Initio Introduction

Abinitio is one of the important modules in ERP platform. Ab Initio means start from the beginning and it works with client server module. This module is also known as GDE (graphical development environment); the server is also called as co –operating system.

Ab Initio Software is an American multinational enterprise software corporation based in Lexington, Massachusetts. The company specializes in high-volume data processing applications and enterprise application integration. It was founded in 1995 by the former CEO of Thinking Machines Corporation, Sheryl Handler, and several other former employees after the bankruptcy of that company.

What is ab initio?

The Ab Initio software is a Business Intelligence platform containing six data processing products: Co>Operating System, The Component Library, Graphical Development Environment, Enterprise Meta>Environment, Data Profiler and Conduct>It. It is a powerful graphical user interface-based parallel processing tool for ETL data management and analysis.The company specializes in high-volume data processing applications and enterprise application integration.

What is mean by Co > Operating system and why it is special for Abinitio ?

It converts the AbInitio specific code into the format, which the UNIX/Windows can understand and feeds it to the native operating system, which carries out the task.

Interested in mastering Ab initio Training? Enroll now for FREE demo on Ab initio Training.

Components of Ab Initio

– Co operating system

– Ab Initio GDE

– Ab Initio EME

– Conduct>IT

– Data profiler

– Component Library

Co Operating System

Co Operating System is a program provided by Ab Initio which operates on the top of the operating system and is a base for all Ab Initio processes. It provides additional features known as air commands which can be installed on a variety of system environments such as Unix, HP-UX, Linux, IBM AIX, Windows systems. The Ab Initio CoOperating System provides the following features:
-Manage and run AbInitio graphs and control the ETL processes
-Provides Ab Initio extensions to the operating system
-ETL processes monitoring and debugging
-Metadata management and interaction with the EME

Ab Initio GDE (Graphical Development Environment)

GDE is a graphical application for developers which is used for designing and running AbInitio graphs. It also provides:

– The ETL process in AbInitio is represented by Ab Initio graphs. Graphs are formed by components (from the standard components library or custom), flows (data streams) and parameters.

– A user-friendly frontend for designing Ab Initio ETL graphs

– Ability to run, debug Ab Initio jobs and trace execution logs

– GDE AbInitio graph compilation process results in generation of a UNIX shell script which may be executed on a machine without the GDE installed

Ab Initio EME

Enterprise Meta>Environment (EME) is an Ab Initio repository and environment for storing and managing metadata. It provides capability to store both business and technical metadata. EME metadata can be accessed from the Ab Initio GDE, web browser or Ab Initio CoOperating system command line (air commands).


Conduct It is an environment for creating enterprise Ab Initio data integration systems. Its main role is to create Ab Initio Plans which is a special type of graph constructed of another graphs and scripts. Ab Initio provides both graphical and command-line interface to Conduct>IT.

Ab Initio Capabilities, classically an ETL vendor, has gradually emerged as a strong player in the application integration spectrum with its wide range of enterprise scale, mission-critical applications that include:

-data warehousing (ETL)

– real-time analytics

customer relationship management (CRM)

-enterprise application integration (EAI)

Data Profiler

The Data Profiler is an analytical application that can specify data range, scope, distribution, variance, and quality. It runs in a graphic environment on top of the Co Operating system.

Component Library

The Ab Initio Component Library is a reusable software module for sorting, data transformation, and high-speed database loading and unloading. This is a flexible and extensible tool which adapts at runtime to the formats of records entered and allows creation and incorporation of new components obtained from any program that permits integration and reuse of external legacy codes and storage engines.
Check out the top Ab initio Interview Questions now!


-Graphical programming boosts productivity

-Applications built graphically are easy to understand and explain.

-Applications are portable to many platforms.

-The Co>operating system delivers high performance and unlimited scalability.

-The Co>operating system ensures robust execution.

Ab Initio Solutions

Ab Initio software is used in a wide variety of systems, including:

-Data Warehousing

Extraction, Transformation and Loading(ETL)

-Real-Time Data Collection and Analysis

-Customers Relationship Management(CRM)

-Data Mining

-On-Line Analytical Processing(OLAP)

-Click-stream Analysis

Differences between Informatica and Ab Initio

Just like Informatica, Ab Initio is also one of the popular ETL tools used in Market.Below are the differences between both

-Informatica and Ab Initio both support parallelism. Informatica power center supports parallelism but not all type of parallelism whereas Ab Initio the tool has three types of parallelisms in Ab Initio- ComponentData ,Parallelism Pipe and Line parallelism

-Informatica is an engine based ETL tool, the power this tool is in its transformation engine and the code that it generates after development cannot be seen or modified whereas Ab Initio is a code based ETL tool, it generates ksh or bat etc. code, which can be modified to achieve the goals, if any that cannot be taken care through the ETL tool itself.

-Informatica has CDC – Change Data Capture capabilities to extract only the changed data whereas Ab Initio has to rely on DB to provide the CDC capabilities

-Ab Initio you can read data with multiple delimiter in a given record, where as Informatica force you to have all the fields be delimited by one standard delimiter.

-Ab Initio scheduling is done through script or manually unlike Informatica Scheduler which is very powerful.

Data Warehouse

It is a portal delivers information about Data Warehouse technology. In one place you can find descriptions of ETL and BI tools, the most popular Data Warehouse architectures, solutions, engines and many others. On our pages you can find overview and general very useful information about whole Business Intelligence market. In the News section you can gather a piece of information about Data Warehouse and BI events and seminars. If you want to gain optimum value from information assets in your organization Datawarehouse4u.info is the first step that you should take.


Ab Initio - Data Warehouse

A data warehouse is a subject-oriented, integrated, time varying, non-volatile collection of data in support of the management’s decision-making process.

A data warehouse is a centralized repository that stores data from multiple information sources and transforms them into a common, multidimensional data model for efficient querying and analysis.

ETL stands for extract, transform and load, the processes that enable companies to move data from multiple sources, reformat and cleanse it, and load it into another database, a data mart or a data warehouse for analysis, or on another operational system to support a business process.

For Indepth Knowledge on Ab Initio Click On:


Review Date
Reviewed Item
Useful Ab Initio Tutorials To Read
Author Rating

Contact US

Need an Instructor Led Training, Contact Us

Enter this code: captcha