Connecting to PostgreSQL
Applicable to Sisense on Linux and Microsoft WindowsNote: This topic describes how to import data into Sisense's ElastiCube, and how to use Live Connect. To import data through ElastiCube Manager, the desktop application, click here.
Sisense enables easy and quick access to databases, tables and views contained within PostgreSQL databases.
You can import your data into a Sisense ElastiCube, or connect your data to a Sisense Live model, using Live Connect.
Note: The JDBC parameters listed in this document are currently not supported for Windows. These parameters will work in Sisense for Linux.
To import data from PostgreSQL:
- In the Data page, open an ElastiCube or create a new ElastiCube.
- In the ElastiCube, click . The Add Data dialog box is displayed.
- Click PostgreSQLto open the PostGreSQL settings.
- Enter the following details:
- Location: Enter the computer/server IP address of the database. To connect to a database running on your own computer enter localhost.
- If Windows Authentication is configured with the database in the User Name and Password fields, enter your database credentials.
- Database (Optional): Enter the name of the database you want to access. If nothing is entered, you will get a list of all databases to which you have permissions.
- Select SSL Mode: Select the relevant mode to determine whether or with what priority a secure SSL TCP/IP connection will be applied with the server. There are six modes: ‘disable’, ‘allow’, ‘prefer’, ‘require’, ‘verify-ca’, ‘verify-full’.
- SSL Root Certificate: Enter the name of a file containing SSL certificate authority (CA) certificate(s).
- SSL Certificate: Enter the file name of the client SSL certificate.
- SSL Key:Enter the file name of the client SSL key.
- SSL Password: Enter the SSL password.
Note: The default connection timeout limit is 30 seconds to PostgreSQL data sources. You can modify this limit by editing the Sisense.Connectors.PostgreSqlConnector.dll.config located at ...\Program Files\Sisense\DataConnectors\DotNetContainer\Connectors\PostgreSql.In the configuration file, under the section PostgreSettings, set the value of the parameter Timeout to change the connection timeout limit. This is useful in cases where you receive a TimeOut exception when trying to connect.
To add a PostgreSQL live connection:
- Open a live model. See Creating Live Models for more information.
- In the Model Editor, click .
- In the Add Live Connection dialog box, select your live data source.
- Under the Connect tab, enter the following credentials:
- (Optional) Select Encrypt Connection to configure the driver to encrypt all communication with the PostgreSQL Server instance before sending it over the network, and then select Trust Server Certificate.
- Click Next.
- Under the Select Data tab, on the left side is a list of schemas located in your data source. Select the relevant schema. You can find the schema easily by searching for it through the search field at the top of the list to filter the schemas displayed. After selecting the schema, a list of the available tables and views are displayed.
- Select a table or view. You can find the table easily by searching for it through the search field at the top of the list to filter the tables displayed.
- Click Done. The table is added to the model.
See Publishing Live Models for information on how to publish the model and begin creating visualizations with it.
Location: The IP address of your data source.
User Name: The user name to access data source.
Password: The password to access your data source.