0

I have to analyze the Confidence levels per Job/Document/Field for "KOFAX Total Agility". I need to pull data from the Jobs, JobHistory tables of the [TotalAgility] database down to the Documents and Field tables of the [TotalAgilityDocuments] database. This is for requested analysis.

There's a doc on some of the TotalAgility tables but I can't find anything else on the other KOFAX TotalAgility included Databases.

I'm looking for the join information or ideally an ERD on the two databases for Kofax TotalAgility.

Thanks! Bob

bobweber
  • 1
  • 1
  • This is something that Kofax Analytics for TotalAgility (KAFTA) should deliver out of the box: https://www.kofax.com/Products/process-intelligence/analytics-for-totalagility – Wolfgang Radl Apr 28 '20 at 17:15
  • Thank you @WolfgangRadl, Unfortunately, I have to consolidate reporting using PowerBI and upper management decided that product wouldn't be 'viable'. l – bobweber Apr 29 '20 at 03:58
  • hey Bob, did you find a way to do that? – Mohamad A Sallal Sep 20 '21 at 19:51
  • Not a performant way... :/ From TotalAgility.[dbo].JOB (NOLOCK) fj JOIN TotalAgility.[dbo].VARIABLE (NOLOCK) fjv ON fj.JOB_ID = fjv.OWNER_ID JOIN TotalAgility_Documents.[dbo].Document (NOLOCK) Exported on ParentId = CAST( fjv.VAR_VALUE as xml).value( '(FolderVariableValue/InstanceId)[1]', 'varchar(50)')
    the xml call is the most expensive.     – bobweber Oct 12 '21 at 15:03

0 Answers0