Expand my Community achievements bar.

SOLVED

Schema / Table Usage

Avatar

Level 3

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

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Community Advisor

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-for...

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

 

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-oper...

 

Regards,

ParthaSarathy S