Does Sybase have its own ETL tool?

Posted on 2011-10-14
Last Modified: 2012-05-12
Does Sybase have its own ETL tool?  I heard there is something called Sybase Data Loader, but I don't have a chance to really look at tool.  Anyone can help to explain to me a little bit?  Thanks.
Question by:thomaszhwang
    LVL 24

    Accepted Solution

    Sybase's industrial-strength ETL tool is Informatica. That's a true ETL tool in that it allows you very complicated logic for how to extract from source data, and transform it beyond recognition. It is overkill for most scenarios - unless you're talking about a brand new greenfields data warehouse where data has never before existing in this form, in which case it probably saves time. Expect a fairly steep learning curve, but this tool can do just about anything.

    At the opposite end of the scale is Sybase's "bcp". This is a free tool bundled with Sybase ASE and all it does is move data from a file to a table, or from a table (or view) to a file, one object at a time. It has no transformation ability for loading data into ASE, but note that being able to bcp out of a view means for data extracts you now have a fair bit of transformation possibilities.

    The brand new Data Loader was introduced as part of Sybase ASE's IMDB (in memory database) premium option, and is intended for loading up a transient in-memory database from a (fairly) static template database. That said you can also use it for other traditional data loading tasks. Note I say loading - it's basically like bcp, in that it does extracts and loads but no transformation.

    There are plenty of third party tools out there, most of them cheaper than Informatica and more flexible than bcp. That said, it really isn't that difficult to do basic transformation either at the operating system level, or if there's any kind of filtering or aggregation going on, stage the raw data in your database and do the transformation there.

    Tell us more about your problem and what you're trying to solve?
    LVL 2

    Assisted Solution

    Just to add to Joe's comments, Sybase has its own ETL tool (called "Sybase ETL") which is a separate licensable option to the IQ product.  It can do many of the things Informatica does, including create IQ binary loader files, whereas the loader files produced by Informatica are not optimised for use with IQ.  Worth a look if your budget does not extend to "the full blown ETL engine" provided by Informatica.  


    LVL 24

    Assisted Solution

    by:Joe Woodhouse
    Good point, forgot about that one!!

    Author Comment

    Isn't Informatica a separate company?
    LVL 24

    Assisted Solution

    by:Joe Woodhouse
    I guess so... and Sybase resells it. drittenh has reminded us about Sybase's own Sybase ETL tool.

    Author Closing Comment


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
    DECT technology has become a popular standard for wireless voice communication. DECT devices are not likely to be affected by other electronic devices and signals because they operate in a separate frequency-band.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now