Introduction
This is one of a series of posts where I document software configurations for personal reference. This post documents the configurations for Datagrip.
Installation
Datagrip is available as a snap package on Ubuntu, which can be installed using the following command:
sudo snap install --classic datagrip
Configuration
Follow these steps:
- Download this configuration file.
- Open Datagrip and click “File” -> “Import Settings”.
- Choose the downloaded file.
- Select components to import (select all by default).
Additional notes
Here is a short tutorial on how to connect to an Oracle 11g database using TNS:
- Open the “Data Sources and Drivers” window.
- Download the oracle database driver.
- Add an Oracle data source.
- In the “General” -> “URL” section, choose “TNS” from the drop box.
- Specify the TNS file (see below for an example) path in the “TNSADMIN” section, and other necessary information below.
Here is a made-up TNS file:
mydb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.126.178.13)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 152.126.178.14)(PORT = 1521))
(LOAD_BALANCE = no)
(FAILOVER = ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = newods1)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
where mydb
is a TNS name.