How can i connect Vertica to VS code editor ?
Anna
Vertica Customer
How can i connect Vertica to VS code editor ?Hi there!
By using MS VS-Code you able to query data from MY SQL Server or Mongo DB etc.
How can i connect Vertica to VS code editor to query data?
Also, you could access Vertica direct out from EXCEL by using ODBC. Otherwise, may be possible to connect VS code through ODBC
Tahks a lot!
Tagged:
0
Answers
@Anna: If VS is Visual Studio, then we have a plugin for it. Did you install vertica client drivers for windows to connect to vertica? If so, you should have VS Studio plugin installed already. please find the below link for downloads and VS Studio limitations
https://www.vertica.com/download/vertica/client-drivers/
https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/ConnectingToVertica/InstallingDrivers/Windows/TheVisualStudioPlugIn.htm
Hi Anna,
Greetings! Herewith, please find attached the document that contains steps with inclusions of relevant snapshots that will guide you to connect VS Code with Vertica.
Many Thanks
Best Regards/Vivek
Hi Anna,
Greetings! Herewith, please find attached the document that contains steps with inclusions of relevant snapshots that will guide you to connect VS Code with Vertica.
Many Thanks
Best Regards/Vivek
Open the VS Code editor and click Extensions.
Ensure you download the following extensions: ...
Click Install to install both the extensions.
Click SQLTools.
Click Add new connection.
Select and click PostgreSQL.
Enter the Vertica database connection details:
Click TEST CONNECTION.. .