Jump to: navigation, search

Connecting to SAP MaxDB 7.7

Revision as of 02:35, 24 January 2013 by Iwan.zarembo.de (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Back to How Do I Connect to...

Prerequisite

You need to install the MaxDB software to get the driver library if you do not have it already. You can download it from the download area http://www.sdn.sap.com/irj/scn/maxdb-downloads Download the full software package for your operating system and choose during installation only the JDBC driver.

Max db connectivity.png

Of course you can install more if you need more. The library can be found after the installation:

  1. on Windows 64bit at "C:\Program Files\sdb\MaxDB\runtime\jar\sapdbc.jar"
  2. on Linux at "/opt/sdb/MaxDB/runtime/jar/sapdbc.jar"




Install the MaxDB driver

  1. Open Eclipse
  2. Open Preferences -> Data Management -> Connectivity -> Driver Definitions
  3. Click on Add to add a new driver definition
  4. Select MaxDB in the vendor filter dropdown box of the pop up
  5. Select the entry MaxDB JDBC Driver and enter any driver name you like
  6. Switch to the JAR List tab
  7. Remove all invalid entries and add the path to your sapdbc.jar
  8. Check the properties tab if all values are correct.
    The driver class for MaxDB is com.sap.dbtech.jdbc.DriverSapDB
  9. Click on OK

Set up a connection profile

  1. Open Eclipse and switch to the Database Development perspective
  2. Click on the button New Connection Profile
  3. Select the entry MaxDB
  4. Enter any name and hit next
  5. Select the driver template you just created
  6. Enter your values to connect to your MaxDB server
  7. Test Connection to check if the entered values are correct
  8. Click on Finish to save the profile

Note This is only an example which should work with the most installation, but you still might need to tweak the proposed values.