Database connection

Amazon Redshift

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Amazon Redshift.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Connection type list, select a type of connection that you want to use:

   • Default: connect by using Host, Port, and Database.

   • IAM cluster/region: connect by using Database, Region, and Cluster.

   • URL only: connect by using the JDBC URL that you can copy in settings of your Amazon Redshift cluster.

5. From the Authentication list, select an authentication method.

   • pgpass: by using the PGPASS file. You can store this file in the user's home directory (for example, /Users/jetbrains/.pgpass). You can read more about the password file in The Password File at postgresql.org.

   • User & Password: by using your login and password.

   • AWS profile: by using a named profile. A named profile is a collection of settings and credentials that you can use for authentication. Named profiles are stored in CREDENTIALS files. Default directories for these files are ~/.aws/credentials (Linux and macOS) and %USERPROFILE%\.aws\credentials (Windows).

6. In your Redshift dashboard, create a Redshift cluster.

   For more information about the Amazon Redshift cluster, read Getting Started with Amazon Redshift.

7. In settings of the Redshift cluster, copy the JDBC URL.

8. Paste the JDBC URL from the Redshift cluster settings to the URL field in WebStorm.

9. In User and Password fields, specify your Redshift credentials.

10. To ensure that the connection to the data source is successful, click the Test Connection link.

Apache Cassandra

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Apache Cassandra.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Apache Derby

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Apache Derby.

3. From the Driver: list, select the type of the JDBC driver that you want to use. For remote connections, select Apache Derby (Remote). For embedded databases, select Apache Derby (Embedded).

4. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

5. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

Apache Hive

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Apache Hive.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Azure SQL Database

Microsoft Azure supports PostgreSQL, MySQL, MariaDB, and other Database Management Systems (DBMS). If you want to connect to these data sources, create data source connections that correspond to these DMBS. In WebStorm, these connections already include necessary JDBC drivers. So, if you want to connect to the Azure database for PostgreSQL, create the PostgreSQL connection.

1. In your Microsoft Azure account, create an SQL data source. For more information about the Azure SQL Database, read Azure SQL Database documentation at docs.microsoft.com.

2. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

3. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Azure SQL Database.

4. At the bottom of the data source settings area, click the Download missing driver files link.

6. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

To use Azure Active Directory Authentication, select Azure Active Directory password from the Authentication list. You might need to download additional libraries for Active Directory Authentication. To use SQL authentication, select User & Password.

7. To ensure that the connection to the data source is successful, click the Test Connection link.

BigQuery

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Azure SQL Database.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. Specify information about the project to which you want to connect.

   • Project ID:: a unique identifier for your project.

   • OAuthType:: an option that specifies how the driver obtains or provides the credentials for OAuth 2.0 authentication. You can select between the following options:

     • Google Service Account: authenticate the connection with a Google service account. In the URL field, add the following options: OAuthServiceAcctEmail (a Google service account email address), OAuthPvtKeyPath (the full path to a private key file for the service account), and OAuthType=0. Consider the following example JDBC URL.

       jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443; ProjectId=ConnectToBigQuery; OAuthType=0; OAuthServiceAcctEmail=my_google_service_account@connect-to-bigquery.iam.gserviceaccount.com; OAuthPvtKeyPath=/Users/jetbrains/DatagripProjects/keyFile.p12;

     • Google User Account: authenticate the connection with a Google user account. You must provide your Google user account credentials to connect to the server.

       jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443; ProjectId=ConnectToBigQuery; OAuthType=1;

     • Pre-Generated Access and Refresh Tokens: authenticate the connection using access or refresh tokens that have already been generated from the Google Authorization Server. In the URL field, add the following options: OAuthAccessToken (an access token), OAuthClientId (a refresh token), OAuthClientSecret (a client secret), and OAuthType=2. If you are using a refresh token, set the OAuthClientId property to to your client ID and set the OAuthClientSecret property to your client secret. For more information about tokens, see Using OAuth 2.0 to Access Google APIs at developers.google.com.

       jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443; OAuthType=2; ProjectId=ConnectToBigQuery; OAuthAccessToken=FI1vf0PSMMu9; OAuthRefreshToken=@3GANwIJk2n3lk3n5g2k45; OAuthClientId=234k5j23l4kf; OAuthClientSecret=lkegjle+2435mn;

     • Application Default Credentials: authenticate the connection using credentials obtained through Application Default Credentials (ADC). For more information about ADC and how to obtain them, see Authenticating as a service account at cloud.google.com.

       jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443; OAuthType=3; ProjectId=ConnectToBigQuery;

6. To ensure that the connection to the data source is successful, click the Test Connection link.

ClickHouse

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select ClickHouse.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Couchbase Query

WebStorm supports the Couchbase Query Query service, not the Couchbase Query Analytics service.

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Couchbase Query.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   You can skip the port field or set the port number to 11210 that is the default port for the Couchbase Query Query Service.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Exasol

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Exasol.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Greenplum

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Greenplum.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Authentication list, select an authentication method.

   • pgpass: by using the PGPASS file. You can store this file in the user's home directory (for example, /Users/jetbrains/.pgpass). You can read more about the password file in The Password File at postgresql.org.

   • User & Password: by using your login and password.

5. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

H2

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select H2.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Connection type list, select the connection mode: Remote, In-memory, Embedded. For more information about these modes, see the official H2 documentation.

5. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

HSQLDB

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select HSQLDB.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

IBM Db2 LUW

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select IBM Db2 LUW.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Connection type list, select the connection mode that you want to use: Type 2 or Type 4. For more information about driver architectures, see the IBM documentation for IBM Db2 LUW.

   In the user interface, if compared to Type 2, Type 4 has Host and Port fields.

5. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

MariaDB

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select MariaDB.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Microsoft SQL Server

For more information about configuring Microsoft SQL Server, Windows domain authentication, and user permissions, see How to connect to MS SQL server in the WebStorm documentation.

For more information about connecting to LocalDB, see How to connect to SQL Server Express LocalDB in the DataGrip documentation.

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Microsoft SQL Server.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. (Optional) To use Azure Active Directory Authentication, you can select Azure Active Directory password or Azure Active Directory interactive options from the Authentication list.

   If you select the Azure Active Directory password option, you need to specify your username and password for the Azure Active Directory in User: and Password: fields, respectively.

   To authorize your connection from the browser, select Azure Active Directory interactive. In this case, you will be redirected to login.microsoftonline.com, where you need to authorize with your Active Directory (AD) account. Then the browser will send the authentication information to the IDE.

   You might need to download additional libraries for Azure Active Directory Authentication. To use SQL authentication, select User & Password.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

MongoDB

In MongoDB, for authentication, you must provide a username, password, and the authentication database that is associated with this username. If the authentication database differs from the database to which you want to connect, specify the authentication database with the authSource parameter in the URL. If no authentication database is specified, MongoDB uses the admin database by default.

For example, you want to connect to the local database but your authentication database is admin. In this case, the connection URL will look like: mongodb://localhost:27017/local?authSource=admin.

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select MongoDB.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Connection type list, select your connection type:

   • default: standard connection string format (for example, mongodb://localhost:27021/admin). Read more about standard connection string format in Standard Connection String Format at docs.mongodb.com.

   • MongoDB Atlas (SRV protocol): DNS seedlist connection format (for example, mongodb+srv://unit1.test.net:27121,unit2.test.com:27021). Read more about standard connection string format in DNS Seedlist Connection Format at docs.mongodb.com.

5. Specify database connection details: a login, a password, and the database that you want to connect to. To set an empty password, right-click the Password field and select Set empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

MySQL

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select MySQL.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Oracle

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Oracle.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Connection type list, select a connection type:

   • SID: to use a unique name of an Oracle instance (a process that runs on the workstation).

     To use a correct value, check the environment variable ORACLE_SID on the server host, or contact your database administrator. Commonly-used values are XE or ORCL.

   • Service name: to use an alias to an Oracle instance (or many instances).

   • TNS: to use tnsnames.ora configuration file. In the TNSADMIN field, specify a path to the folder with tnsnames.ora. In the TNS name field, specify what service name to use (see a value of net_service_name in tnsnames.ora) if you have more than one service.

     For more information about tnsnames.ora, see Local Naming Parameters in the tnsnames.ora file.

   • URL only: to use the JDBC URL.

5. From the Driver: list, specify the driver type. For more information about driver types, see Oracle JDBC FAQ.

6. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

7. To ensure that the connection to the data source is successful, click the Test Connection link.

PostgreSQL

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select PostgreSQL.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Authentication list, select an authentication method.

   • pgpass: by using the PGPASS file. You can store this file in the user's home directory (for example, /Users/jetbrains/.pgpass). You can read more about the password file in The Password File at postgresql.org.

   • User & Password: by using your login and password.

5. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

Snowflake

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Snowflake.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Authentication list, select an authentication method.

   • Authenticator: the authenticator to use for verifying user login credentials. For more information about the authenticator, see the Snowflake documentation at docs.snowflake.com.

   • User & Password: by using your login and password.

5. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

SQLite

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select SQLite.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. To connect to an existing SQLite database, specify a file path to the database file in the File field.

   To create a new SQLite database, change the default name of the database if needed identifier.sqlite and click OK.

   Also, to create a database, you can drag an SQLite DB file to the Database tool window.

5. To ensure that the connection to the data source is successful, click the Test Connection link.

Sybase ASE

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Sybase ASE.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. From the Authentication list, select an authentication method.

   • Domain credentials: by using domain authentication.

   • User & Password: by using your login and password.

5. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

6. To ensure that the connection to the data source is successful, click the Test Connection link.

Vertica

1. In the Database tool window (View | Tool Windows | Database), click the Data Source Properties icon .

   Select File | Data Sources.

2. On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select Vertica.

3. At the bottom of the data source settings area, click the Download missing driver files link. As you click this link, WebStorm downloads drivers that are required to interact with a database. To decrease the size of the installation package and keep driver versions up-to-date, drivers are not bundled with the IDE.

   You can specify your own drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.

4. Specify database connection details. Alternatively, paste the JDBC URL in the URL field.

   To delete a password, right-click the Password field and select Set Empty.

5. To ensure that the connection to the data source is successful, click the Test Connection link.