Excel Reports using RDB

[nmnogueira]

I am using WinCC OA 3.14 P008 with HDB/RDB Parallel.

When using Excel Report, how can I force the values to be read from RDB? If HDB is not running, no values are returned.

[leoknipp]

right now there is no possibility to define which source (RDB, HDB) the data manager shall use when reading historical values.
When using HDB/RDB parallel data from the Oracle database can be read with the option queryRDBDirect = 1, e.g. for a user interface manager.

Why should the HDB manager not run in your system?
If the manager is stopped it is automatically restarted by the process monitor.

Best Regards
Leopold Knipp
Senior Support Specialist

[nmnogueira]

The Oracle RDB is used for long term archiving, so there might be data that is available in RDB which is not available in HDB.
When using a user interface, I have configured queryRDBDirect = 1 so the data is read correctly from the RDB. Is it possible to do the same for the Excel Report, or does it always read the values from HDB?

[leoknipp]

I've tested it. It seems that the option queryRDBDirect is not supported by the Excel-report/COM manager.
Querying data is always made via the data manager.

If data is stored in the Oracle DB you can read it with any tool which can access the database. That is a big advantage when storing data in an relational database. There is no need to use the Excel report.

Best Regards
Leopold Knipp
Senior Support Specialist

[nmnogueira]

OK, thanks.
Just to confirm, this means that if we use HDB/RDB parallel, the Excel Report tool can never access the data in the Oracle RDB, correct?

[Gertjan van Schijndel]

Not with the Excel-report/COM manager. But the excel can also access data directly from the (oracle) database (without the Excel-report/COM manager).