How to lookup/integrate data from another application(different data location) : Portal

V

Vinoth Kumar C

started a topic 7 months ago

Hi All,

We are looking for options to do an integration or lookup between different xDM applications that is two different data locations. For example, build an RDM application and use the data from RDM in Customer application.

Is there a way to integrate two application built using two different data locations and see data from another application.

Please share your thoughts and Appreciate your inputs.

Thanks.

Best Answer

S

Stephanie Fourrier said 6 months ago

Answer from our Technical Services Team was

"This leads to an important design decision: whether to have separate models or a single monolithic model. In practice, most clients choose the single model and then expose it as multiple applications, each with its own security.

If you do need to have separate models, you will have to use ETL to keep the entities in sync. Using your example the RDM model would be a producer and the Customer MDM a consumer. On the consumer side, you need to ensure the entity is read-only. To simplify building this out from the consumer side, you can use the database reverse-engineer feature to copy entities from the RDM data location."

S

Stephanie Fourrier

said 7 months ago

Hi Vinoth,

are you looking for a parent relationship from the consumer application to the master application? Will you want to display all of the data or just have the capability to select values from a list while authoring? Please share your specific needs and I'll be happy to tell you how our partners and customers have answered their use cases.

Best regards,

Stéphanie.

V

Vinoth Kumar C

said 7 months ago

Hi Stephanie,

Appreciate the response.

We are looking for both the options to display all the attributes from Main application and also lookup from secondary application. Please share your availability to discuss.

Thanks.

Vinoth.

S

Stephanie Fourrier

said 7 months ago

Hi Vinoth,

I'll forward you to our Technical Services team if you want a full discussion about it. They will get in touch with you and the outputs can be written here for public sharing.

They will get in touch with you directly.

Stéphanie.

V

Vinoth Kumar C

said 7 months ago

Thanks much Stephanie, that would help.

S

Stephanie Fourrier

said 6 months ago

Answer

Answer from our Technical Services Team was

"This leads to an important design decision: whether to have separate models or a single monolithic model. In practice, most clients choose the single model and then expose it as multiple applications, each with its own security.

If you do need to have separate models, you will have to use ETL to keep the entities in sync. Using your example the RDM model would be a producer and the Customer MDM a consumer. On the consumer side, you need to ensure the entity is read-only. To simplify building this out from the consumer side, you can use the database reverse-engineer feature to copy entities from the RDM data location."