Informatica Cloud Data Integration(ETL) with PowerAutomte

[awadheshyona]

Hi All,

I am new to PowerAutomate Desktop and recently worked on a web link extractions and it works fine.

I have another requirement, where I want to automate L1 support for Informatica(IICS) data loads. We have a run book(excel file) which has names of jobs which generally fails and its resolution actions, most of the time the action for failed job is to restart from failed task or resume from last failed task. 

Do we have any way by which we can automate this, continuously looking at IICS monitor, and if a job fails, find it in run book and perform its resolution action. 

Thanks in advance.

Regards,

Awadhesh 

[awadheshyona]

I am kind of able to achieve this however getting the below issue:

https://powerusers.microsoft.com/t5/General-Power-Automate/Move-mouse-to-text-on-screen-in-backgroun...

[awadheshyona · Accepted solution]

Hi All,

With the above limitation(or the way PAD works), this is how I have achieved the automation.

- Used Cloud flow to trigger Desktop flow when a Mail arrives in a designated folder

Below things done in PAD

- Get details of Task/Error from mail using Retrieve email messages from Outlook

- Used For each and extracted Mail information 

- Read one excel file(Run book), which has Task and Task flow details and common errors. Get the details from run book by comparing failed task name from mail to Task name in Run book.

- Launch Chrome and Open IICS

- Used Move mouse to text on screen (OCR) and clicked on the text(Which is Taskflow name and opens Taskflow which failed)

- Used Move mouse to image, and click on icon to resume/restart the task as per resolution strategy using IF.

- On successful text found and restart/resume click, responded to Outlook message and replied saying the job has been restarted/resumed, or respond saying that job could not be found and manual intervention is needed. 

-