DbView Database visualization

Database adaptor

A database adaptor is a peace of software that is used as an interface with a given database.

Currently, DbView supports the following databases:

You can get the list of supported databases by typing the following command line:

dbview.bat list-db-adaptors

dbview.sh list-db-adaptors

For information:

The database adaptors are stored in a JAR file: extensions\databaseAdaptors.jar.
Database adaptors use JDBC type 4.
Adding a new database adaptor is made easy if you know Java. Basically, you create a new package for the new adaptor, and you create four classes named "Cli.java", "Configuration.java", "Description.java" and "Loader.java".

This adaptor accepts the following configuration parameters:

Name	Description	Mandatory?	Default
host	Name of the host that runs the MySql server.	Optional	`localhost`
user	Name of the user used for authentication.	Optional	`root`
password	Password used for authentication.	Optional	No password
port	Port number used by the MySql server to listen to incoming network connections.	Optional	`3306`
dbname	Name of the database.	Mandatory
fkmatcher	Name of the soft foreign key matcher to apply.	Optional	If no foreign key detector is specified, then no detector is used.

You can get the help for this adaptor by typing the following command:

Windows:

dbview.bat help-db-adaptor mysql

Mac OS and linux:

dbview.sh help-db-adaptor mysql