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