Skip navigation

Monthly Archives: August 2010

Today I created a Micros 3700 to Food-Trak transformation with Pentaho Data Integration. The SQL was the easy part. The hard part was creating the JDBC connection. At least it was hard for me since I haven’t connected to Sybase since 1998. But after 4 hours of googling and experimenting, I figured out the connection configuration and created the transformation.

I used Jconnect and modified the spool.bat file to include its path in the classpath variable. I have a problem with column names being passed through the stream. But, I created a work around and presto, changeoh … a file to import into Food-Trak.

Tomorrow I will test and validate the extract. Once I am 100% sure it works, I will write another post about it.