Versions Compared

Old Version 2

changes.mady.by.user Juliane Wetzel

Saved on

compared with

New Version 3

changes.mady.by.user Juliane Wetzel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You have a lot of your data stored within a database that you need to analyze. This guide shows you all the steps needed to connect the MSSQL database database to Datameer. After you have set up the database connection you can then import your data so that it is ready for analysis. The Datameer X user must have administration privileges. 

Table of Contents

Downloading Database Drivers

  1. Download the correct database drivers from the driver source. This example uses the Microsoft SQL Server driver.
    Download: Microsoft SQL Server JBDC Driver
    If you are on a Mac or Linux, download sqljdbc_3.0.1301.101_enu.tar.gz and continue on to step 2. 
    Image Removed
    If you are using Windows, download sqlidbc_3.0.1301.101_enu.exe and skip to Step 3.
    Image Removed

  2. Once you downloaded the correct database driver to the computer, extract the tar file that you have downloaded. 

    1. Open the terminal. 

    2. Open the folder where the database driver was downloaded: cd /Users/<user name>/Downloads

    3. Extract the tar file with the following command: tar -xzf sqljdbc_3.0.1301.101_enu.tar.gz 

  3. Only if you use Windows: After the executable database driver file is downloaded, double-click the file to run it.

Adding the Database Driver to Datameer

...

Name the driver MSSQL. 

Image Removed

...

Select MsSql from the Database Driver Template menu and add the driver class and connection pattern.

...

Click Choose File to upload the jar file you previously extracted. This is named sqlidbc4.jar and is in the folder where it was extracted.

Note

JDBC Driver Classes are used to load the proper driver into the Java session. (Note, some class path drivers end with a period (.) Check your distribution documentation for details.)

Connection Pattern is a URL representation for the database.

...

Preventing Security Issues 

Info
titleINFO

Datameer Admins who add a new database driver must be aware of malicious driver files that can attack Datameer X. To prevent adding dangerous driver jar files, obtain the required database driver files only from safe sources. 

Configuring the JDBC Import

...