We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


I want to export Sybase data to Vertica, that what is the fastest tool this work??? — Vertica Forum

I want to export Sybase data to Vertica, that what is the fastest tool this work???

Hi

 

I want to  export Sybase data to Vertica

 

So, now I used pentaho... but

 

pentaho is too slow....because pentaho work in local, but My computer is not good.

 

then... What is the fastest tool in this work?????

 

plz help me...

Comments

  • SruthiASruthiA Administrator

    Hi,

     

        Please go through the below URL which contains discussion on Sybase to Vertica Migration. It will be helpful

     

     

    https://community.dev.hpe.com/t5/Vertica-Forum/Sybase-IQ-to-vertica-Migration/td-p/217751

     

     

    Some pointers from that URL which will be helpful to you are

     

    ll these tools will require a JVM, so JVM should be configured properly too (at least memory&heap)

    Pentaho

    • performance - not a best
    • best community,
    • documentation is very good
    • IMO: job flow  in Pentaho looks very complex and scary
    • Enterprise edition very expencive


    Talend

    • performance  - medium(Ab Initio much more better :)
    • Job Flow looks much more cleaner
    • community - 6/10 (see note below)
    • documentation - 3/10

    Talend documentation is very poor, i think that Talend trying to create a dependency on their support. Community is also "blind" in many aspects.


    Clover ETL

    • performance - medium
    • Job Flows - are easy
    • can be embedded
    • very good documentation

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file