Algorius Net Viewer Manual | Database
Algorius Net Viewer stores in the database the following information:
Database initialization (tables and indices creation) is performed automatically at the first access to the database.
Records are logged in the background. The recording is done transactionally, mass, using prepared parameterized query. This ensures a high efficiency: more than 5,000 records per second can be added into a local database on a computer of the average performance (Core i5).
To configure database, select File→Options from the main window menu, or press the Options button on the toolbar or press F9. The Options dialog box will appear. Select the Logging tab:
The following parameters are available:
- Database — database type. There are various database connection settings depending on database type.
- Database file — only for internal (SQLite) database. By default, the logs are stored in internal database in the folder of operation system user. You can specify location of the file with internal database. This ability lets you to store database on a high-speed drive to increase performance. If you need to transfer a database, just copy Log.db file to required location and specify this location in application settings. Afterwards you can delete old Log.db if it is no longer needed.
- Server — only for Oracle, MS SQL, MySQL, PostgreSQL databases — name of a server, where database is hosted. Please enter host name or IP for Oracle, MySQL, PostgreSQL. For MS SQL please enter database server name according to MS SQL settings, for example: SERVER_NAME\SQLEXPRESS
- Port — only for Oracle, MySQL, PostgreSQL databases — network port to connect to database. Reset button changes port number to default value for a selected database.
- Authentication — the authentication method on the SQL server. If Windows Authentication is selected, the Windows user authentication is used. If SQL Server Authentication is selected, the SQL server login is to be specified.
- Username/password — only for MS SQL, Oracle, MySQL, PostgreSQL databases — the login used to gain access to the database. Available only if SQL Server Authentication is selected.
- Database name — only for MS SQL, MySQL, PostgreSQL databases — name of a database to create tables to store application data.
- Service name — only for Oracle database — service name of a database according to Oracle settings, for example: XE
- Connection string — only for ODBC databases — DNS to connect to external database via ODBC. ODBC access to databases is enabled via ODBC driver. Manufacturers of almost every database deliver the appropriate ODBC driver. Below there are the download links for ODBC drivers of the most popular databases. In the Connection string you should choose DSN, that is configured in the "ODBC Data Source Administrator" application, which is included in Windows.
- Check connection — check database connection by specified connection settings.
- Enable monitoring log — enables the Monitoring Log. In case you don’t need this function, you can disable it to save some disk space and decrease the processor load. It’s also recommended to disable monitoring log in case your security policy doesn’t allow it.
- Optimize to hourly/daily stats — when you add entries, which are older than the specified number of days, in the monitoring log, they will be converted to statistical information. See Monitoring Log for more information.
- Enable inventory log — enables the Inventory Performing Log. In case you don’t need this function, you can disable it to save some disk space and decrease the processor load.
- Enable Web access log — enables the Web access log. In case you don’t need this function, you can disable it to save some disk space and decrease the processor load.
- Keep records for the specified number of days — when enabled, Algorius Net Viewer will automatically remove all records older then the number of days defined here. This saves space in the database and speeds up report generating by reducing the number of processed records. This option is applied only for enabled logs.
- Enable Operative monitoring log – when turned on, the operative monitoring log is maintained for the specified number of hours.
Export is used to upload information from a database to a file to create a backup copy and transfer it to another database.
To export the contents of the database, select Tools→Database Export in the main window menu. The Database Export window opens:
Choose the data you want to export from the database and select the file to be exported. In the next step, the selected data will be uploaded to the specified file.
Import is used to load information into the database from a file to restore from a backup copy or transfer from another database.
To import the contents of the database, select Tools→Database Import in the main window menu. The Database Import window will open:
Select the file from which to import. The selected file will be analyzed and checked for possible errors in the structure. Select the data you want to import. Only those data are available, information on which is present in the specified file, i.e. was uploaded during export.
Attention! In the next step, the selected data will be deleted from the database. After that, records from the file will be imported. It is recommended to export the database before importing (to create a backup copy). See Database Export for more information.