Schema / Table Usage

Avatar

Avatar
Validate 1
Level 1
ukender
Level 1

Likes

0 likes

Total Posts

33 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Applaud 5
Affirm 1
View profile

Avatar
Validate 1
Level 1
ukender
Level 1

Likes

0 likes

Total Posts

33 posts

Correct reply

1 solution
Top badges earned
Validate 1
Give Back
Applaud 5
Affirm 1
View profile
ukender
Level 1

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

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
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)

Avatar

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

42 likes

Total Posts

66 posts

Correct reply

30 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile

Avatar
Affirm 5
Level 4
ParthaSarathy
Level 4

Likes

42 likes

Total Posts

66 posts

Correct reply

30 solutions
Top badges earned
Affirm 5
Establish
Give Back
Boost 5
Boost 3
View profile
ParthaSarathy
Level 4

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