zeppelin-ms sql server interpreter

Question

i have zeppelin running on my system.. details are

ubuntu 14.04 64bit

Apache Zeppelin 0.6.0

java version "1.7.0_111"

Apache Maven 3.3.9

-Pspark-2.0 -Dspark.version=1.5.2

i have seen many interpreters with sql but i didnot get which interpreter to go with. all like ignite,jdbc,live,psql,spark interpreters are not providing proper url, username, password, database to connect my MS sql server.

i read some posts and assume that there is some interpreter which connects zeppelin-sql server. Apache zeppelin tutorial, error "sql interpreter not found" this also didnt work. could someone please guide me to select the interpreter if exist, if not how to add this interpreter?

thanks in advance

Answer 1

• download JDBC driver for sql server provided by MS

• exact sqljdbc42.jar and save it to local, e.g. /zeppelin/3rd-lib/sqljdbc42.jar

• create new interpreter with MS SQLServer Driver

• use it in the notebook!