Silent Installation for Vertica Driver (ODBC)

Kaito

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,

Jim_Knicely

Hi,

For Windows?

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/ConnectingToVertica/InstallingDrivers/Windows/SilentlyInstallTheClient.htm

Kaito

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

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

Thank you, Jim!

Kaito

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

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