Schema / Table Usage

Question

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 Answer

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

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-forms/form-structure.htmlCreating Navigation hierarchy: https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/navigation-hierarchy/about-navigation-hierarchy.html 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-operation/importing-data.html Regards, ParthaSarathy S

Sign up

Login with SSO

Login to the community

Login with SSO