Integration with Microsoft Access Database

PrevContributor

Hi, I need information on how Anaplan can be integrated MS Access for importing & exporting data to lists and modules. Also, need information on how the same can be automated based on certain triggers or on the click of action buttons.  Thanks,  Aseem

PrevContributor

Hi Aseem,

Some great places to get started are Anaplan Connect (https://community.anaplan.com/documents/10180/3990274/AnaplanConnectQuickStartGuide-2016-11-30.pdf/d221f72c-c15a-4d2b-be72-dac31caa2aef) which will allow you to build automation around the imports and exports.  Then you just build the import (https://community.anaplan.com/anapedia/data-integration/import) and export (https://community.anaplan.com/anapedia/data-integration/export) actions within Anaplan to define the mapping.

The triggering criteria are challenging, for now the only real automation is around date/time using either MS Scheduler, or a middleware tool like Informatica HyperConnect, but nothing really to trigger the integration based on a series of actions.  The best to do here within Anaplan is include a button on your dashboard that can be clicked when the data updates are complete which runs a process to finalize the actions within Anaplan AND export/import the data to/from MS Access.  

Happy to go into more detail on any of these items, just let me know which areas you'd like more clarification on, otherwise hope this helps point you in the right direction!

-Chris Weiss