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

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
ADO - S3 incremental load vs. full replace
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…