Configuring a DB Data Source
Configuring a DB data source involves the following general activities:
To specify general DB data source settings
- Open the Data Sources and Drivers dialog by doing one of the following:
- Specify the name of the data source.
Specify the data source scope (level). From the Scope list, select:
- Project if the data source should be available only in the current project.
- IDE if the data source should be available in all of your projects.
To specify JDBC driver files and class
On the Database tab of the Data Sources and Drivers dialog,
use the controls under JDBC driver files to specify the JDBC driver files to be used:
- To download the necessary driver files from the Internet, or to use the driver files associated with a different data source, select the corresponding option from the list.
- If the corresponding driver files are available locally on your computer, click (Shift+Enter) and select the driver file location(s) in the dialog that opens.
- From the JDBC driver class list, select the necessary driver implementation class. (The list includes all the driver classes detected in the specified driver files.)
To specify the database access settings
- In the Database URL field, specify the database URL.
- In the User and Password fields, specify your database access credentials.
- If, to access the database, you are going to use SSH, click Configure SSH and specify the associated settings in the Configure SSH Tunnel dialog that opens.
To test the connection with the database
To make sure that the database connection settings are correct and
IntelliJ IDEA can communicate with the target database, click the Test Connection button.
For IntelliJ IDEA to establish the connection with the database, the corresponding database server must be up and running.
To download the database tables
To get access to specific tables
To configure the behaviour of the Database Console
To view and edit advanced connection properties
- In the Advanced tab of the Data Sources and Drivers dialog box, update the contents of the Value text box next to the names of the relevant connection properties.
Last modified: 12 November 2014