title: Load data from MS SQL table to snappyData
body: <p>I am using Tibco ComputeDB, which is new to me. It uses sparkDB and snappyData. I want to add data from MS SQL to in memory table of snappyData.</p>
  
  <p>I can read data from CSV and load that in snappyDaya with below command.</p>
  
  <p>=> CREATE EXTERNAL TABLE IF NOT EXISTS AirlineData USING csv OPTIONS(path '/home/ubuntu/Downloads/airline-data-small/*.csv')</p>
  
  <p>Now same way I want to read data from MS SQL and want to add it in snappyData but not able to find proper way to do it. I followed below documentation and able to connect to MS SQL server and display data using spark/scala. But didn't find way to add it in snappyData.</p>
  
  <p>=> <a href="https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases</a></p>
  
  <p>There is also documentation which shows how to do it for MySQL but not for MS SQL.</p>
  
  <p>=> <a href="https://snappydatainc.github.io/snappydata/howto/load_data_from_external_data_stores/" rel="nofollow noreferrer">https://snappydatainc.github.io/snappydata/howto/load_data_from_external_data_stores/</a></p>
  
  <p>Came across below link and made changes for sqlserver but getting error.</p>
  
  <p>=> <a href="https://stackoverflow.com/questions/53388666/how-can-i-get-external-table-jdbc-url-in-snappydata">How can I get external table jdbc url in SnappyData</a></p>
  
  <p>For SQL Server:-</p>
  
  <p>create external table Test_1 using jdbc options(url 'jdbc:sqlserver://server:port;database=dbname;user=username;password=pswd', driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver',dbtable 'CERTIFICATES');</p>
  
  <p>Error:- </p>
  
  <p>ERROR 42000: (SQLState=42000 Severity=20000) (Server=localhost/127.0.0.1[1528] Thread=ThriftProcessor-0) Syntax error or analysis exception: com.microsoft.sqlserver.jdbc.SQLServerDriver</p>