# Connecting SQuirreL via JDBC

**URL:** <https://community.cdata.com/t/connecting-squirrel-via-jdbc/834>\
**Category:** CData Virtuality \[Archived\]\
**Tags:** article, cdata-virtuality\
**Created:** [July 12, 2024, 4:37pm UTC](https://community.cdata.com/t/connecting-squirrel-via-jdbc/834 "2024-07-12T16:37:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anonymous](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anonymous](https://community.cdata.com/u/anonymous)\
**Post date:** [July 12, 2024, 4:37pm UTC](https://community.cdata.com/t/connecting-squirrel-via-jdbc/834/1 "2024-07-12T16:37:34Z")

</div>

Data Virtuality Suite contains a dedicated JDBC Driver in order to enable reporting tools and the Data Virtuality Studio to connect to the Data Virtuality Server using the JDBC protocol. Prior to using such BI tools, the Data Virtuality JDBC Driver must be installed.

To install the JDBC Driver, simply put the&nbsp; **datavirtuality-jdbc.jar** &nbsp;file, which is downloadable from your data virtuality server, into a folder where the particular Reporting Tool can find it.&nbsp;To connect to Data Virtuality Server via JDBC make your BI / Reporting tool registering the supplied datavirtuality-jdbc.jar driver.

For connecting use, for example, the following URLs:

#### JDBC connection string

> ```auto
> jdbc:datavirtuality:datavirtuality@mm://localhost:31000
> 
> ```

#### JDBC over SSL connection string

> ```auto
> jdbc:datavirtuality:datavirtuality@mms://localhost:31001
> 
> ```

### Example using the SQuirreL SQL Client

- Open Squirrel and press the ‘+’ sign on drivers, or use Drivers&nbsp;→&nbsp;New Driver in the menu.

- Set a name for the driver (e.g. ‘dv’).

- Enter example URL:&nbsp;_jdbc:datavirtuality:datavirtuality@mm://localhost:31000_

- Switch to the Extra Class Path tab, click ‘add’, and select the&nbsp;_datavirtuality-jdbc.jar_&nbsp;from your filesystem.

- Click &nbsp;‘List Drivers’.&nbsp;_com.datavirtuality.dv.jdbc.Driver_&nbsp;should appear in the field ‘Class Name’.

- Click ‘OK’ to save the driver configuration.

- Click on the alias tab, and press the ‘+’ sign to add an alias.

- Choose ‘dv’ or the alias name chosen before in the driver configuration in the URL select field.

- Enter the credentials and connect.