vmanojrc30
2 years agoContributor
Data Integration Automation
I have a 3 step Data Integration process which I need to automate,
1. Extract OS data and push it to DB tables - DM Sequence
2. Execute list of DB Stored Procedures
3. Import data from DB to OS - DM Sequence
I started with an Extender BR calling them using BRAPI.Utilities, but the execution of Stored Procedures itself will take 6-8 hours and the DM Sequence time out before even SP completes.
Appreciate suggestions to automate this process.