Skip to main content

vertica programming

  • March 8, 2016
  • 3 replies
  • 10 views
sreeblr
Forum|alt.badge.img+2

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  .

    3 replies

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • March 8, 2016

     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
    Forum|alt.badge.img+2
    • sreeblr
    • Author
    • Participating Frequently
    • March 9, 2016

    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
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • March 9, 2016

    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 

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement