File System Event Logger Repository

The default repository type is SQLite, it works very well with a small amount of data. For high-load systems, we recommend using different database type

Supported Repository Database Types

  • SQLite
  • Postgres
  • MySQL
  • MariaDB
  • Microsoft SQL Server
  • Oracle

Changing Repository Type

  • Set ENABLE_SECURITY=0
  • Set RUN_SQL_SCRIPTS=1
  • Set Set CONNECTION_TYPE, DB_USER, DB_PASS, DB_NAME, DB_HOST, DB_PORT, DB_INSTANCE to appropriate values
  • Restart File System Event Logger
  • Recreate/Enable Groups
  • Recreate/Enable Users
  • Set ENABLE_SECURITY=1
  • Restart File System Event Logger

Backing Up Repository

Backing Up Repository

Restoring Repository

Restoring Repository

Confused? Ask question on our ETL Forum

Posted on April 5, 2022 • 1 min read • 104 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License