what is the relation to soa with informatica etl

Informatica Architecture

Informatica compages is service-oriented architecture (SOA). A service-oriented architecture is divers every bit a group of services that communicate with each other. It ways a simple information transfer during this communication, or it tin can be two or more services that coordinate the same activity.

The Informatica development depends upon the component-based evolution techniques. This technique uses the predefined components and functional units with their functionalities to get the event.

PowerCenter is based on the component-based development methodologies. To build a dataflow from the source to target, it used unlike components, and this process is called transformation.

Informatica ETL tool has the below services and components, such as:

1. Repository Service: It is responsible for maintaining Informatica metadata and provides access to the same to other services.
2. Integration Service: This service helps in the move of data from sources to the targets.
3. Reporting Service: This service generates the reports.
4. Nodes: This is a calculating platform to execute the higher up services.
5. Informatica Designer: It creates the mappings between source and target.
6. Workflow Managing director: It is used to create workflows or other tasks and their execution.
7. Workflow Monitor: It is used to monitor the execution of workflows.
8. Repository Manager: It is used to manage the objects in the repository.

Informatica Domain

• The Informatica domain is the fundamental administrative unit.
• The Informatica domain consists of nodes and services. These nodes and services are categorized into folders or sub-folders based on administration requirements and pattern architecture.
• The Console spider web folio of the Informatica administrator creates a domain that looks like a folder. Within this folder, we can create a node with the services.
• In the Informatica domain, a node is a logical representation of the machine. All the services and processes run inside the domain in the Informatica. Multiple nodes tin be present in a single domain. A gateway node receives the asking from the clients and guides them to their respective services.
• The domain provides two types of services, such as:
  1. Service Manager: It manages domain operations such as logging, authentication, and say-so. Information technology runs the application services on the nodes and leads users and groups.
  2. Application Services: It represents the server-specific services such as repository services, reporting services, and integration services. The awarding service can run on different nodes based on configuration.

Node

Node is a sensible study of a machine in a domain, and a domain has dissimilar hubs. To run the application administrations, we tin design the hubs, such equally mix administration.

PowerCenter Repository

The PowerCenter repository is a relational database such as SQL Server, Oracle, and Sybase. And these databases are maintained past the repository services. The database tables shop the metadata.

Informatica customer tools are the three types, such as:

1. Informatica designer
2. Informatica workflow manager
3. Informatica workflow monitor

Informatica provides repository services, and it is used to manage the repository. The repository services exclusively handle i request for one repository. Merely we tin execute it on multiple nodes for better operation.

Nosotros can maintain the dissimilar versions of the same objects considering of its version command mechanism. And besides ignore multiple users that modifying the same object at the same fourth dimension.

The objects created in the repository are having this three-state, such as:

• Valid: Valid objects have the right syntax, according to the Informatica. And used for the execution of the workflow.
• Invalid: Invalid objects exercise non follow the standard or rules. These objects checked the syntax, and properties are valid or not during the saving of the object in Informatica.
• Impacted: The child objects of the affected object are invalid.

PowerCenter Repository Service

PowerCenter repository service is a different multi-strung procedure. It allows the customer to change the metadata in the store. It accepts demands from the considerate benefit for metadata to run piece of work processes.
And the repository service maintains the associations from PowerCenter customers to the PowerCenter vault. It inserts the metadata inside the archive and keeps information technology refreshed. It is able to go along up consistency inside the archive metadata.

Domain configuration

In the Informatica ETL tool, the domain is the necessary key authoritative control. Information technology is an apparent entity that provides other dissimilar services such as repository service, integration service, and various nodes.

The Informatica admin console is used for the domain configuration. And the console is launched with the help of the web browsers.

PowerCenter Client and Server Connectivity

PowerCenter client tools are installed on the customer-side machines. These tools are the development tools such as workflow manager, PowerCenter designer, repository manager, and workflow monitor.

Informatica repository contains all the created mapping and objects in these client tools, which resides on the Informatica server. That's why customer tools must have network connectivity with the server.

Besides, PowerCenter client connects to the sources and targets to import the metadata and structure definitions. Thus, information technology also maintains the connectivity to the source or target systems.

• PowerCenter client uses the TCP/IP protocols for connectivity with the integration service and repository service.
• And PowerCenter client uses the ODBC drivers for the connectivity with the source or targets.

Repository Service

The repository service is a multithreading procedure. It maintains the connection between the PowerCenter clients and the PowerCenter repository.

The repository service can fetch, insert, and update the metadata inside the repository. And it too maintains the consistency inside the repository metadata.

Integration Service

The integration service is used equally an execution engine in the Informatica. It helps in executing the tasks which are created in the Informatica. Integration service works in the post-obit manner, such every bit:

• A user performs a workflow.
• The Informatica instructs the integration service to execute the workflow.
• Then the integration service reads workflow details from the repository.
• The integration service starts the execution of the tasks inside the workflow.
• After the execution, the job status is updated, for case, Succeeded, Failed, or Aborted.
• And then it grants the session log and workflow log.
• This service loads the data into the target systems.
• Integration service combines information from different sources.

---

shermanlemelow.blogspot.com

Source: https://www.javatpoint.com/informatica-architecture

Share this post