Schema / Table Usage

[ukender]

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

[Jonathon_wodnicki · Accepted solution]

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]

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