Skip to main content

Silent Installation for Vertica Driver (ODBC)

  • June 15, 2018
  • 5 replies
  • 16 views

Kaito
Forum|alt.badge.img+2
  • Participating Frequently

Do we have any workaround or enhancement plan to install Vertica with silent installation option?

My prospect wants to deploy Vertica ODBC Driver for 800 clients automatically.

Thanks in advance,

5 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 15, 2018

Kaito
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • June 19, 2018

Thank you, Jim. This customer wants to install the driver on Windows environments.

I have one more question. Do you know how to set up a connection info at ODBC DSN using slient install or command line?

Thanks in advance,


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 19, 2018

Vertica won't create a DSN for you on client machines. Maybe look into Windows "Group Policies"? The system admin should be able to push a DSN out to clients using Vertica.


Kaito
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • June 20, 2018

This command-line works fine at Windows environment.


odbcconf /S /A {CONFIGSYSDSN "Vertica" "DSN=VerticaSilentTest|Servername=192.168.1.146|UID=dbadmin|PWD=password|PreferredAddressFamily=none"}



Kaito
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • June 20, 2018

odbcconf /S /A {CONFIGSYSDSN "Vertica" "DSN=VerticaSilentTest1|Servername=192.168.1.146|UID=dbadmin|PWD=password|PreferredAddressFamily=none|Database=Vmart"}