Using DataGrip as a Cross Platform IDE for Exploring Databases with WSO2 Identity Server

How to get DataGrip tool Installed on Ubuntu 20

  1. Visit https://www.jetbrains.com/help/datagrip/installation-guide.html#snap
  2. You can install the stable version of the datagrip tool and run it on your linux machine as below
sudo snap install datagrip --classicdatagrip

How to create a New Project in DataGrip

You can activate the trial version or paid version of the tool

How to select the Database type from the Data Grip Tool

  1. Click on the + icon > Data Sources > Select the Required Database type (eg:- IBM DB2 )
  2. Add the Details of the pre configured database that you are trying to get connected to
  3. Download the DB driver from this window
  4. Click Apply > ok

How to Add a DB2 Script to DataGrip and run DB2 Script from WSO2 Identity Server

  1. Go to Run > Edit Configurations > + icon > database script
  2. Give a name
  3. Add target datasource ( your registered database will get listed. Select it)
  4. In the Execute > Script section copy and paste the script you want to execute ( product-is-home/dbscripts)
  5. Click Apply > Ok
  6. Then go to Run section > Click on Green icon to run the script

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Shanika Wickramasinghe

Shanika Wickramasinghe

Senior Software Engineer and Freelance Technical Writer. I write about any Computer Science related topic. https://www.linkedin.com/in/shanikawickramasinghe