Ab Initio Session
Ab initio
1
Coverage
• Introduction to AbInitio
• Features of AbInitio
• Operating System Supported
• AbInitio Architecture
• Co–Operating System
• Graphical Development Environment
• Configuring GDE
• Component Library
• Sample Graph
• Running a Graph
Ab initio
2
Introduction to AB Initio
• “Ab Initio” is Latin for “From the Beginning.”
• Ab Initio is a powerful ETL (Extract, Transform, Load) tool.
• It is a general-purpose data processing platform for enterprise
class, mission-critical applications.
• It supports the integration of arbitrary data sources and
programs, and provides complete metadata management across
the enterprise.
• With parallelism and integration capabilities, it plays an extensive
part in the creation of Data Warehouse and Data Mart.
Ab initio
3
Features of AB Initio
• Scalable, Flexible and Portable
• Parallel Execution
• Check Pointing
• Meta Driven Components
• Database Load and Unload
• Data Transformation
• Analytical Processing
Ab initio
4
Operating System Supported
• HP Unix
• Windows NT
• Sun Solaris
• IBM AIX
Ab initio
5
AB Initio Architecture
User Applications
Development Environments Ab
GDE Shell
Initio
EME
Component Library User-defined 3rd Party
Components Components
The Ab Initio Co>Operating® System
Native Operating System (Unix,Windows, OS/390)
Ab initio
6
AB Initio Software
AB INITIO
Co>Operating System GDE
Ab initio
7
AB Initio Software
Ab initio
8
Co>Operating System
• Unlimited Scalability
Speedup proportional to the hardware resources available
Access files anywhere within an enterprise.
Manage files distributed across Network
Manage files that span to many disks (MFS)
• Flexibility
Open Component Model
• Portability
Runs on Various Platforms like OS390, UNIX, Windows etc
• Shell Level Utilities
The m_ commands are co-operating system commands such as
m_cp, m_mv etc.
Ab initio
9
Graphical Development Environment - GDE
• Runs on PC (client node) and Configured to communicate to host
• Create applications
By dragging and dropping components onto a canvas
configuring them with familiar, intuitive point-and-click operations
connecting them into executable flowcharts
The Co-Operating System executes this flowchart
• Benefits
Graphical monitoring of running applications
Spot Opportunities for improving Performance
Simple changing the application
Ab initio
10
GDE Environment
Run
Validate
Components
Ab initio
11
Configuring GDE
Steps to setup Host Profile
1. On the GDE menu bar, choose Settings > Manage Connection
Ab initio
12
Configuring GDE – contd.
2.Click New for setting up a new profile
Host setting
Co>Op Setting
Ab initio
13
Component Library
Component Library is a set of powerful, reusable software
modules with application-class power for critical tasks as sorting,
data transformation, and high-speed database loading and
unloading.
Powerful
Extensible
Metadata Driven
Ab initio
14
Component Organization
The components are the basic building blocks of AB Initio
applications.
There are two types of components
Component
Built-in User Defined
Ab initio
15
Component Groups
Note: Ab Initio provides 13 categories of components out of which only 12 are described above.
The remaining one is Deprecated Components whose use is discouraged for new applications.
Ab initio
16
Graph Model
Flows
Components
Dataset Ports
Sample Graph
Ab initio
17
Running a Graph
• Graphs can be run
GDE
By Invoking the Shell Script from Host Machine
• GDE Run
Graph is translated into script that can be executed in GDE.
This script and any metadata files store on the GDE client machine
are shipped to server (via FTP)
The script is invoked in the Server
The script creates and runs a job that may run across many hosts
Monitoring information are sent to client
Ab initio
18
Job Output Window
Job Output window displays the Application Execution monitor
to show the status of the job.
Ab initio
Running a Graph – contd.
Errors generated during runtime are thrown out into the Job output
window.
Ab initio
Thank You
Ab initio
21
