Tag: Sybase SQL Anywhere
How to connect to a Sybase SQL Anywhere DB, with Kettle.
by z7oofy on Mar.11, 2010, under Business Intelligence, Kettle (PDI), Pentaho
Search not more ! here it is 
01. First you might want to, download the proper JDBC Driver from the Sybase website. download the ZIP file and find the jconn.jar file which is located in the \ jConnect-6_0\classes folder.
02. Place the jconn.jar file in your {Kettle Folder}\libext\JDBC\ folder
Kettle installation\libext\JDBC folder
And now the database settings.
03. Start Kettle, and bring up your DB settings window, and configure is as follows.
Connection Type : Generic database
Access : Native(JDBC)
And under DB access settings
Custom Connection URL : jdbc:sybase:Tds:<HOST ADDRESS>:<PORT NUMBER>/<DB NAME>
Custom Driver Class Name : com.sybase.jdbc3.jdbc.SybDriver
User Name : <USER NAME>
Password : <DB PASSWORD>
Yup that should be it ! now test your connection, if you did everything correct, Wolah !!
