Migration of WinCCOA data from Oracle Server 12 DataBase to InfluxDB

mrosanes · Post by **mrosanes** » Thu Mar 12, 2020 10:39 am

Hi WinCC community,

We would like to know how to migrate existing Migration of WinCCOA data from Oracle Server 12 DataBase to InfluxDB.

Do you know if there is an easy way of migrating data from an Oracle Server 12 DB to an InfluxDB system?
We have some Oracle systems and we would like to migrate its data to the InfluxDB system:

- Is it feasable?
- How could this be done in an easy way?
- Could we verify the data consistency in some way (e.g: by using the Anti-Entropy from InfluxDB-EE)?

kilianvp · Post by **kilianvp** » Thu Mar 12, 2020 4:08 pm

Currently there is no automatic way to migrate from oracle to influx. The InfluxDB Enterprise edition is not officially supported.

c.fraenzer · Post by **c.fraenzer** » Mon Aug 10, 2020 9:20 pm

If you have some programming skills i can reccomend you this connector

https://github.com/influxdata/influxdb-client-csharp

with this writing to influx is easy. You would need to sort youre data a bit though since storage method in influx differs greatly from oracle

adaneau · Post by **adaneau** » Tue Aug 11, 2020 10:28 am

Hi,

Do you plan to migrate Oracle to Influx as usable WinCC OA data?

If yes a simple tool as the above connector or anything from Influxdb directly will most likely not be enough. I would advice you the following:

On engineering station migrate your actual project to 3.17 with influx so you will be able to see all the required data structures in influx (fields and tags in use). When you know how the data has to be structured, then you can go with some client of your choice to connect oracle, format data and write into InfluxDB.

I am not Oracle expert but if you can get some csv out of oracle, you can probably format them to fit Influx and import them using native InfluxDB client in command line.

Cheers
Alexandre

Features / Solutions