Integration with Microsoft Access Database

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

Accepted answers

All comments

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

Quick Links

Can you help?

Unanswered questions

Polaris workaround for FIRSTNONBLANK
Polaris doesn't support FIRSTNONBLANK as a function parameter. I have a solution workaround for this already but not too happy with it. So wanted to know what solution workaround people have done to get around this limitation
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385