EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

DB2 Connection using JDBC


Henri-Francois Chadeisson

Director, Sales Engineering • MicroStrategy


How to connect to DB2 databased using IBM JDBC driver

Strategy's default driver for DB2 requires specific User privileges in order to connect to the database.
It's all explained here: KB19382: Information regarding package creation and binding for the MicroStrategy ODBC Driver for DB2 Wire Protocol .
If you don't have access to a DBA or cannot get the privileges added to your Database account, you can still use JDBC to setup the connection.
The following article explains how to connect to Databases using JDBC: KB250923: Connecting to Databases using JDBC Drivers in MicroStrategy 10.x. 
Regarding IBM DB2, you can download the JDBC driver from the IBM download site
Connection string:
JDBC;DRIVER={com.ibm.db2.jcc.DB2Driver};URL={jdbc:db2://server-ipadress:dbport/dbname}; driver="com.ibm.db2.jcc.DB2Driver";MSTR_JDBC_JAR_FOLDER=/path-to-driver/db2_db2driver_for_jdbc_sqlj;driverFile="db2jcc.jar";MSTR_CUSTO;


Comment

0 comments

Details

Knowledge Article

Published:

June 5, 2017

Last Updated:

June 5, 2017