[ Up: Operation Reference ]

Opens an SQL database, allowing downstream operations to interact with it. The number and format of the operation's parameters and the behavior of the operation is dependent on the SQL Database and Driver being used. You may need to refer to the database's documentation for additional information. For example, depending on the database driver, this operation may create a new database file where the input database file does not exist before opening it.

Default label: "Open SQL Database"
Member of plug-in: Data analysis
Catalogue path: Database

Inputs:
Driver	QString	The database driver to use, e.g. "QSQLITE". Available drivers differ depending on platform.
Host name	QString	Hostname indicating where the database management server is running.
Database name	QString	The name of the database to open. Must match the name of a database in the DBMS pointed to by the "Host name" input.
User name	QString	The username of the account used to access the database.
Password	QString	Password required to access the database. NOTE: The password is not encrypted when saved, so be careful here.
Outputs:
Database	QSqlDatabase