Data Hub to Spoke Automation - is it possible?
Our organization uses Mulesoft to get data from source systems into the Data Hub on a regular, automatic, scheduled basis and has been great. One of the issues we face having 4+ spoke models with 10+ data imports each from the Data Hub is that there is a lot of "button pushing" required on a daily basis. For example, Sales data comes into the Data Hub each morning at 4am, but unless the button triggering the import process in the spoke models is pushed every morning, this is not reflected in the models for end users.
Is there a way to schedule these processes to run automatically within Anaplan? Where the spoke models run the process to import the data from the hub automatically? Across our Anaplan ecosystems we are looking at up to 60 of these processes needing to be ran daily, and we are expanding...
Best Answer
-
Yes, you can absolutely do that. I must admit, I am not a Mulesoft expert (I have never played with it), but in Anaplan Connect as well as Informatica, you simply connect to the spoke model to run the action. So, in Mulesoft, you most likely have a series of jobs pulling the data in from the sources. After those are finished, create another action/process (in Informatica I believe it is called a bundle) to connect to the spoke model to pull the data in from the data hub.
I wish I could help more from the Mulesoft side, but the answer to your question is yes.
Rob
1
Comments
-
Thank you Rob!0
-
Hi Rob,
Can you share some step by step guide from where i can refer and implement Data Hub to Spoke Automation?
It will be very helpful if you share some demo or example.
Thanks,
Arnab
0 -
Sorry to say, but that is really an impossible to ask because every data hub and spoke are different. I would recommend going through our training (Level 1, Level 2, and Level 3), at least Level 1 and Level 2 as a data hub is utilized in the trainings. In addition, I would recommend looking at these articles:
Data Hubs and Peak Performance:Benefits of a Data Hub:Rob2 -
@jakesachs now you can use cloud works to do model to model integrations . These can also be scheduled. So in your case data will be loaded to data hub via mulesoft and then from there on anaplan integration admin can setup cloudworks model to model sync .
more info here https://community.anaplan.com/t5/Best-Practices/CloudWorks-This-is-how-we-use-it-Part-5-Model-to-Model/ta-p/112691
1 -
It seems like Cloudworks is another application....aka another service that a company needs to pay for. Do you have any information on how that works?
0 -
@jakesachs cloudsworks is included ( first 100 integrations including processes ) you don't have to pay for it. It is really a game-changer especially model-to-model integrations as it enables true connected planning . @annjulie has a great article on how it works
1
