Scientific Computing and Data / Mount Sinai Data Warehouse /OMOP Development/Configure DBeaver to connect to MSDW2

Steps for All Users

---

• Download DBeaver from the following website: https://dbeaver.io/download/
  • If you have a School mssm.edu email address, you are eligible to obtain the full featured “Enterprise Edition” of DBeaver free of charge
  • Other users should download the DBeaver “Community Edition” – which doesn’t have all the features of “Enterprise Edition” but should be adequate for almost all users
• Ensure you have the proper SQL Server driver installed:  Microsoft JDBC Driver for SQL Server
  • To install a new driver (DBeaver docs), in the Database menu click “Driver Manager”, which opens this modal:
     
  • Select MS SQL Server, New, and configure these driver settings:

• • Click on the Libraries tab. Click on Add Artifact→ Under Dependency Declaration add below maven config to get all the dependencies.

    <dependency>   <groupId>com.microsoft.azure</groupId>   <artifactId>adal4j</artifactId>   <version>1.6.7</version> </dependency>

     

  • Once added, select the dependency from options & click on Download/update.Accept all downloads.The result should look like this:

    
    

• Create connection to MSDW2
  • Peripheral to DBeaver, a user’s AD credentials must be added to the appropriate security group(s). To configure:
    • Submit a Sailpoint ticket for a user to be added to (need more information on appropriate MSDW2 group)
  • From the Database Navigator, right click on the “master” database and select “Edit Connection”
  •  From Connection settings, select the Main tab
  • Input the following:
    • Host: MSDW_PRD.mountsinai.org
    • Port: 1433
    • Authentication: Kerberos
    • Username & Password reflect existing Mount Sinai ID and password
      
  • Select “Test Connection” at the bottom-right of the pop-up to determine success in the connection
  • If successful, click “OK”

 

Additional Steps for MacOS & Linux Users

---

In your /etc directory, create a text file called krb5.conf with the following contents:

Open a terminal and enter the following commands, where lastnf99 is your AD username following by either @msnyuhealth.org (for Hospital users) or @mssmcampus.mssm.edu (for School users):

You should then see output similar to this:

In DBeaver’s dialog box for your connection to MSDW2, set the following in the “Main” connection parameters tab:

In DBeaver’s dialog box for your connection to MSDW2, click on the “Driver properties” tab and set the following values: