jTDS -SQL Server and Sybase JDBC driver

Accessing SQL Server using a JDBC driver is implemented in the package RSQLServer which appears to have been archived. Assuming we can get to RSQLServer package we still need jTDS driver.

jTDS driver can be downloaded from here:

https://sourceforge.net/projects/jtds/files/jtds/1.3.1/

The driver description as found on Sourceforge is as follows:

"Open source JDBC 3.0 type 4 driver for Microsoft SQL Server (6.5 up to 2012) and Sybase ASE. jTDS is a complete implementation of the JDBC 3.0 spec and the fastest JDBC driver for MS SQL Server. For more information see http://jtds.sourceforge.net/"

There are other options such as ODBC-JDBC Bridge and Microsoft's JDBC driver which are not totally free.

The latest version is jtds-1.3.1-dist.zip (551.2KB)

Progress DataDirect delivers open connectivity to cater to all of your needs

Progress DataDirect uses leading industry standards ODBC, ADO.NET, OLE DB, JDBC or OData. It connects to database; to an application or to your cloud data.

DataDirect_01

Here is a schematic of DataDirect Connectivity.

DataDirect_02

In its own words,
"Deliver your own fully branded open connectors built on a codebase that is certified across third party applications such as Tableau, Excel, Qlik, Spotfire, Alteryx, SSIS, IBM Cognos, SAP Business Objects, Informatica PowerCenter, Salesforce and more. You can also get run-time installers with our SDK for easy distribution to your customers
"
Looks like nothing is left out!

These are in more details for each of connectivity categories:
Connectivity to databases:
NoSQL, NewSQL, Graph, Object, Document
Multi-dimensional, OLAP
Data Pipelines
Modelling Multi tenant databases
Private DB clouds

Connectivity with Applications/Business Logic:
logic layer for ERP, CRM, marketing or finance systems
Data service layers (expose a common data model)
4GL languages such as ABL
Web Services (SOAP/REST)
In-memory analytics model

File based data stores:
C-ISAM, COBOL, BTree, CTree, XML, JSON
Data archives
Financial transaction message files
Log files
EDI messages

Download a trial and experience the thrill from here:
https://www.progress.com/trial-datadirect

JDBC Type 4.2 SQL Server Driver availability is announced

Microsoft has announced the availability of JDBC Driver for SQL Server that implements full compliance with JDBC Specifications 4.1 and 4.1. It supports the JDK 1.8 and the Transport Layer Security (TLS) for security over the Internet.  The JDBC 4.2 driver also supports the SQL Server's Always on feature.

Download link for JDBC 4.2 Driver is here (http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774)

 

JDBC is an important component of Microsoft Data Connectivty scheme:

JDBCMicrosoft.png\
The source for this information and image is here .

Review here for the usage of this driver while connecting to data source: