Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Exporting Data to Another Vertica Database encrypting password?

Vertica has a great function to export data to another Vertica database. but it has to hard code password in the sql. like: CONNECT TO VERTICA testdb USER dbadmin PASSWORD '' ON 'VertTest01',5433;

Has anything like oracle dblink, username and password was encrypting in db level vs in script level?
or how can encrypting password when we do export.

We can not use this in the script, it is against the company's security policy.

Anyone has the solution?

thanks

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.