Export to SQLite

Forum Home Forums Development and Integration Export to SQLite

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #8340
    AvatarMatt3
    Participant

    Hi Mikhail

    I’m using the hello world project.
    I’m looking for some guidance on how to configure an SQLite database so that it receives current data? Also. the most suitable folder to place the db file.

    My settings are:

    Connection tab
    Server = localhost
    Database = MySqliteDatabase
    Username = <empty>
    Password = <empty>
    Connection string = Data Source=C:\SCADA\ScadaWeb\custom\MySqliteDatabase.db;Version=3

    Current data tab
    INSERT INTO LogData (DateTime, CnlNum, Val, Stat)
    VALUES (@dateTime, @cnlNum, @val, @stat)

    The above settings are not working since the database is not populated with data.

    Kind regards
    Matt

    #8354
    MikhailMikhail
    Moderator

    Hi,

    DB Export Module natively supports MySQL, PostrgeSQL, MS SQL and Oracle.

    There is a chance that it’s possible to use Sqlite with help of OLE DB provider. To check it, you need to try setup a connection by Server Explorer of Visual Studio and then copy a connection string.

    #8355
    MikhailMikhail
    Moderator

    I think you should choose one of the native supported databases.

    #8370
    AvatarMatt3
    Participant

    Ok, thanks. We can install SQL Server on the machine so we will go with this option.

    Also, I would like to save the current data to the database at, say 1 or x minute intervals in the format

    <index> <datetime> <channel 101> <channel 102>…. <channel n>
    <index> <datetime> <channel 101> <channel 102>…. <channel n>
    <index> <datetime> <channel 101> <channel 102>…. <channel n>
    <index> <datetime> <channel 101> <channel 102>…. <channel n>


    What is the best way to do this?

    Thanks
    Matt

    #8375
    MikhailMikhail
    Moderator

    SQL requests are executed by the module every time when data are sent from Communicator to Server. So the logic to store data with particular interval should be implemented on the DB level.

    However, in 2021 we plan to release an update of DB export module to be able to upload Rapid SCADA historical archive to a DB. This feature may be useful in your case.

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.