Does it make sense to have multiple data hub models for different uses?

geoffhartmann
geoffhartmann
in Integrations and extensibility

We currently load multiple data sets into our data hub, then from there to various spoke models. We want to increase the frequency of one of the loads but are concerned the process timing might conflict with another load. Does it make sense to load the data into different data hub models in the same workspace to avoid this? It would also allow me to segregate user access since users in the spoke model need access to be able to manually trigger the import from data hub. I'm just not sure if there's an impact I'm not considering correctly.

Answers

  • VanshikaSingh
    VanshikaSingh

    No, having multiple data hubs is not a best practice. You can make only one data hub.

    For frequency can you tell how it is scheduled? Is it cloudworks, anaplan connect, or some ETL tool.

    For users access to trigger manually you can maintain that by creating different model role and manage those import action in user tab —> Roles→actions.

  • geoffhartmann
    geoffhartmann

    Basically we have a bunch of data sets importing into our data hub via automated integrations, generally at an hourly cadence.

    One of the data sets is our expense transaction data that we use to generate our month-end/quarter-end close reports. When the team is working on those reports, they want to be able to refresh the data more frequently to capture updates to the data. We could increase the frequency of that data to update every 10 minutes to help them, but then I'm concerned with what would happen when the timing conflicts with the other imports into the data hub that we don't need to update as frequently.

    That's why the thought was if we move the expense transactions import to a different data hub model we could update it more frequently without that concern.

  • VanshikaSingh
    VanshikaSingh

    On this comment:

    "but then I'm concerned with what would happen when the timing conflicts with the other imports into the data hub that we don't need to update as frequently."

    If the non frequent import is of different list or modules that of frequent one(every 10 min) then no need to worry about it , it will not conflict.

Categories