We would begin to use WinCCOA with influxDB in systems that were using Oracle Server 12 Databases, without migrating the Data stored on OracleDB?
Is it possible to have a system with coexistence of two database systems (oracle Server 12 and InfluxDB)?
On a given system, we have some subsystems (4 - 8 approx) working with Oracle Server 12, and we would like to add more subsystems (similar to the precedent subsystems) using InfluxDB system (20 - 40 approx). Would it be possible?
Do you think it would be possible to configure such an hybrid system within WinCCOA by maintaining the data consistency?
What would you recommend? Work with a hybrid system (old oracle + new influxdb) or migrate all the data from Oracle to influxDB?
In case of migration, could it be veriefied the data consitency between the winccoa data sotred in the oracle databases and the migrated data from oracle to influxdb?
Many thanks for your help,
Coexistence of Oracle Server 12 DB and InfluxDB
- mrosanes
- Posts:5
- Joined: Wed Mar 04, 2020 10:01 am
Coexistence of Oracle Server 12 DB and InfluxDB
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: Coexistence of Oracle Server 12 DB and InfluxDB
Right now a parallel usage of NGA archiving using an InfluxDB and RDB archiving using Oracle is not possible in a WinCC OA system.
In a distributed system you can use in one system NGA archiving and in another one RDB archiving.
Please take into account that the direct read will then not be able to read data from both databases.
Best Regards
Leopold Knipp
Senior Support Specialist
In a distributed system you can use in one system NGA archiving and in another one RDB archiving.
Please take into account that the direct read will then not be able to read data from both databases.
Best Regards
Leopold Knipp
Senior Support Specialist
- gschijndel
- Posts:376
- Joined: Tue Jan 15, 2019 3:12 pm
Re: Coexistence of Oracle Server 12 DB and InfluxDB
Yes, with a NGA Oracle backend it would be possible.mrosanes wrote: ↑ Thu Mar 12, 2020 10:53 am Is it possible to have a system with coexistence of two database systems (oracle Server 12 and InfluxDB)?
When a NGA Oracle backend is available, it should be able to read data stored by the RDB Oracle.What would you recommend? Work with a hybrid system (old oracle + new influxdb) or migrate all the data from Oracle to influxDB?