# Creating a Custom Connection

> Sisense provides a generic Java Database Connectivity (JDBC) connector that you can configure to import data from a JDBC-supported source, for example, Postgres. To import data from a JDBC-supported source, you need a connection string that defines the location of the database and the necessary properties required for accessing the database.

*Source: https://docs.sisense.com/main/SisenseLinux/creating-a-custom-connection.htm*

---

Last updated: June 10, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

Sisense provides a generic Java Database Connectivity (JDBC) connector that you can configure to import data from
a JDBC-supported source, for example, Postgres.

To import data from a JDBC-supported source, you need a connection string that defines the location of the database and the
necessary properties required for accessing the database.

Keep in mind that each data source has its own requirements for connecting to it via JDBC. Refer to the provider
documentation for this information.

**Note:**

For the list of supported connectors, see [Data Source Connectors](https://docs.sisense.com/main/SisenseLinux/introduction-to-data-sources.md).

  

## Creating a Connection String

With JDBC, a database is represented by a connection string, or URL, that defines its location and additional
properties.

The connection string required to connect to a JDBC data source varies according to the requirements of that
particular provider. You should check the provider's documentation for details regarding their requirements.
  
For example, a connection string to a Postgres data source has the following form:

`jdbc:postgresql://host:port/database`

For Postgres, your connection string should include the following:

- **Host:** The host name of the server. Defaults to localhost. To specify an IPv6 address, enclose the
  host parameter with square brackets, for example:
    
  `jdbc:postgresql://[::1]:5740/accounting`
- **Port:** The port number the server is listening on. Defaults to the PostgreSQL™ standard port
  number (5432).
- **Database:** The database name.

See Postgres JDBC documentation for more information.

## Importing Data from a JDBC Data Source

**To import data from a JDBC data source:**

1. In the Data page, open an ElastiCube or [create a new ElastiCube](https://docs.sisense.com/main/SisenseLinux/creating-elasticubes.md).
2. In the Model Editor, click ![+Data new](https://docs.sisense.com/main/Resources/Images/+Data-new_56x23.png). The Add Data dialog box is displayed.

   ![Create JDBC connector](https://docs.sisense.com/main/Resources/Images/create-JDBC-connector_1049x772.png)
3. Click ![Create new connection button](https://docs.sisense.com/main/Resources/Images/create-new-connection-button_27x27.png) and select Generic JDBC. The Create JDBC Connector page is displayed.

   ![JDBC connection dialog](https://docs.sisense.com/main/Resources/Images/JDBC-connection-dialog.png)
4. Enter a Connector ID and Display Name for the connection.
5. Drag and drop the jar file or click **browse** and select the file to upload.
6. Enter the Class name and click **Create**.

## JDBC Authentication

If you are using any browser-based authentication, for example, OAuth, while connecting to your data source with the
JDBC connector, you need to update the JDBC configuration file. For information, click [Configuring a Custom Connector to Use OAuth](https://docs.sisense.com/main/SisenseLinux/configuring-the-jdbc-connector-to-use-oauth.md).

## Accumulate Builds for JDBC Connector

By default, the data that comes from your JDBC data sources is not accumulated at the time of the build. To enable
data accumulation by integer and date in tables originating from JDBC data sources, click [Enabling Accumulative Build for Connector](https://docs.sisense.com/main/SisenseLinux/enabling-accumulative-build-for-connector.md).