To fullfill a requirement from our ERP users, I have to extract the same information as I get if I use EDI FA Overdue Report. How can I collect this information so I can forward it to the ERP system. Can this be done with a SQL search in the WPG database ?
Does anybody know where I can get a data model of the WPG database.
Greg Brown 110000AWKG2 Posts
Re: SQL Access to WPG database2010-03-30T19:25:56ZThis is the accepted answer. This is the accepted answer.I was about to open a new thread on this, but my problem is very similar.
Our trading partners are very interested in daily reports detailing all of the files we've successfully received from the source trading partners, as well as the time at which they completed workflow processing & were submitted to the eventual destination trading partners. This information is viewable in the Document Viewer functionality of the BCG Console application, but we do not wish to give console access - security permissions would also preclude the ability of individual external trading partners to even access this information from the console, as the trading partners would be restricted to seeing the information they've submitted, not the results of processing performed by the internal partner entity & then submission to a different trading partner (e.g., only the internal partner or the hubadmin are able to perform these queries via the doc viewer).
Unfortunately, the document viewer does not have the functionality to export the results of a doc viewer query to a CSV or Excel file - and trying to take screen shots of each page of results for each partner is impractical.
I would like to execute SQL queries against the BCGAPPS DB, so that I can dump the full set of results to a file (either individual CSV files, or possibly something like a Crystal Report) which I would be able to submit on a daily basis to the trading partners (e.g., source trading partners would get a report of all files they submitted to us and the time which the file was made available to the eventual intended recipient, and destination partners would receive a report detailing all files which they were the eventual recipient of, and who sent them and at what time).
I'm looking for some documentation to aid me in this effort.
AvV 2000000BY4117 Posts
Re: SQL Access to WPG database2010-03-30T20:16:53ZThis is the accepted answer. This is the accepted answer.
- Greg Brown 110000AWKG
Hope this helps.
SystemAdmin 110000D4XK527 Posts
Re: SQL Access to WPG database2013-02-21T14:17:18ZThis is the accepted answer. This is the accepted answer.
- Greg Brown 110000AWKG