"Export Directly from Spoke Model" or "Import from Spoke to Hub and Export from Hub"

Hi Everyone,

This question has probably been asked before, but wanted to get opinions on the two options. I have heard hard-lined opinions that outbound data should always be brought into Hub and then exported to another spoke model or external system.

I've always taken a combined approach that focuses on mitigating the amount of unnecessary integrations while taking into account space and performance implications of where the data is housed.

Should outbound data always be in HUB or a consolidated Outbound Data Hub or is there merit to exporting directly from the Spoke if the below are true?

No negative impact to model performance
Data doesn't have to be combined with data from other spoke
Limited number of other spokes/external systems pull the data

Accepted answers

All comments

Dikshant

Model-to-model Import takes less time rather than exporting the data out of Anaplan. It depends upon if the dataset you're exporting is an incremental or full load along with frequency of the exports. But don't standardize it, i would say and take a wiser call based on all these factors weather to send it from spoke or from Data Hub based on different datasets.

rob_marshall

@Taylor Moore

If the data does not need to be consolidated with another data set (another model), just export directly from the model. This way, the exported data will always be up to date.

If the data does need to be consolidated, think about creating an "Export Hub" model so you keep your inbound Data Hub clean which is only used for inbound data sources.

Tiffany.Rice

The one thing that will always be true is that every rule has an exception. 🤣

In addition to the considerations you raised, here are a couple others to contemplate: A Hub might create a more controlled process, with clear line of sight to the data that was sent outbound regardless of changes to the "live" model. Additionally scalability may be increased as you can recycle some of the integration coding (same workspace/model ID across all exports).

From my vantage, if the performance is not impact and there is no perceived benefit in staging the data in a Hub, then adding the hop ultimately only serves to create lag in the integration process. There are no hard and fast rules and the approach will ultimately come down to the business objective. Just my two cents. 😉

Quick Links

Can you help?

Unanswered questions

How do I create a "Dynamic Bulk Copy" Action?
I'm looking to create a bulk copy action that allows me to select the source and target list items at runtime / when the action is run. I have some vague recollection I saw this available at one point with my own eyes, but everywhere I look on Community I find old posts that refer to the feature not existing. However, I do…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385