代码区项目交易流程

Zeppelin-ms sql server interpreter


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

Apache Zeppelin doesn't come with a specific interpreter for SQL Server. By default Apache Zeppelin is shipped with a JDBC interpreter which means that you can use that to connect to SQL Server, provided that you have downloaded and installed the Microsoft SQL Server JDBC Driver.

To overcome the limitations of the generic JDBC interpreter I've created a specific Zeppelin Interpreter for SQL Server. You can find more details here:

https://medium.com/@mauridb/apache-zeppelin-sql-server-sql-azure-and-sql-azure-dw-1706697bb54#.wuk7dte00

You can use it to connect to SQL Server, Azure SQL and Azure DW

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

点击收藏

LAST Happy new year from SQL Down Under and from me SQL Server export adhoc SQL or table to CSV file NEXT