Custom Table with new Target Mapping | Community
Skip to main content
kapilKochar
kapilKochar
Level 6
June 29, 2022
Question

Custom Table with new Target Mapping

  • June 29, 2022
  • 2 replies
  • 2262 views

Hi All,

 

Need some suggestion for below : 

A custom table say 'B' with new target mapping. This custom schema have no linking with recipient table. Also, while creating new target mapping  created new broad logs and tracking logs for this table using target mapping wizard.

 

Two challenges :

 

 

A) Services and Subscriptions

As per this doc(Using a custom recipient table has the following limitations:)

if we using custom table with no link rcp table then we can not use OOB services. What's the alternate way? 

B) OOB quarantine and blacklist

Will OOB quarantine and blacklist logic will work with custom table ?(I could not find any document for this one)

 

Thanks

 

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

2 replies

C
Adobe Employee
costa_n11Adobe Employee
Adobe Employee
June 29, 2022

Hi @kapilkochar 

 

If you look at the Target Mapping configuration you will see a series of field you can set to manage the standrd exclusion it is done via DenyList

In your B data schema, you must allow to capture these fields and of course you need to have a field to capture the email address. For ease, you could name these fields same as in nms:recipient

 

 

The new entity has its own Delivery, Exclusion, and Tracking Logs schema as expected.

 

DESIGN CAUTION:

1- Avoid to have a composite fields as a PK, although it does work, for very large table, this is definitively not the most performant design. Use a single field for your PK

2- Since a single PK field is strongly advised, please name it simply "id", otherwise, the billing workflow might fail. It did in the past, so better to play safe. ideally you will use autopk AND a custom sequence, do not use the standard xtkNew as a sequence if you decide to go with autoPk... You will get into trouble once the sequence expires...

 

As for the subscription, it is true that Subscription (nms:subscription) is very much tight up to Recipient () and you will have to replicate it for your new B schema and using pre-defined filters you should be able to provide similar features...

 

Hope this helps,

Thanks

Denis

    kapilKochar
    kapilKocharAuthor
    Level 6
    June 29, 2022

    Hi @costa_n11 ,

     

    Appreciate your prompt response. Also, thanks for sharing the best practice. 

    I have created a table with autopk="true" , but as per the requirement I need to create composite key as well which will be the combination of 2-3 fields. Will that something you reckon call for an issue? 

     

    Also, For Subscription, Do we have any documentation around that?

    Have you done similar to this before ? Any specific challenges around that as per your experience in terms of managing subscription table and all ? or is this straightforward.  

    C
    Adobe Employee
    costa_n11Adobe Employee
    Adobe Employee
    June 29, 2022

    Hi @kapilkochar 

    You can create an unique index with your 2-3 fields if required, the trick will be that anytime you want to reconcile using these 3 fields, you would have to ensure you use the fields in the Join clause in the same order than in the index definition otherwise the index won't be used...

     

    For custom sequence, you could look at the documentation https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/data-model/data-model-best-practices.html?lang=en#custom-internal-keys:~:text=reference%20in%20workflows.-,Sequences,-Adobe%20Campaign%20primary

     

    As for subscription, I haven't done it personally and it would be a matter to replicate the entity nms:subscription and create pre-defined filters similar to the ones provided

     

     

     

    Hope this helps,

    Thanks

    Denis

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      November 23, 2022

      Hi @kapilkochar,

      Were you able to resolve this query? If yes, then kindly share the solution to help the rest of the community as well. 

      Thanks

      Sukrity Wadhwa
        Terms & ConditionsAccessibility statement

        Loading footer...