Developers

A forum for collaboration, Q&A, and knowledge sharing on SAS and open source integration
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
AnandVyas
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 @AnandVyas - 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

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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