Setting up Datagrip

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 datagrip

Configuration

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 = 
  (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.