Is it possible to automate Integrate?

Answered

DSP User

• May 01, 2018 05:41

Is it possible to automate Integrate? I've made an Integrate process to explode a BOM from SAP. However, I want to automate off the back of the Collect process (that extracts MAST table):

1. Run a SQL script to empty the upload table for the Integrate template.
2. Run SQL to populate the upload table template for Integrate using MAST data.
3. Run the Integrate process using the new data.

Does anyone know how to do this? We considered Collect table rules, but are not sure how to do it. Regards, Phil

1

• Best answer

  

  DSP Expert

  • May 01, 2018 07:08

  ASliney: You can use the tool Automate (previously Interface Server). Think of it as very advanced service pages. In order to run other events, they have to be Public, but the Post events are for Integrate. You can run the refresh, procedures and posting all from Automate.

  0
• 

  DSP Expert

  • May 01, 2018 10:51

  KVandergriend: To execute rules after a Collect refresh, click "Rules" for the tables, populate the stored procedure you created, including the database.dbo prefix, (it should exist in the source DB), and click "Add Target DB Param."

  0

Please sign in to leave a comment.