Proof Of Concept - Automation In Informatica Code Migration

Automation In Informatica Code Migration

Author : Shivakumar Krishnagouda Patil

Description :

This mini project has been taken up as an initiative , in the view of eradicating the duplication effort involved in Informatica Infrastructure Support projects and also to decrease the project costing by reducing the number resources (Administrators) who are carrying out the duplication effort. This reusable component reduces the half of time involved in carrying out the specified activity compared to the traditional manual effort so that we can deliver the work to the business within a short span of time. This component confirms  accurate work of productivity. User wait time can be reduced as most of the user waits when their work to be done.

Features of automated deployment groups

1.Automated migrations.
2.Reduction of admin resources.
3. Automated backup system.
4.Automated recovery.(In case of version control).
5.Faster code move.
6.Less effort investment.
7.No manual intervention.
8.Automated sanity checks.
9.Automated alerting in case of migration failures.
10.Time saving.
11.Bulk amount of objects can be migrated in a single shot. Which is a kind of reusable component
12.Migration logs can be captured for analysis.
13.The same deployment workflow, scripts can re-used in many environments for migrations.

Automated deployment groups

Tech Stack Used :

Tool : Informatica 9.1 (Hot Fix 4)
Database : Oracle 11g (Repository Schema Versionised)
Operating System : Linux RedHat (x86_64-Bit OS)

Scripting Used :

Shell Scripting (ksh)
Structured Query Language (sql)

Testing Used :

Unit Testing :

Each of the scripts have been tested separately in order to verify the functionality of each of it.

Regression Testing:

Informatica workflows has been ran in different intervals of time to ensure whether the
scripts used in workflow would adversely affect Informatica Infrastructure.

Advantages of automated deployment groups

•  User wait time can be reduced as most of the user waits when their code can be moved to target environment.
•  Effective use of automated deployment groups add value to the project and reduces the cost .
•  Ensures to business that accurate work of migrations.
•  Admin resources can be reduced where multiple admins used to do the multiple migrations where as in automated deployment a single admin can handle multiple migrations. (In traditional system 5 admins used to do the migration a single admin resource can handle with the help of automated deployment group)
•  Infa admin burden can be reduced – where in In traditional migration activity admin used to select the individual objects (check in /check out) and to migrate, which was very time consuming through a repository manager ,but with automated scripts it’s a piece of cake all the objects will be added in a single shot.
•  XML backup of the objects will be taken automatically by the script and which will send as an email with an attachment.
•  Automated deployment job can be scheduled to respective timings.

          Advantages of automated deployment groups

•  Admins will not be having any confusion as compared to normal traditional migrations –
•  which objects are missed and which objects needs to be validated everything will be taken care by scripts.
•  Once the Objects are migrated , script will be sending the email with time-stamp of the objects  migrated as a part of sanity check.
•  Automated deployment groups reduces the un-necessary duplication works.
•  In upgrade process huge amount of informatica folders can be migrated from one environment to other environment within a short span of time with the help of this automated deployment groups.
•  In this automation poc only few scripts are developed and those are re-used based on the requirement by passing the parameters . For Ex : object_export.ksh script which is developed only once and can be called three times for exporting the different informatica objects Mappings, Sessions, Workflows.
•  Scripts will take care of creating the deployment group, adding the objects to group and migrating the objects and once migration completes group will be automatically deleted.

Deployment groups overview :

Normally you know only

•  Static deployment groups
•  Dynamic deployment groups

 But here is the automated deployment group:

Informatica Admin will be just responsible to

•  Review the .csv spread sheet given by the user and
•  Place the spread sheet to Informatica server source file path
•  Schedule the deployment load
•  Manage the deployment scripts
•  High level sanity checks whether everything went smooth