Skip to content
+1-888-319-3663

COMMUNITY FORUM

Logging Tables in SmartConnect

Peter Kwasnicki asked 6 years ago
We are working on some SmartConnect integrations from a SQL table to GP, and the customer wants a customized web front-end to show the various logging data from SmartConnect, such as Date Run, Run #, Success/Fail, Key Data Fields, Error information, GP Company, etc. Are you able to provide information on the SQL tables that we can pull this information from and their relationships/keys? Taking a look it appears that the TraceHeader and TraceLine tables have most of this information.
Thanks,
Peter
Answers
Lorren Zemke Staff answered 6 years ago
Peter,
There is a view called SmartConnect_Trace within the SmartConnect database that you could query, which use the TraceHeader and TraceLine tables. With our 20.15 release we have created a SmartConnect Web Client that provides a Dashboard view as well. You can see a quick blog article on this new feature. http://www.eonesolutions.com/blog-post/tech-tuesday-hello-side-introducing-web-client-smartconnect/
 

If you would like to submit an answer or comment, please sign in to the eOne portal.