Export to Database Module

[t_bidaud]

Hello,

I work on Arduino module and I would like to export the Cnlnum ; Stat & Val on a database.
I would like to connect the current.dat to my oracle database with the Export database Module.
I try to connect with Modules_ModBDExport.dll. But I don’t understand where I use the connection string and when I use the sql queries.
Thank you for your help.

Theofane Bidaud

[Mikhail]

Hi,
You should create a new database connection in the module properties form and paste SQL requests for this connection.
What is the particular question?

[t_bidaud]

I don’t understand where I connect the database in SCADA Serveur _ Modules _ ModBDExport.dll _ Connection.
And when I write the SQL code in documentation.

[Mikhail]

1. Go to the Modules page
2. Click the Add (+) button
3. Add ModDBExport.dll and apply the settings.
4. Select the module and click the Properties button.

[t_bidaud]

I chose Oracle in Add data source
In connection I have :
Serveur localhost
Database test_bdd.sql
User t_bidaud
BDD123
Connexion String
Server=localhost/test_bdd.sql;UserID=t_bidaud;Password=BDD123

And in Current Data I check Export and I put in SQL window the SQL code in documentation.

But I have any new line in my Oracle database after.

[Mikhail]

You should provide screenshots of the module settings and log of the export module.

[t_bidaud]

Hi,

I send you an email with screenshots

[t_bidaud]

Hi,

This is the screenshot:

[Mikhail]

Hi,
In the Current Data tab you need to enter INSERT request only. Other SQL scripts are needed for creating the database.

[t_bidaud]

Hi,

Ok i did it, I put the insert command in current, archive & event.
I create a data base with the other command.
But when I try SELECT * FROM clndata; I have nothing.
I forced to use mysql.
Thank you for your helping

[Mikhail]

Hi,
You should check the log file of the module to find the cause.
MySQL is owned by Oracle Corporation ))

[t_bidaud]

Hi,

I able to tranfert data with the generator.
But I can’t sent automatically data from server

[Mikhail]

Hi,
You should describe in details what you did, what you get and what you expect.

[t_bidaud]

Hi,

I have configured the connection with my data base

I want to upload in my data base the current dta from the scada server.
When I use the generator I recieve just one data

I want to recieve data/min.
Thank you for your helping

[Mikhail]

Hi,
Thank you for the screenshots.
Do the data are successfully stored in your database when you use Generator?

[Author]

Posts