Skip navigation

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: