How to add a Data Hub to existing ALM structure

Hello everyone,

Our current workspace/structure as follows:

DEV workspace

TEST workspace

PROD workspace

ALM: DEV --> TEST, DEV --> PROD

We are considering implementing a Data Hub to hold transactional data & be the single source of truth. I know it is best practice to first create the Data Hub and then the other spoke models; however, this is a 3 year old client model. I am wondering what is best practice on how to implement a data hub in this case? How would I go about ALM? How would the structure/architecture look like and what are some things to take into consideration.

If there is a how to article with steps and instructions, please link. Thank you!

Accepted answers

All comments

JaredDolich

@eva.cheng

That's quite a use case! Great question.

Some initial thoughts - you can tell us how/what direction you want to go.

It sounds like the Dev-Test-Prod process is already in place WITHOUT a data hub.
Keep in mind ALM does NOT affect data, only structure.
So, it seems to me the first step is to identify the process that moves data into and out of Anaplan.
From there you can architect the data hub, determine what actions need to be created to replace the existing processes to import data.

My highest recommendation for you is to start by reading about data hub performance. It's REALLY important to get off on the right process. You can very easily program yourself into a corner and make things much harder for yourself. Please read @rob_marshall best practice article on peak performance. It's a game changer, I promise.

Let's keep this conversation going. It's a big use case so, take it slow.

Misbah

@eva.cheng Most of us go with just single data hub but a few have two data hubs one for Dev and the other for Prod.

Anyway you will have to create Data hub first as per best practices and then push all the data thru processes to Dev. Once you validate all the processes are running fine, sample data is smoothly moving then you can think of loading full set of data into data hub and shift your focus on prod model. Now your source for prod model becomes data hub instead of anything else. So if you had any other model sending data you may want to change that to data hub by visiting to import data sources in the prod model and change it to data hub.

ArunManickam

Hello @eva.cheng

Option 1: NO ALM to Data hub itself. Keep the data hub common for DEV/TEST/PROD.

Option 2: Creating a DEV/TEST/PROD data hub.

In Option 1, you can create the import action in DEV from Data hub using a saved view. Once validated in DEV, sync to TEST and then to PROD.

In Option 2, you have to create import action in DEV from DEV data hub using a saved view. Once validated, sync changes to Datahub TEST and Spoke TEST. Then to PROD. You need to maintain the source models, accordingly, DEV is connected with DEV data hub, TEST is connected with TEST data hub etc.

Option 1 is genrally preferred.

Thanks

Arun

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…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…