How to lookup/integrate data from another application(different data location)
V
Vinoth Kumar C
started a topic
about 1 year 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
Stéphanie FOURRIER
said
12 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."
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
about 1 year 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
Stéphanie FOURRIER
said
about 1 year 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
about 1 year ago
Thanks much Stephanie, that would help.
S
Stéphanie FOURRIER
said
12 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."
Vinoth Kumar C
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.
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."
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstStéphanie FOURRIER
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.
Vinoth Kumar C
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.
Stéphanie FOURRIER
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.
Vinoth Kumar C
Thanks much Stephanie, that would help.
Stéphanie FOURRIER
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."
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 263 topics