Schema / Table Usage

ukender

02-09-2020

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

 

 

A

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

03-09-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

Answers (1)

Answers (1)

ParthaSarathy

15-09-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-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