Data Integration

Suppose any clients wants our view to automate integration .Which platform is good to start like mulesoft,dell bhoomi ,informatica or any ETL tools or REST API.

Please suggest some pre-requisites or some basic question/information which we can ask to the clients.

Accepted answers

All comments

Misbah

@surajk

It depends on so many factors. See if this helps

Anaplan Connect: Native Anaplan functionality. All you have to do is set it up on client server and write batch/shell scripts. This is free of cost and comes handy when your client doesn't want to procure third party integration tools. However it has certain limitations, you cannot do ETL activities, it can not schedule Jobs and it facilitates file based transfers

Third Party Integration tools: Like Mulesoft, Snaplogic, Dell Boomi, Informatica, Hyperconnect etc. These are quite easy to use & deploy and have tons of functionalities within it. Drawback is the cost of these licenses which is in addition to what you are paying for Anaplan licenses.

REST APIs: Anaplan allows you to leverage REST APIs (Both Bulk and Transactional) to integrate Anaplan with other systems. It is free but the drawback with it is that it is highly complex and need resources with coding skills (Java, .Net etc)

Bottom-line is that you have to weigh these options and see which is the best way forward for your client.

Hope that helps

Misbah

Miz Logix

rob_marshall

@surajk

It really depends on what the client has the most experience in. Of the 3rd party iPaaS vendors, they pretty much do the same thing, just a bit differently. As @Misbah, using the REST API's is a very complex and 100% custom code, so if the client does not have experience in this, I would pass on this route. If the client has no experience with integrations, I would probably steer them towards Anaplan Connect as it is the most basic and cheapest.

Rob

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?