Coexistence of Oracle Server 12 DB and InfluxDB

Discussion about recent product features & solutions!
3 posts • Page 1 of 1
mrosanes
Posts:5
Joined: Wed Mar 04, 2020 10:01 am

Coexistence of Oracle Server 12 DB and InfluxDB

Post by mrosanes »

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,

leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: Coexistence of Oracle Server 12 DB and InfluxDB

Post by leoknipp »

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

gschijndel
Posts:376
Joined: Tue Jan 15, 2019 3:12 pm

Re: Coexistence of Oracle Server 12 DB and InfluxDB

Post by gschijndel »

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)?
Yes, with a NGA Oracle backend it would be possible.
What would you recommend? Work with a hybrid system (old oracle + new influxdb) or migrate all the data from Oracle to influxDB?
When a NGA Oracle backend is available, it should be able to read data stored by the RDB Oracle.

3 posts • Page 1 of 1