Skip to main content

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

  • March 30, 2016
  • 1 reply
  • 11 views

choisika
Forum|alt.badge.img+1

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...

1 reply

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • March 31, 2016

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