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.
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
Create a new SQL database (JDBC) connection and fill the details as follows:
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.