Middleware consolidate Symposium Reports

[jadiebear]

Does anybody know if there is a third party vendor software that can consolidate all the Symposium reports into a single report. Our sales department needs ONE single place to have all their data eack week without having to run multiple reports.

Any help would be appreciated.

 

[ff7121]

Nortel provide full access to Symposium Sybase database for creating any custom user-defined report with Crystal report software helping.
Document Historical_Reporting.pdf from NTP contain all instructions and samples for creating and working with custom user reports.

 

[Supernn]

You have to use a seperate SQL server, in which you collect all Symposium data (via DTS packages) after which you can do whatever you want with the data.
Please bare in mind that the transformation of any data has an impact on your SCCS machine and the network traffic, so schedule this during low traffic hours.

 

[jadiebear]

Thank you both for informative responses.