this one is an excellent and very common question. The problem is not the connection to Vertica, but how SAS metadata is allowing you to authenticate against Vertica.
The trick is Authentication Domains. In short:
- you would need to set an Authentication Domain (VerticaAuth, i.e)
- then assign this VerticaAuth to the connection under the Vertica Server in the Server Manager
- to create a SAS group (i.e. SAS Vertica database usergroup), add your usergroups to this usergroup, and on the Account tab, you would need to set the user AND password for the connection, and then use this VerticaAuth on the account)
- Finally, you can update your library on the metadata: you would need to select the connection again, to refresh it, and then the user authentication. You will see the account created in the SAS Vertica database usergroup.
Starting here, and after a good refresh of the Object Spawner / Application Server, you should be able to test/validate this connection.