Yandex Cloud
Search
Contact UsGet started
  • Pricing
  • Customer Stories
  • Documentation
  • Blog
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • AI Studio
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Start testing with double trial credits
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Center for Technologies and Society
    • Yandex Cloud Partner program
  • Pricing
  • Customer Stories
  • Documentation
  • Blog
© 2025 Direct Cursus Technology L.L.C.
Service page
Yandex DataLens
Documentation
Yandex DataLens
    • Overview
    • Caching
    • Combining data
      • Creating a ClickHouse® connection
      • Creating a PostgreSQL connection
      • Creating a MySQL® connection
      • Creating a YDB connection
      • Creating a Greenplum® connection
      • Creating a SQL Server connection
      • Creating an Oracle Database connection
      • Creating a Prometheus connection
      • Creating a Snowflake connection
  • Audit Trails events
  1. Connections
  2. Databases
  3. Creating an Oracle Database connection

Creating an Oracle Database connection

Written by
Yandex Cloud
Updated at September 2, 2025

Warning

Yandex Cloud holds no responsibility for configuring a remote connection on an external database server side. When connecting an external database which is not a Yandex Cloud resource:

  • Make sure the database uses an SSL certificate signed by a SSL certificate authority. You will not be able to create a connection in DataLens if the database uses a self-signed SSL certificate.

  • Grant database access to the following DataLens IP ranges (/ is followed by subnet mask length):

    ipv4
    ipv6
    • 178.154.242.176/28
    • 178.154.242.192/28
    • 178.154.242.208/28
    • 178.154.242.128/28
    • 178.154.242.144/28
    • 178.154.242.160/28
    • 130.193.60.0/28
    • 2a02:6b8:c03:500:0:f83d:a987:0/112
    • 2a02:6b8:c02:900:0:f83d:a987:0/112
    • 2a02:6b8:c0e:500:0:f83d:a987:0/112
    • 2a02:6b8:c41:1300:0:f83d:a987:0/112

To create an Oracle Database connection:

  1. Open the new connection creation page.

  2. Under Databases, selec the Oracle Database connection.

  3. Configure the connection as follows:

    • Hostname. 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 are unable 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 the cache time-to-live 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. This option is disabled by default. When enabling it, you will need to select the raw SQL level:

      • Allow subqueries in datasets: Describe dataset sources using SQL queries.
      • Allow subqueries in datasets and source parameterization: Describe dataset sources using SQL queries and use source parameterization.
      • Allow subqueries in datasets, source parameterization, and QL charts: Describe dataset sources using SQL queries, use source parameterization, and create QL charts.

    image

  4. (Optional) Test the connection. To do this, click Check connection.

  5. Click Create connection.

  6. Select a workbook 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.

  7. Enter a name for the connection and click Create.

Additional settingsAdditional settings

You can specify additional connection settings in the Advanced connection settings section:

  • 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 specify the certificate file. When the certificate is uploaded, the field shows the file name.
  • Disable data export: When this option is on, the data export item will be unavailable in the menu of the charts based on this connection. However, you will still be able to copy chart data and take screenshots.

Was the article helpful?

Previous
Creating a SQL Server connection
Next
Creating a Prometheus connection
© 2025 Direct Cursus Technology L.L.C.