Saturday, March 16, 2013

Informatica Software Architecture illustrated 8x

1. Informatica PowerCenter Client Tools:
These are the development tools installed at developer end. These tools enable a developer to
  • Define transformation process, known as mapping. (Designer)
  • Define run-time properties for a mapping, known as sessions (Workflow Manager)
  • Monitor execution of sessions (Workflow Monitor)
  • Manage repository, useful for administrators (Repository Manager)
  • Report Metadata (Metadata Reporter)

2. Informatica PowerCenter Repository:
Repository is the heart of Informatica tools. Repository is a kind of data inventory where all the data related to mappings, sources, targets etc is kept. This is the place where all the metadata for your application is stored. All the client tools and Informatica Server fetch data from Repository. Informatica client and server without repository is same as a PC without memory/harddisk, which has got the ability to process data but has no data to process. This can be treated as backend of Informatica.

3. Informatica PowerCenter Server:
Server is the place, where all the executions take place. Server makes physical connections to sources/targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.


This architecture is visually explained in diagram below:

Sources

Standard: RDBMS, Flat Files, XML, ODBC 

Applications: SAP R/3, SAP BW, PeopleSoft, Siebel, JD Edwards, i2 

EAI: MQ Series, Tibco, JMS, Web Services

Legacy: Mainframes (DB2, VSAM, IMS, IDMS, Adabas)AS400 (DB2, Flat File) 

Remote Sources


 
Targets

Standard: RDBMS, Flat Files, XML, ODBC

Applications: SAP R/3, SAP BW, PeopleSoft, Siebel, JD Edwards, i2

EAI: MQ Series, Tibco, JMS, Web Services

Legacy: Mainframes (DB2)AS400 (DB2)

Remote Targets



9 comments:

  1. Replies
    1. Looking for the best SAP SD Training in Bangalore, then don't delay join IntelliMindz SAP SD Training in Bangalore. Join our SAP SD training to get hands-on training and practice in SAP SD Software. Any Queries call @ 9655877677. IntelliMindz is the best IT Training Institute in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.
      SAP SD in Bangalore
      SAP SD in Chennai
      SAP SD in Coimbatore
      SAP SD Online Course

      Delete
  2. Interesting blog, here a lot of valuable information is available, it is very useful information informatica online training

    ReplyDelete
  3. How to get Workday Tenant Access
    Workday Tenant Access is needed to practice workday ERP Cloud Application.
    Like below are various Workday modules
    HCM (All Modules)
    Finance (All Modules)
    Student
    Prism Analytics
    https://workdaytenantaccess.com/

    ReplyDelete
  4. Hi Gowtham, Very useful blog for Informatica. Can you answer my question?
    We have Informatica 9.6.1 installed in our machine. How to connect with Snowflake?

    ReplyDelete