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

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!