Pulling data from Source systems into Anaplan

Hi Team,

I am searching for some information to connect Anaplan with different source systems.

Is there any white-paper as such to know which will be the best way to connect different source systems to Anaplan for planning purposes?

Also, if I may ask about IQVIA, Integrichain, SAP and other ERP sources? Does getting the 'flat-file' from them and using Anaplan connect is the optimal way to do it ?

Or, we have any direct connectors available for them (using 3rd party ETL tools ex. Informatica,Mulesoft etc..) ?

Thank you for your time and support.

Warm Regards,

Jagmit

Accepted answers

All comments

Misbah

@Jagmit

Good question. The answer to this is "It depends" upon many factors like are you looking for a tool for which you don't incur any additional cost, Is your company already using third party connectors which you can leverage, do you have people who can work on Java or .net if you take that approach, what kind of licenses is your company upon.

Here are the multiple ways that Integration can take place with Anaplan

1. Anaplan Connect - Free to use but you need to write batch or shell scripts, You also need third party scheduler Like MS Task scheduler with it

2. Third Party Connectors - Mulesoft, Snaplogic, Dell Boomi, Hyperconnect, Informatica Connector. You have multiple inbuilt connectors with these options. Hyperconnect (my favorite) as it has hundreds of inbuilt connectors. (Note: Two connections in Hyperconnect is free of cost with enterprise edition license)

3 Rest APIs: This is the most complicated one but it is highly customizable. Works with Java and .Net also

4. CloudWorks: Cloud to Cloud Integration - As of now it can only be AWS S3 as source and target but I believe they are working on it to open it for other cloud platforms as well.

Hope that helps

Misbah

Jagmit

Hi @Misbah ,

Thank you again for your valuable inputs.

For the time being, we are trying to gather all the information available and need to evaluate the best possible (least maintenance) way.

Anaplan Connect- This is familiar to us (have worked on another similar tool, developing batch scripts(windows based))

3rd party connectors - I want to explore this part, as it looks promising. But, what I could find out from Hyperconnect's list of connectors - IQVIA, Integrichain wasn't available.

So, need to zero-in on a universal connector- which can help us connect with the mostly used source systems.

Looking forward to know more about the Informatica connector(Hyperconnect).

Thank you!

Regards,

Jagmit

Misbah

@Jagmit

Honestly speaking I have used Hyperconnect with SAP and Oracle ERPs. I haven't noticed if we have something for IQVIA or Integrichain. Let me loop in true integration champ here @ben_speight . Sorry Ben if you are not the right person to help the gentleman, I couldn't think of any other person than you.

ben_speight

I can't comment on this specific use case but if you start with tools with which you're already comfortable then that reduces the initial cognitive load. Using files splits the problem up into separate pieces (extract, transform, upload, import) which can be helpful in the early stages but you'll need to store them somewhere, which can be a concern unless either your filesystem encrypts data at rest, or you are testing with dummy data. Once you have a handful of basic integrations running, explore other ways of achieving the same ends and see if they work better for you.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
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…