19.0 Database Configuration
Moab supports connecting to a database via native SQLite3, and it can also connect to other databases using the ODBC driver. Oracle support is forthcoming. These optional external databases store some additional information that the MongoDB database does not and allow you to query them directly using SQL. These databases are slower, however, and only SQLite3, which does not allow external queries, is supported.
The SQLite3 connection is for storing statistics. Consider reviewing the SQLite web page Appropriate Uses for SQLite for information regarding the suitability of using SQLite3 on your system.
While the ODBC connection is useful for storing statistics, it also stores events, nodes, and jobs. You can further configure Moab to store checkpoint information to a database rather than to the flat text file (.moab.ck) if you set the CHECKPOINTWITHDATABASE parameter to TRUE.
Connecting to an external database makes Moab more searchable, allowing you to run queries for statistics and events rather than using regular expressions to drawn the information from the Moab flat files.
- SQLite3
- Connecting to a MySQL Database with an ODBC Driver
- Connecting to a PostgreSQL Database with an ODBC Driver
- Migrating Your Database to Newer Versions of Moab
- Importing Statistics from stats/DAY.* to the Moab Database
Moab must use an ODBC-compliant database to report statistics with Viewpoint reports.