Using JasperReports, Crystal Reports or MS Excel with DCO

[DCIM_Support]

Hello,

Is it possible to use JasperReports, Crystal Reports or MS Excel with DCO database for building reports? What the supporting information is available, variables etc?

Thank you.

(CID:85885152)

[DCIM_Support]

Hi Andersen, we will look into it and get back to you as soon as possible.

(CID:85885158)

[DCIM_Support]

Data Center Operation: Insight which is an add-on module to Data Center Operation can be used to create reports. To read more about the Insight module please see http://www.apc.com/products/family/index.cfm?id=458 or here http://dcimcommunity.com/display/UAOp74/StruxureWare+Data+Center+Operation+-+Insight

If you have your own tool can you also utilize the webservices to get information from Data Center Operation. Another possibility is to create an ETL export database in Data Center Operation and then read data from this database. More information about webservices and export database can be found here: http://dcimcommunity.com/display/DCIMDEVELOPER/DCIM+Developer+Documentation

Thanks

(CID:85885160)

[DCIM_Support · Accepted solution]

This video tutorial is demonstrating use of ETL to extract data from MS Excel and inject in to StruxureWare Data Center Operation database:
http://dcimsupport.apc.com/display/73video/External+system+integration+through+ETL
You can use ETL to do the opposite - extract data from databases.

(CID:85885182)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.