Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
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!
Thanks for sharing this with us @Turribeach!