0 Replies Latest reply on Jan 20, 2020 12:30 PM by Jacob Kruse

    Custom JDBC Connection - http1.x server error

    Jacob Kruse

      Hi - I'm trying to create a custom JDBC connection to SAS datasets but in general just trying to make a JDBC connection with a Custom JDBC Driver using the generic JDBC dialect (SQL92).

       

      I get this error:

       

      Trying to connect an http1.x server

      Generic JDBC connection error

      Trying to connect an http1.x server

       

      From reading online, it appears this is a proxy related issue so I'll reach out internally at my company as well.

       

      What I've done so far to setup the Custom JDBC Connection using the Other Databases (JDBC) Connector:

      - I've added the necessary .jar files with the JDBC class to C:\Program Files\Tableau\Drivers directory and I can see in the Tableau Logs that these .jar files are recognized

      - Identified correct JDBC connection URL in my case: jdbc:sasiom://companyserver.company.com:8591

       

      Concerns:

      - I don't know how Tableau identifies the correct JDBC driver class to use, apparently it just figures it out

      - I don't see any mention of the JDBC driver class I'm trying to use in connecting to SAS: com.sas.rio.MVADriver

      - The logs just state a class of genericjdbc

      - I'm assuming that the SQL92 generic dialect will work for me but perhaps it won't and some additional configuration is needed. To me, a dialect is just the sql language that would be used upon making a connection which a generic dialect is fine.

      - I don't see any additional detail in the logs other than Trying to connect an http1.x server

       

      Has anyone received this error before creating a Custom JDBC connection? How did you work through it? Is it indeed a proxy issue?

       

      As info: I've successfully made this JDBC connection outside of Tableau in another application called Squirrel SQL so I know that a JDBC connection should work I just don't know what else I need to do in Tableau to get it to work.