Informatica Way - Restoring lost Informatica file system

One of our servers crashed and we had lost the complete file system and the Informatica folder. However,the repository database was on another server and it was intact. It was a challenge for the Informatica Administration Team to restore & recover several components including:-

• Powercenter Services
• Data Quality / Analyst Services
• Data Transformation Projects
• Data Validation Option for the Server
• Data Virtualization Services

Server Characteristics:-

• Powercenter & DQ Metadata was available in the databases which were configured for the corresponding Repositories
• Number of Users in the server = 10
• Number of Folders in Powercenter = 25
• Number of Projects in DQ = 10
• Data Transformation Projects = 5

We leveraged the “Content Already Exists in the Specified Database” feature available in the Informatica Administrator Tool during the re-installation process to re-install the server (Domain) & to re-establish connection with the existing repository.

Using the steps mentioned below, we could restore all the data successfully except the previously created users (we re-created the users)