Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Schema / Table Usage

ukender
Level 2
Level 2

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
1 Accepted Solution
wodnicki
Correct answer by
Community Advisor
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
wodnicki
Correct answer by
Community Advisor
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

ParthaSarathy
Level 5
Level 5

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