Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Sybase Connection

Turribeach
Level 6
Sybase Connection

Sybase is not officially supported by Dataiku but I saw another post from another user that he was able to retrieve data from a Sybase database. However there were no details on how to set it up. I therefore figured it myself so here are the details in case you need to do the same. 

  1. Download the Jconnect 4 Sybase driver (jconn4.jar) and place it in a new directory under [node]/lib/jdbc/sybase. Good luck finding it, I wasn't able to find it on the SAP site so I used an older version from a previous project
  2. Create a new SQL database (JDBC) connection and fill the details as follows:

JDBC driver class: com.sybase.jdbc4.jdbc.SybDriver

JDBC URL: jdbc:sybase:Tds:hostname:port/database_name

Driver jars directory: ./lib/jdbc/sybase

SQL dialect (experimental): Sybase IQ

User/Password of course

Test and save the connection. After creating the connection go to your project and select New Dataset => SQL Databases => Other SQL Databases. Select the new Sybase connection and change the Mode to SQL query. It won't work otherwise since Dataiku uses the LIMIT statement to limit the amount of rows you get which is not supported by Sybase ASE. SQL Notebooks seem to work fine as well. 

Enjoy!

0 Kudos
1 Reply
CoreyS
Community Manager
Community Manager

Thanks for sharing this with us @Turribeach

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos