Skip to main content

Administration Console Server Tool in Informatica


What is the Informatica Administration Console?


The Informatica Administration Console is a server tool that manages the domain’s properties, integration services, repository services, and user security.  





Who uses the Informatica Administration Console? 


The Informatica Administration Console is used primarily by system administrators.



Administration Console Terminology and Icons


Domain  

 


A collection of nodes and services that defines the PowerCenter environment. The domain controls the administration of shared services and system resources across a collection of machines.


Node 


A logical representation of a machine in a domain. A domain can have more than one node and each can be configured to run one or more the application services. 


Integration Service 

 

An application service contained within the domain that processes, manages and monitors workflows of the PowerCenter.


Repository Service  


An application service contained within the domain that manages connections to the repository.

 

License Key  
                            


Identifies the terms and conditions of a client’s Informatica environment.



Versioning 


The process of checking out, editing, and checking in repository objects. Only checked-out objects can be modified.



Administration Console Terminology and Icons



Domain Tab 


View and edit properties of the domain and objects within the domain.



Logs Tab

 

View log events for the domain and services within the domain.

 


Administration Tab 

 

Manage domain users in the Administration tab. This tab appears if you have permission on the domain. 



Upgrade Tab 


Upgrade Repositories and Integration Services. This tab appears if you have permission on the domain.



Manage Accounts Tab 


Manage your domain user profile. On this tab, you can change your domain user password and update your user profile.




Functions of the Informatica Administration Console

 

1.To stop and start repository services


2.To stop and start integration services


3.To manage and create domain objects


4.To view log events


5.To view and edit domain object properties


6.To manage security


7.To upgrade repositories


8.To create backup repositories

 


To stop and start repository services

 


 1.Click on the repository service in the navigator to open the repository service workspace.





 


2.Locate the “Enable” button near the top right-hand side of you screen. Click ”Enable” to start the repository services.







 

 3.Click on the Domain to validate the service has started.







 


4.To stop the repository services, you will click the Disable button. Choose either option in the pop-up widow and click “OK.”




 


To stop and start integration services

 

1.Click on Integration Service in the navigator to open the integration service workspace.






2.Locate the Enable button near the top right-hand side of you screen. Click ”Enable” to start the integration services


 




3.Click on the Domain to validate the service has started





 

4.To stop the integration services, you will click the Disable button. Choose the option you would prefer in the pop-up and click “OK.”







 

To manage and create domain objects

 

 1.Click on the Create drop down in the upper left-hand corner of your screen to display the option available in the domain.


 




To view log events

 

1.Click on the Logs tab in the upper left-hand corner of your screen. The log view will display all events that have occurred in your domain.





 

2.Click on the drop-down arrow to the view log filter options and change selection criteria for a service’s particular log.





3.Change filter criteria and click “OK.”

You can filter for any one particular service or all of them.

 


To view and edit domain object properties:

 

 1.Choose the domain object that you would like to edit from the left hand navigator.





 

2.Click the tabs in the objects workspace to view the properties and configurations for the object selected.





 

3. Click the Edit button in the upper right-hand corner of the properties window that you would like to edit.


 




Commonly edited domain object properties

 

• Domain => Properties => Database Properties

 

• Node => Properties => Backup Directory

 

• Integration Service => Properties => Codepage

 

 • Integration Service => Processes => Directories

 

 • Integration Service => Associated Repository

 

 • Repository => Properties => Database Properties

 


To create backup repositories:

 


1.Click on the Action tab in the repository service.


 




2.Choose “Back Up Contents” from the dropdown menu.


 




3.Enter the a repository username (preferably the Administrator’s), password, and filename for the backup. Click “OK.”


 




4.Validate that Back Up Contents task has succeeded.





 

5.Double check the file in the backup directory





 

 

To configure security

 

1.Click on the Manage Accounts tab in the upper right-hand corner of the Administration Console.





 

2.To create a new user, click on the Create User button.





 

3.Fill in the required prompts for the new user and click “OK.”

 

4.To edit privileges, click on the user in the navigator view of the page.




 


5.Choose the “Privileges” tab for the user.







 

6.Click on the Edit button to edit the user’s privileges



 


NOTE: The Administrator User and Roles privileges cannot be modified.

 


License Key restrictions

 

The Informatica license key provided by Oracle for the BI Applications should only be used for BI Application objects.





 

The license key does not include Informatica’s pushdown optimization and parallel processing functions.

 


Versioned Repository

 

The out-of-the-box BI Applications Repository comes with versioning enabled. This setting is listed in the Administration Console and cannot be modified

 



This can be overcome if you migrate the BI Application’s folders into a non-versioned repository.

 


1. Log in to Administration Console

 

Start – All Programs – Informatica Power Center – Services – Administration Console

 

Username: Administrator

 

Password: Administrator






 


2.Confirm that $PMRootDir value exists on the VM





 

3. Validate the Integration Service $PMSourceFileDir is “$PMRootDir/SrcFiles”


• View under Integration Services - Processes (Why do we do this? The Informatica Workflow Manager reads parameter files from this directory. We must verify its location because it is essential to the success of other Informatica Tools.)





 

4. Start the Repository and Integration Services.





 

5. Add a new administrative user


• Username: BICG-adm


• Password: welcome1





 

6. Sign out as the “Administrator” and sign in as “BICG-adm”


 




7. Add a developer user who does not have access to the domain.


• Username: BICG-dev


• Password: welcome2 (HINT: sign out as BICG-adm and sign back in as BICG-dev.


If you cannot access the Administration Console, you have given BICG-dev the correct access.)

 






8. Add another developer who does not have access to the domain. • Username: OTHER-dev • Password: welcome3





Comments

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope