Informatica IDMC Plug-in with Workload Automation

Let us begin by understanding Informatica Intelligent Data Management Cloud (IDMC), its capabilities, and how our Informatica IDMC Plug-in benefits to our Automation Orchestration users.
In today’s data-driven world, organizations rely on robust cloud data management platforms to integrate, transform, and orchestrate data across diverse environments. Informatica IDMC stands out as a leading cloud-native platform, offering comprehensive data integration, quality, governance, and automation capabilities. With the Informatica IDMC Plug-in for Workload Automation, downloadable from Automation Hub, you can seamlessly automate and manage Informatica tasks and workflows, ensuring reliable, scalable, and efficient data operations.

Key Features of the Informatica IDMC Plug-in
The Informatica IDMC Plug-in simplifies and enhances your data automation initiatives. Here’s what it offers:

1. Seamless Integration: Connect Workload Automation with Informatica IDMC to trigger and monitor Informatica tasks directly from your automation workflows.
2. Secure Credential Management: Store and manage Informatica credentials securely, ensuring safe access to your cloud environment.
3. Dynamic Task Selection: Easily select and run Mapping Tasks from Informatica, with picklists that automatically filter and display only valid, runnable tasks.
4. Automated Job Monitoring: Track job execution status, retrieve detailed logs, and handle errors gracefully, all within Workload Automation.
5. Robust Error Handling: Receive clear, actionable error messages for failed jobs, missing parameters, or connection issues, improving troubleshooting and user experience.

Use Cases
The Informatica IDMC Plug-in unlocks a range of possibilities for automating cloud data workflows. Common use cases include:

1. ETL Process Automation: Schedule and run Informatica Mapping Tasks to extract, transform, and load data across cloud and on-premises sources.
2. Data Quality and Governance: Automate data profiling, cleansing, and validation tasks to ensure high-quality, trusted data.
3. Business Intelligence Integration: Orchestrate data pipelines feeding BI dashboards and analytics platforms, ensuring timely and accurate insights.
4. Hybrid Cloud Operations: Manage and automate data movement between cloud and on-premises environments, supporting hybrid architectures.
5. Compliance and Audit Automation: Schedule regular data validation and audit tasks to meet regulatory requirements.

Example Workflow: Automating a Data Integration Pipeline
Imagine a scenario where a business needs to run daily data integration jobs to synchronize customer data from multiple sources. With the Informatica IDMC Plug-in, Workload Automation can trigger the appropriate Mapping Task in Informatica, monitor its execution, and handle any errors or exceptions that may occur. The plug-in ensures only valid Mapping Tasks are selectable and provides detailed logs and status updates for each job run. This automation streamlines data operations, reduces manual intervention, and improves reliability.

Getting Started with the Informatica IDMC Plug-in
To begin using the Informatica IDMC Plug-in, follow these steps:

1. Connect to Informatica IDMC

• Log in to the Dynamic Workload Console or UnO Console and open the Workload Designer.
• Create a new job definition/task and select the Informatica IDMC Plug-in.
• Username and Password: Enter your Informatica Cloud credentials.

1. Test Connection: Use the built-in test to verify connectivity and credentials

2. Define the Action

• In the Action tab, select the Mapping Task you wish to run from the filtered picklist.
• ​You may optionally provide runtime parameters or configuration files if needed for your task.

3. Add/Save and Submit/Run your Job

• Save the job definition and submit it to the current plan.
• Add the job to a job stream to automate your business process flow.
• Monitor job execution in the Monitoring View.
  
  

4. Monitor Job Execution

• Track job progress in the Monitor Page.
• Review detailed logs, including job status, error messages, and session logs.
• If the job completes successfully, the status will update to “Successful”.

Why Choose the Informatica IDMC Plug-in?
The Informatica IDMC Plug-in empowers organizations to automate and orchestrate cloud data management workflows, saving time and reducing operational risk. By integrating with Workload Automation, you centralize control over your data pipelines, ensure consistent execution, and gain visibility into every step of your data operations. Whether you’re automating ETL jobs, managing data quality, or supporting hybrid cloud strategies, this plug-in is your gateway to smarter, automated data workflows.

​Job Log Details:

---

---

Ernesto Carrabba, Product Manager, HCL Clara, HCL HERO and HCL Workload Automation 
​
Product Manager for HCL Clara, HCL HERO and HCL Workload Automation. Ernesto is a very dynamic product manager with experience in building and launching IoT products, combined with a master's degree in mechanical engineering and study researches on Augmented and Virtual Reality 

---

Mandeep Singh Jhass - Senior Software Engineer at HCL Software
​
Works as a Plug-in Developer and Level 3 support in the Workload Automation Plug-in Factory team. Proficient in Java, Git, Maven, Docker, Spring MVC, Spring Boot, and SQL.

---