Skip to main content

Notifications

Community site session details

Community site session details

Session Id : wQxV893aLExIcc+kzEUq73
Power Automate - Power Automate Desktop
Answered

Informatica Cloud Data Integration(ETL) with PowerAutomte

Like (0) ShareShare
ReportReport
Posted on 22 Aug 2022 04:48:12 by 54

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 

  • Verified answer
    awadheshyona Profile Picture
    54 on 30 Aug 2022 at 08:12:04
    Re: Informatica Cloud Data Integration(ETL) with PowerAutomte

    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. 

  • awadheshyona Profile Picture
    54 on 24 Aug 2022 at 13:50:57
    Re: Informatica Cloud Data Integration(ETL) with PowerAutomte

    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-background/m-p/1734478

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 11 Super User 2025 Season 1

#2
KO-05050229-0 Profile Picture

KO-05050229-0 4

#2
John_Mavridis Profile Picture

John_Mavridis 4 Microsoft Employee

Overall leaderboard