BookmarkSubscribeRSS Feed
krusader
Fluorite | Level 6

I'm trying to connect to SAS Datasets from Tableau using the sasiom jdbc interface. I've been unsuccessful so far and I believe it is because I'm using a Type 2 JDBC driver which is the latest sasiom driver I can find here: https://support.sas.com/downloads/browse.htm?fil=&cat=50 the Nov 2018 release.

 

The Nov 2018 SAS JDBC Driver release looks like a Type 2 JDBC driver from inspecting the result of getJDBCMajorVersion = 2

 

This Tableau Conference Document explains JDBC connections out of Tableau and how Tableau expects a Type 4 JDBC Driver

 

Tableau JDBC connections expect a Type 4 driver which does not need to specify a JDBC driver class name (com.sas.rio.MVADriver) and simply queries the available JDBC drivers for one that can interpret the jdbc connection url (jdbc:sasiom)

 

Does SAS have plans to release a Type 4 JDBC driver or is there one available that I'm not finding?

2 REPLIES 2
Anand_V
Ammonite | Level 13
Hi @krusader, I couldn't find this information on any document. I would suggest you to raise this request with SAS Technical support by sending an email to support@sas.com for assistance.
krusader
Fluorite | Level 6

Hi @Anand_V - Here are documents that further support my findings leading up to this post. I am a SAS User at my company as well as a Tableau creator. I see the strengths of both tools and would like to integrate them via a JDBC connection. My SAS Admin is aware of this and would be the one to create the SAS support ticket. I'm trying to raise awareness to this issue and see if SAS has plans to release a JDBC Type 4 driver?

 

Further Documentation

 

- Types of JDBC Drivers

- Issue with Tableau Developer SDK explaining JDBC Type 4 needed

- getJDBCMajorVersion to find JDBC Version number of Driver

 

Below is a screenshot making a JDBC connection to SAS using the public JDBC Drivers most recently available (Nov. 2018) and the property of getJDBCMajorVersion = 2 ... This shows that the most recent SAS JDBC Drivers available are of JDBC Type 2

 

SAS_JDBC_connection.png

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1449 views
  • 1 like
  • 2 in conversation