Export to Database Module

Forum Home Forums Development and Integration Export to Database Module

This topic contains 24 replies, has 3 voices, and was last updated by Mikhail Mikhail 2 months ago.

Viewing 15 posts - 1 through 15 (of 25 total)
  • Author
    Posts
  • #3981
    Avatar
    t_bidaud
    Participant

    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

    #3982
    Mikhail
    Mikhail
    Moderator

    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?

    #3983
    Avatar
    t_bidaud
    Participant

    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.

    #3992
    Mikhail
    Mikhail
    Moderator

    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.

    #3995
    Avatar
    t_bidaud
    Participant

    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.

    #3997
    Mikhail
    Mikhail
    Moderator

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

    #4002
    Avatar
    t_bidaud
    Participant

    Hi,

    I send you an email with screenshots

    #4003
    Avatar
    t_bidaud
    Participant

    Hi,

    This is the screenshot:

    #4004
    Mikhail
    Mikhail
    Moderator

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

    #4031
    Avatar
    t_bidaud
    Participant

    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

    #4039
    Mikhail
    Mikhail
    Moderator

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

    #4043
    Avatar
    t_bidaud
    Participant

    Hi,

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

    #4044
    Mikhail
    Mikhail
    Moderator

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

    #4045
    Avatar
    t_bidaud
    Participant

    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

    #4054
    Mikhail
    Mikhail
    Moderator

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

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic.