To connect ibaAnalyzer to an SQLite database, you do not need to make any special settings on the database side.
Note |
|
|---|---|
 |
ibaAnalyzer v8.0.0 or higher no longer supports any database connections via ODBC. Databases that have been configured in older PDO files via ODBC must be converted to the actual database provider in ibaAnalyzer and directly connected to the database. |
From the Data source drop-down list, select Create database connection. In the Database connection dialog box, select the required database provider under Database type.
To edit an existing connection, select the connection from the Data source drop-down list. Then click on the editing button.
Enter the other settings.
Connection name
This line contains the name of the database connection. The name is automatically formed and entered according to the scheme username@database as soon as you have filled in the fields below. Alternatively, you can enter and overwrite the connection name manually.
SQLite file
Enter the path to the database in this field or select the database using the browser button.
Create DB file if it is missing
If no SQLite database exists, enable this option. ibaAnalyzer then creates a corresponding database.
<Test connection>
ibaAnalyzer checks the access to the selected database on the set DB server. If the connection is successful, the message includes the version of the database.