Setting up Datagrip


This is one of a series of posts where I document software configurations for personal reference. This post documents the configurations for Datagrip.


Datagrip is available as a snap package on Ubuntu, which can be installed using the following command:

sudo snap install --classic datagrip


Follow these steps:

  1. Download this configuration file.
  2. Open Datagrip and click “File” -> “Import Settings”.
  3. Choose the downloaded file.
  4. 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:

  1. Open the “Data Sources and Drivers” window.
  2. Download the oracle database driver.
  3. Add an Oracle data source.
  4. In the “General” -> “URL” section, choose “TNS” from the drop box.
  5. 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 = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521)) 
    (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521)) 
    (LOAD_BALANCE = no) 
    (FAILOVER = ON) 
      (SERVICE_NAME = newods1) 
        (TYPE = SELECT) 
        (METHOD = BASIC) 

where mydb is a TNS name.


comments powered by Disqus