Creating an Oracle Database connection
Warning
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):ipv4ipv6178.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:
Warning
If you use a new DataLens object model with workbooks and collections:
- Go to the DataLens home page
. In the left-hand panel, select - Open the workbook, click Create in the top-right corner, and select the appropriate object.
Follow the guide from step 3.
-
Go to the connections page
. -
Click Create connection.
-
Select Oracle Database as the connection type.
-
Specify the connection parameters:
- 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.
-
Click Create connection.
-
Enter a name for the connection and click Create.
Note
You can check the host connection before creating it. To do this, click Check connection.
Additional settings
You can limit data export from charts by enabling Disable data export under Advanced connection settings. With this option enabled, the export data button will be hidden in the charts based on this connection. However, you will still be able to copy chart data and take screenshots.