cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
awadheshyona
Frequent Visitor

Informatica Cloud Data Integration(ETL) with PowerAutomte

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 

1 ACCEPTED SOLUTION

Accepted Solutions
awadheshyona
Frequent Visitor

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. 

View solution in original post

2 REPLIES 2
awadheshyona
Frequent Visitor

awadheshyona
Frequent Visitor

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. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,768)