---
metadata:
  - name: generator
    content: Diplodoc Platform v5.63.0
alternate:
  - en/operations/connection/create-oracle
  - ru/operations/connection/create-oracle
  - href: en/operations/connection/create-oracle.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-oracle.html
title: How to create an Oracle Database connection in DataLens On-premises
description: >-
  In this tutorial, you will learn how to connect to Oracle Database in DataLens
  On-premises.
vcsPath: en/operations/connection/create-oracle.md
---

# Creating an Oracle Database connection in DataLens On-premises


To create an Oracle Database connection:

1. Select a workbook for the new connection and click **Create** → **Connection**.
1. Under **Databases**, select the **Oracle Database** connection.
1. Configure the connection as follows:

   * **Host name**: Specify the path to the master host or the IP address of the Oracle Database master 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 Oracle Database connection port. The default port is 1521.
   * **Path to database**: Specify the service name or the system ID of the database to connect and select the **Service name** or **SID** option, respectively.
   * **Username**: Specify the username for the Oracle Database connection.
   * **Password**: Enter the password for the specified user.
   * **Cache TTL in seconds**: Specify cache TTL or leave the default value. The recommended value is 300 seconds (5 minutes).
   
   <!-- source: en/_includes/datalens/datalens-db-connection-sql-level.md -->
   * **Raw SQL level**: Enables you to use an ad-hoc SQL query to [generate a dataset](../../dataset/settings.md#sql-request-in-datatset). This option is disabled by default. When enabling it, you will need to select the raw SQL level:

      * **Subqueries only**: Describe dataset sources using [SQL queries](../../dataset/settings.md#sql-request-in-datatset).
      * **Subqueries and parameters**: Describe dataset sources using SQL queries and use [source parameterization](../../dataset/settings.md#parametrization).
      * **SQL to read**: Describe dataset sources using SQL queries, use source parameterization, and [create QL charts](../../concepts/chart/ql-charts.md).
   <!-- endsource: en/_includes/datalens/datalens-db-connection-sql-level.md -->

1. Optionally, test the connection by clicking **Check connection**.
1. Click **Create connection**.


1. Select a [workbook](../../workbooks-collections/index.md) to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click **Create**.


1. Enter a name for the connection and click **Create**.

## Additional settings {#additional-settings}

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

* **TLS**: Indicates whether TLS is required. When this option is enabled, the connection requires using SSL.
* **CA Certificate**: To upload a certificate, click **Attach file** and select the certificate file. When the certificate is uploaded, the field shows the file name.
* <!-- 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 -->