Schema / Table Usage | Community
Skip to main content
ukender
ukender
Level 3
September 3, 2020
Solved

Schema / Table Usage

  • September 3, 2020
  • 2 replies
  • 1194 views

Dear All

 

How to identify the usage of schema / table?

Example,

We have custom data schema which is creating a sql table, but we are unsure how the data is loaded to the table. We were not able to find the WF or WebApp is using the particular schema / table. 

 

Cheers

Ukender

 

 

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 Jonathon_wodnicki

Hi,

 

If the table has audit trail cols, you can use those to correlate modified times against workflow times.

Otherwise, use the data schema view for xtk:workflow, nms:webApp to see across the system for potential causes.

 

Thanks,

-Jon

2 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
September 3, 2020

Hi,

 

If the table has audit trail cols, you can use those to correlate modified times against workflow times.

Otherwise, use the data schema view for xtk:workflow, nms:webApp to see across the system for potential causes.

 

Thanks,

-Jon

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    September 15, 2020

    Hi @ukender ,

    You can load data into your custom schema/table in 2 simple ways.

    1) By Creating an input form:

    You can create an input form for your custom schema and add data into it.

    Creating Input form: https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/input-forms/form-structure.html

    Creating Navigation hierarchy: https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/navigation-hierarchy/about-navigation-hierarchy.html

     

    2) By Using Import workflow:

    If you have data for your custom table in a file, You can create an import workflow and insert/update the data into your custom schema..

    Refer the link: https://docs.adobe.com/content/help/en/campaign-classic/using/automating-with-workflows/general-operation/importing-data.html

     

    Regards,

    ParthaSarathy S

     ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...