SQL server to Vertica UDL

Moderator: NorbertKrupa

Post Reply
User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

SQL server to Vertica UDL

Post by nnani » Fri Apr 25, 2014 10:13 am

Hello all,

after trying the ODBC loader package and no success at it while installation, I m turning towards Vertica UDL.

Before going to it, I just wanted to get a few things cleared
1. Can I use Vertica UDL to stream data from SQL server into Vertica directly using ODBC ?
2. Can a Vertica UDL be a polymorphic function ( one with dynamic number of arguments, max 32)
3. Do I need to create all three components ( SOURCE, FILTER, PARSER)
4. Any simple example to create one
5. Do I need to use SQL Server API to connect to SQL server and fetch data or Vertica API

Thanks
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica User Defined Functions (UDFs)”