Lightweight ETL or database Sync - Sybase to SQL Server

Question

I have been doing some investigations into some light weight database Syncing tools to trial. The initial task we want to perform is a simple data sync from a few tables on a Sybase ASE database (15) to a SQL Server database (2008 R2). Timing wise, I'd like to keep my options open, but ultimately, I would like to have the ability to sync every minute or less.

I have been looking at SymmetricDS, which at face value seems to do exactly what I want it to. The drama is I have hit a couple of roadblocks on the Sybase side of things, which is proving to be very frustrating (Jumpmind support are assisting). It appears that Java has a problem with the default collation we have on our server, being HP-roman8. Unfortunately, to change this charset is way bigger then this project itself.

I have also started investigating Talend, but have hit a few roadblocks in relation to requiring older versions of drivers for Sybase and downgrading the installed version of Java.

Without having to go to Replication Server, does anyone have any suggestions on a relatively lightweight ETL or database Syncing tool that will do what I want? The biggest gotcha thus far is Sybase support - I really need something that will seamlessly work without having to hack too much.

Cheers

sorry, but your question is too broad. could it be narrowed to a more concrete question? — Boris Pavlović
No probs - yeah, I admit now it was a question asked in frustration...trialling tools that don't work is not fun. — Ash
Sorry - missed my edit window on the comment above..... I am specifically looking for a tool to data sync between Sybase ASE and SQL server. It must have good recovery if it goes offline. I'm also not afraid if the tool uses triggers, but have a preference to not have to add new columns to existing data tables. From what I have seen, SymmetricDS seems like a good fit - basically, I am after alternatives to that. — Ash
Maybe you Sybase ASE CIS to 'mount' the tables in question, and use triggers to update the remote database? — Michael Gardner
May I ask what is the purpose of the sync? Have you considered linked servers in SQL Server? — Alex Szabo

Jeronimo Backes Jeronimo Backes · Accepted Answer · 2014-11-27T14:44:04

You should try uniVocity. It is a Java-based ETL framework that certainly can help you do what you need. You can use any JDBC driver, define your mappings with a few lines of code and have this working faster than a traditional ETL tool.

Have a read through its tutorial and also check out a few sample projects here

Disclosure: I am the author of this library. It's open-source and free (Apache V2.0 license).

Lightweight ETL or database Sync - Sybase to SQL Server

1 Answers