Informatica is an ETL tool useful to extract data from different sources, transform the data, and load the data into a central data warehouse. Informatica PowerCenter architecture is a service-oriented architecture (SOA) and it is defined as a group of services that communicate with multiple systems. It refers to a simple data transfer during communication. Moreover, Informatica PowerCenter architecture gives the capacity to scale administrations over various systems. This architecture includes different types of components.
Let us discuss the architecture design and various components of Informatica Powercenter.
Informatica PowerCenter components
The Informatica PowerCenter contains high availability, scalability, and high-performance. Moreover, it provides a platform to execute all significant data integrations and take an initiate all over the business units.
The Informatica PowerCenter includes the following important services and components listed below:
This is responsible for managing metadata and gives access to the same to different services.
This service is useful for the transformation of information from sources to targets.
This is useful to generate various reports
This is a computing platform where different services gets executed.
This is useful to make work processes and other tasks and their execution
This is useful to display and check the execution of work processes
It is useful to look after the questions & objects within the repository
It is useful to form mappings amongst source and target
Moreover, there are some other services of Informatica Powercenter. Such as;
- B2B exchange.
- Data governance, migration, and warehousing.
- Synchronization and replication of Data
- Integration Competency Centers (ICC).
- Master Data Management (MDM)
The Informatica PowerCenter Architecture is an SOA where the Informatica domain is the basic administrative unit. It includes various nodes and services. These nodes and services are divided into various folders or sub-folders. These based on admin requirements and architecture. Besides, the Informatica administrator console web designs a domain that looks like a folder. Here, the users can create a node along with the services. Moreover, within the domain, a node is a logical way of the machine. Different kinds of services and processes run inside this domain. Therefore, multiple nodes can be present within a single domain. Moreover, a gateway node receives the request from various clients and transfers them to their respective nodes & services.
Get in-depth knowledge of Informatica through Informatica Online Course from OnlineITGuru.
The domain includes two different types of services. These are:
This is responsible to manage domain operations like login, authentication, and authorization. Moreover, it runs the application services on different nodes and also manages various users and groups.
It includes various server-specific services like repository services, reporting services, and integration services. The application service runs on various nodes based on its configuration.
Other than the above, there are some key components of Domain. They are restart period, resilience timeout, database sort, dispatch mode, database have, port, and name.
Node is a sensitive part of a machine within a domain, and a domain contains different hubs. To run the application administrations, users can design the hubs, such as mix administration or vault benefit. Moreover, the Ace passage hub is one that includes a domain.
The Informatica PowerCenter repository includes a relational database maintained by repository services. Such as SQL Server, Oracle, etc. Moreover, these database tables store the metadata. Besides, the client tools that connect to the repository are of three types, such as:
- Informatica designer
- workflow manager
The Informatica PowerCenter also provides various repository services useful to manage the repository. These repository services exclusively handle a single request for a single repository. But the user can run it on different nodes for better performance.
Moreover, it offers a version control system. By using this users can manage the multiple versions of the same object. And it avoids different users changing the same object simultaneously. The object designed within the repository consists of three different states such as; valid, invalid & impacted.
Different PowerCenter client tools include workflow manager, designer, repository manager, monitor, etc. These are various development tools that are installed on the client machine. The Informatica Powercenter includes different mappings and objects saved within the server. Therefore, these client networks must have connectivity with the server.
Moreover, PowerCenter clients connect to the various sources and targets to import the structure definition and metadata. Therefore, it has to maintain a link with the source/target machines.
The Power Center uses TCP/IP to link the integration service and repository service. It uses ODBC drivers to link between source and targets.
This service is a multithreaded process that manages the link between the PowerCenter clients and the repository. Moreover, the repository service fetches, inserts, and updates the metadata within the repository. It also keeps the consistency within the repository metadata.
PowerCenter Integration service
The integration service is useful for the execution of various tasks created within Informatica PowerCenter. This is a kind of task within the Informatica server that waits for a task to be given to it. As the task is given to it, to execute a work process, the integration service starts the execution immediately. Moreover, it also performs reconciliation to the given tasks that they executed well or not. Let’s look at its working process in detail.
- Here, the user executes a work process initially.
- The Informatica PowerCenter gives instructions to the integration service to execute the work process.
- The integration service studies the work details from the repository
- This service starts execution of the tasks within the workflow
- After completion of the execution, the status is updated i.e. failed or succeeded.
- Later, the session log and work process logs are generated.
- Moreover, this service is responsible for transferring data to the target machines
Metadata Manager Service
It runs the metadata manager web applications to analyze the metadata from different metadata repositories. Moreover, Informatica PowerCenter offers various development capabilities and productivity tools also.
Sources & Targets
Being an ETL and Data integration tool, Informatica always allows the handling and transforming of data. The input given for mappings within Informatica is known as the source system. The user imports source data from various sources and links it to fetch source data to our mappings. There are multiple types of sources and are located at different locations. Based upon the user requirements the target system becomes a relational or flat file system.
These types of sources are database tables. These are generally owned by other applications use to create and maintain this data. This may be a CRMDB, Human Resource Database, etc.
These files are the most common data sources within Informatica that include a comma-separated file, a tab-delimited file, or a fixed-width file. It supports any type of code such as ASCII or Unicode. Moreover, to use this file under Informatica, it needs to import the definition similar to that we import for relational tables.
Informatica PowerCenter gives the best solutions to developers of the global IT sector, IT management, and business analysts too. It provides accurate and trusted data or information to meet the operational and analytical requirements of the business.
Thus, we came across the Informatica PowerCenter architecture and its various services and other aspects of the above details. This makes the sense of utilizing Informatica Powercenter towards multiple services and operations within the business unit. This powerful ETL tool helps to gets data from different sources to the system. Moreover, it makes various processes much easier and develops system communication well. Learn the latest trends and enhance the skill in this regard for a better future.
Learn more from the expert’s voice at IT Guru by joining Informatica Online Training to get basic to advanced skill development on the above technology.