Skip to main content
Question

How can i connect Vertica to VS code editor ?

  • May 13, 2022
  • 4 replies
  • 6 views

Anna

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!

4 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • May 13, 2022

@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


VivJain
Forum|alt.badge.img
  • Participating Frequently
  • May 17, 2022

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


VivJain
Forum|alt.badge.img
  • Participating Frequently
  • May 17, 2022

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


pasterzop
  • New Participant
  • September 27, 2022

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.. .