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 Vertica Employee 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