Data integration and data connectors

I am new to Anaplan have completed level1 and level2

since I am beginner, can some one provide links or articles to understand data integration and data connectors in Anaplan.

Thanks!

Tags

Accepted answers

Hello @Ayeshazaina ,

Please find below a link to the resources suggested to study the Master Anaplanner. Within the list, you will find some resources that will be suitable:

https://community.anaplan.com/discussion/63343/essential-anaplan-topics

Hope that helped!

Hi @Ayeshazaina and welcome to the Anaplan community.

Here are my 2 cents to help you with your data integration quest.

In short, to move data in and out of Anaplan you have 6 options:

Manual (using Anaplan interface to manually load and map flat files, or export data in flat files)
Anaplan Connect: tool that runs on your local machine and executes a series of instructions from a batch file. All you have to do is to write the instructions in the batch file (credentials, Anaplan workspace, model, action to be executed, file to be used and location of the file for instance) You can download the client form here, along with some batch examples.
1. Anaplan connect allows to schedule data actions (using a 3rd party scheduler such windows scheduler)
2. Works with Authentication Certificates for enhanced security
3. And can be used to run data integrations from local flat files as well as local and cloud data bases (such as local SQL Data Bases, Microsoft Data Factory..).
4. This article is superb, please have a look! [Link]
Anaplan CloudWorks: is a built-in integration administrator included with your Anaplan subscription that allows to automate data integrations using flat files hosted in AWS S3, Google Cloud Storage and Azure Blob. Allows to export data files to these cloud storage repositories and schedule actions too.
Native Connectors: connectors that allow you to push data to a particular system. This option is limited to Power BI, Tableau, Salesforce and DocuSign. You can find out more here.
Third Party tools (IPaaS): also called "ETLs". These are Informatica (Anaplan Hyperconnect), SnapLogic, MuleSoft, Dell Boomi and OneCloud (to my knowledge, these are the Integration Platforms as a Service that include connectors or operators to Anaplan). They all require of additional licenses and expertise but allow to connect data from a wide array of systems, run data transformations before loading into Anaplan and many other things.
Bespoke APIs: Anaplan has a number of APIs you can call to develop your own data integrations.

Please, have a look at these links from Community, Anapedia and Academy to dive deeper in this topic. Attached a pic on how to get to the relevant courses in Academy.

Cheers

Alex

All comments

Hello @Ayeshazaina ,

Please find below a link to the resources suggested to study the Master Anaplanner. Within the list, you will find some resources that will be suitable:

https://community.anaplan.com/discussion/63343/essential-anaplan-topics

Hope that helped!

Hi @Ayeshazaina and welcome to the Anaplan community.

Here are my 2 cents to help you with your data integration quest.

In short, to move data in and out of Anaplan you have 6 options:

Manual (using Anaplan interface to manually load and map flat files, or export data in flat files)
Anaplan Connect: tool that runs on your local machine and executes a series of instructions from a batch file. All you have to do is to write the instructions in the batch file (credentials, Anaplan workspace, model, action to be executed, file to be used and location of the file for instance) You can download the client form here, along with some batch examples.
1. Anaplan connect allows to schedule data actions (using a 3rd party scheduler such windows scheduler)
2. Works with Authentication Certificates for enhanced security
3. And can be used to run data integrations from local flat files as well as local and cloud data bases (such as local SQL Data Bases, Microsoft Data Factory..).
4. This article is superb, please have a look! [Link]
Anaplan CloudWorks: is a built-in integration administrator included with your Anaplan subscription that allows to automate data integrations using flat files hosted in AWS S3, Google Cloud Storage and Azure Blob. Allows to export data files to these cloud storage repositories and schedule actions too.
Native Connectors: connectors that allow you to push data to a particular system. This option is limited to Power BI, Tableau, Salesforce and DocuSign. You can find out more here.
Third Party tools (IPaaS): also called "ETLs". These are Informatica (Anaplan Hyperconnect), SnapLogic, MuleSoft, Dell Boomi and OneCloud (to my knowledge, these are the Integration Platforms as a Service that include connectors or operators to Anaplan). They all require of additional licenses and expertise but allow to connect data from a wide array of systems, run data transformations before loading into Anaplan and many other things.
Bespoke APIs: Anaplan has a number of APIs you can call to develop your own data integrations.

Please, have a look at these links from Community, Anapedia and Academy to dive deeper in this topic. Attached a pic on how to get to the relevant courses in Academy.

Cheers

Alex

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…