migrate oracle data to vertica using squirrel

Hi,

   Generally most of the people use either squirrel or DbVisualizer to migrate data to vertica. You can download them from 

 http://www.dbvis.com/

http://squirrel-sql.sourceforge.net/

-Regards,

 Sruthi

i try it with squirrel using copy paste bt it didnt work

What do you mean by copy paste?? Could you give more insight on it?? Please have a look at the following URL to connect to vertica using Squirrel

https://tomgendron.wordpress.com/2011/08/26/connection-to-vertica-with-squirrel-sql-client/

-Regards,

Sruthi

I have another query would you please help me? recently i started work on vertica. 

Sure. Please let me know. if I can I will help you.

-Regards,

 Sruthi

I installed vertica at one machine by using Virtual Box and Install centos on that. But now I want to install vertica on clusters i mean on three machines. so how to create three machines of centos for vertica. 

Follow this how-to to see how you can install a Vertica Database 3 node cluster 

Vertica 3 node Cluster Install on CentOS.

But you should also go thru the oficial documentation. 

yeah i already see this link. but this is about server installation. i want to knw abt otherz node. should i have to install Virtual box then centos and vertica as well over there. like we did at server.

Hi,

   Are you using Oracle VirtualBox? if so, did you create VM's on VirtualBox and then installed centOS on all VM's?

-Regards,

 Sruthi

Ok , 

Here is tutorial on how this can be done :

Creating Vertica Sandbox Environment

Norbert crated this nice tuts on how you can create a simple Vertica cluster enviroment.