Bulk contact enrichment in your database

On a schedule the scenario takes contacts from your database in batches, enriches them with fresh data, writes them back and sends a report to your messenger.

  • Contacts enriched in batches
  • Fresh data written back to the base
  • Up to fifteen hundred an hour
  • A report per batch to your messenger
Set it up for meScriptera

How it works

Automating Microsoft SQL and mangoOffice takes no code: a ready-made scenario does the routine for you.

  1. Starts when: Schedule Trigger
  2. Then: PROFILES QUERY
  3. Check: Loop Over Items2
  4. Then: Aggregate
  5. Then: DATA TRANSFORMATION
  6. Then: BULK DROPCONTACT REQUESTS
  7. Then: Wait2
  8. Then: BULK DROPCONTACT DOWNLOAD
  9. Then: Split Out
  10. Then: Postgres
  11. Then: Slack

You can launch this Microsoft SQL + mangoOffice integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios