Connect to a file-based database
File-based databases such as SQLite, H2, and Microsoft Access store data in a local file rather than on a server. Use a dedicated file-based connector node to connect to them.
Before you begin
- Identify the database file location on disk, or decide to use an in-memory database if supported.
- Confirm that a dedicated connector node exists for your database. Supported file-based databases include SQLite, H2, and Microsoft Access.
Connect to the database
Configure the file-based connector node to establish the connection.
- Add the connector node for your database (for example, H2 Connector) to the workflow.
- Click the node once to open its configuration.
- Under Location, select the Location type:
- Path — click the browse button and select the database file on disk.
- In-memory — enter a Database name for a temporary database stored in memory (available only for databases that support this option).
- Optionally, expand Show advanced settings to configure the database dialect, driver, or other advanced options.
- Click Apply and Execute to save the configuration and execute the node.