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

Hello Everyone :)

With this blog post I will explain how you can quickly get DataGrip tool configured on your Linux machine and use it to get wso2 identity server configured on a different database type.

I will be using DB2 11.5 as the database type to get the database scripts executed.

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

Then go to New > Give a project name and create a new project

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

Now You have executed your database script against the created database using the DataGrip tool.

--

--

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

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