---
metadata:
  - name: generator
    content: Diplodoc Platform v5.63.0
alternate:
  - en/operations/connection/create-greenplum
  - ru/operations/connection/create-greenplum
  - href: en/operations/connection/create-greenplum.md
    type: text/markdown
    title: Markdown version
csp:
  - script-src:
      - https://mc.yandex.ru
    img-src:
      - https://mc.yandex.ru
    connect-src:
      - https://mc.yandex.ru
      - wss://mc.yandex.ru
    child-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-src:
      - 'blob:'
      - https://mc.yandex.ru
    frame-ancestors:
      - 'blob:'
      - https://mc.yandex.ru
canonical: en/operations/connection/create-greenplum.html
title: How to create a Greenplum® connection in DataLens On-premises
description: >-
  In this tutorial, you will learn how to connect to Greenplum® in DataLens
  On-premises.
vcsPath: en/operations/connection/create-greenplum.md
---

# Creating a connection to Greenplum® in DataLens On-premises



To create a Greenplum® connection:

1. Go to the [workbook](../../workbooks-collections/index.md) page or create a new one.
1. In the top-right corner, click **Create** → **Connection**.
1. Select the **Greenplum®** connection.
1. Specify the connection parameters for the external Greenplum® database:

   * **Host name**: Specify the path to the Greenplum® host. You can specify multiple hosts in a comma-separated list. If you fail to connect to the first host, DataLens will select the next one from the list.
   * **Port**: Specify the Greenplum® connection port. The default port is 5432.
   * **Path to database**: Specify the database name.
   * **Username**: Specify a username for the Greenplum® connection.
   * **Password**: Specify a password for the user.
   * **Cache TTL in seconds**: Specify cache TTL or leave the default value. The recommended value is 300 seconds (5 minutes).
   * **Raw SQL level**: Enables you to use an ad-hoc SQL query to [generate a dataset](../../dataset/settings.md#sql-request-in-datatset).

1. Optionally, test the connection by clicking **Check connection**.
1. Click **Create connection**.
1. Enter a name for the connection and click **Create**.


## Additional settings {#additional-settings}

You can specify additional connection settings under **Advanced connection settings**:

* **Setting collate in a query**: To explicitly define a collation for database queries, select a mode:

  * **Auto**: Applies the default setting. DataLens decides whether to enable the `en_US` locale.
  * **On**: Applies the DataLens setting. The `en_US` locale is specified for individual expressions within a query. Thus the server uses the appropriate sorting logic, regardless of the server settings and specific tables. Use the DataLens setting if your database locale is incompatible with DataLens. 
  * **Off**: Applies the default setting. DataLens only uses database-level locale settings.

* <!-- source: en/_includes/datalens/operations/datalens-db-connection-export-settings-item.md -->
  **Disable data export**: When this option is on, the data export item will not be available in the <!-- diplodoc:svg ![icon](../../_assets/console-icons/ellipsis.svg) --><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M3 9.5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3M9.5 8a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0m5 0a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0" clip-rule="evenodd"/></svg> menu for the charts based on this connection. However, you will still be able to copy chart data and take screenshots.
  <!-- endsource: en/_includes/datalens/operations/datalens-db-connection-export-settings-item.md -->