XDM Schema Design | Community
Skip to main content
V
Vamsik
New Participant
March 23, 2023
Solved

XDM Schema Design

  • March 23, 2023
  • 1 reply
  • 1305 views

Hello,

 

We are trying to create XDM Schema Design for the following data:

 

Table A: Contact_details

Column Datatype
person_id String
first name String
last name String

 

Table B: Account_details

Column Datatype
account_id String
person_id String
account_person_asc String
account_type

String

 

Relation between both the tables:

 

One person from Table A can have multiple accounts in Table B. It is basically a one-to-many mapping between these 2 tables. 

 

We are trying to create a complete profile of a person with all the details corresponding to their accounts. We tried creating both the tables as Profile class as below:

 

Table A: Profile Class

      Identities: PersonID --> person_id

Table B: Profile Class

      Identities: 

             AccountID --> account_id

             PersonID --> person_id

 

The profiles were created but didn't have all the information needed. Is there any other way to design XDM Schema for this type of data ?

 

Thanks,

Vamsi Kalakuntla.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by VaniBhemarasetty

@vamsik  You can run SQL queries in AEP for that 2-3 IDs and see all the records. Here is the documentation on Query services

 

https://experienceleague.adobe.com/docs/experience-platform/query/home.html?lang=en#:~:text=Adobe%20Experience%20Platform%20Query%20Service,into%20Real%2DTime%20Customer%20Profile.

 

1 reply

VaniBhemarasetty
VaniBhemarasetty
Employee
March 27, 2023

@vamsik Create one Profile Schema with Person ID as the primary identity and Account ID as the secondary identity, If you are creating profiles, you can ingest both the tables into one schema itself, it doesn't matter even if one person ID has multiple account IDs. In profile, you can see that one personID has 2 - 3 account IDs

    V
    VamsikAuthor
    New Participant
    March 27, 2023

    Thanks for the reply @vanibhemarasetty You are right, we are able to see that one personID has 2-3 account IDs, but we are not able to view the data corresponding to all those 2-3 account IDs, like for example say we want account_type for all the 2-3 account ID's. We are able to see only one account_type value in the attribute section of the profile. Is there any workaround for this ?

    VaniBhemarasetty
    VaniBhemarasettyAccepted solution
    Employee
    March 27, 2023

    @vamsik  You can run SQL queries in AEP for that 2-3 IDs and see all the records. Here is the documentation on Query services

     

    https://experienceleague.adobe.com/docs/experience-platform/query/home.html?lang=en#:~:text=Adobe%20Experience%20Platform%20Query%20Service,into%20Real%2DTime%20Customer%20Profile.

     

      Terms & ConditionsAccessibility statement

      Loading footer...