Can we call a Informatica IDQ job / Mapping task from SnapLogic?
We are using Informatica IDQ to clean data based on business rules and want to incorporate kicking off the IDQ job through SnapLogic. We are trying to achieve the following,
- Write the dirty data into a SQL Server DB (In SnapLogic)
- Kick-off an Informatica IDQ job (In SnapLogic)
- The Informatica IDQ jobs fetches data from the DB, cleans it and writes it back to another DB (In Informatica)
- Read the clean data and pass it through to its destination system (In SnapLogic)
I really appreciate your help! Thanks.