vertica programming

sreeblr

I have legacy program in C on oracle database which takes file pointers /c data structure to manipulate and load the output of the data into oracle . We now want to port to applications using vertica database . Our application layer is in  .net . To manipulate large volume of data can the legacy c program be modified to run using vertica database or will C# based program be more easy to maintain  .

Adrian_Oprea_1

 Start your jorney here https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/ExtendingHPVertica/ExtendingHPVertica.htm%3FTocPath%3DExtending%2520Vertica%7C_____0

sreeblr

yeah i did create sample code using create library but felt it was bit cumbersome. Can we instead use C# /ODBC/ADO.net to do it like a normal c program?

eli_revach

Hi

My understending is that you like to run your program as it run today for Oracle  , for that you can used ODBC and ADO.NET both are suported  by Vertica .

 

Vertica extention ( SDK ) is less of what you needs 

 

See some reference  ODBC for https://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/ConnectingToHPVertica/InstallingDrivers/CreatingAnODBCDSNForLinuxSolarisAIXAndHP-UX.htm

 

https://gist.github.com/dbb613/e76230a1c58af4e02b14

 

I hope you will find it useful

 

Thanks