DataGrip Setup Instructions
Follow the steps below to be Work from Anywhere ready.
Steps 1: Rena or Melissa must request a password for your linkblue account that will allow you to log on via a Data Connection in DataGrip
Connecting to HANA from DataGrip cannot be done via your linkblue account and password directly. Your linkblue account must be assigned a password within HANA which will be different from your actual linkblue password. If you need a HANA password, please let Rena or Melissa know. We will request it and email you the password.
Step 2: Download and Install DataGrip
Regular Staff Members
You can download a Free 30-day trial of DataGrip here Links to an external site.. If you plan to use DataGrip longer than 30-days, a license must be purchased. Let Melissa know you would like a license.
Student Workers
You can sign up for the Free Educational License program for students here Links to an external site.. This will allow you free access to all JetBrains IDEs for personal use for you job.
Step 4: Setup the Data Source for HANA within DataGrip
- Open DataGrip
- Under File, choose Data Sources
- Click the + sign in the Data Sources tab
- Choose SAP Hana driver (if you don't see it click the Other and it should appear in list shown)
- Give the new source a name (like HANA)
- Emulate the settings below (the URL is jdbc:sap://HANA.uky.edu:30015/?EMPLOYEE_DETAIL=tdb1&user=<your linkblue>&password=<the HANA password assigned to your linkblue> (Note: <> are just notate what to change. Do not include them.)
- Click Apply
- Click on the Schemas tab and make sure the checkbox next to "All databases" is checked.
- Click OK
- On the left hand side of the screen, you should see the connection you just created. Clicking the down arrow on the main connection and next to database #1 should reveal all of the HANA schemas.
Step 5: Getting to Know DataGrip
Here are some handy hints on how to use DataGrip:
- Use the right/down arrows next to each level of the connection and schema to reveal the objects beneath that level.
- Double click on a view/table to pull up the first 1000 records in that view/table.
- To write a custom query, make sure the data source you want to use is highlighted (if you have multiple data sources). Then click the icon
to open a new query console.
- When typing a query, DataGrip should help you finish names of views/tables and variables. This is handy.
- To save your query, go to File - Save As. You can either choose to save the query in the default folder listed or choose another folder.
- To save the results of your query, look at the options on the upper right of the results window. There is a dropdown where you can choose the filetype you want to save the data as and a down arrow that will export the data.