ODBC in Windows
Moderator: NorbertKrupa
ODBC in Windows
Hi, Can we connect to Vertica using ODBC in windows? That is, can we use something like Excel to connect?
Thank, Fred
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: ODBC in Windows
Hi,
You can connect to a Vertica database in MS Windows via the Vertica ODBC driver which is bundled with the JDBC driver in the 32-Bit and 64-Bit Windows Client software available for download from Vertica's website. Installation of the software is pretty straight forward, just make sure the bit count of the version you are installing is correct for your version of Windows!
Once you have the client software installed you'll want to set up a DSN (Data Source Name) in the ODBC Data Source Administrator Windows component which you can get to under the Administrative Tools program group in the Control Panel. You can also open the run dialog box and type ODBCAD32.EXE...
In the Administrative Tools click the "Add" button and you'll get to the "Create a New Data Source" screen:
When you click the Finish button you'll see a screen similar to this (if you chose the 4.1.19 drivers):
Once you complete the form data you can test the connection with the Test Connection button.
Open a blank workbook and click on the "From Data Connection Wizard" menu item as shown here:
This is a very simple example. Play around in Excel and you'll find that you can write your own very detailed queries to pass through the ODBC driver to get any results back you'd want from Vertica.
Have fun!
You can connect to a Vertica database in MS Windows via the Vertica ODBC driver which is bundled with the JDBC driver in the 32-Bit and 64-Bit Windows Client software available for download from Vertica's website. Installation of the software is pretty straight forward, just make sure the bit count of the version you are installing is correct for your version of Windows!
Once you have the client software installed you'll want to set up a DSN (Data Source Name) in the ODBC Data Source Administrator Windows component which you can get to under the Administrative Tools program group in the Control Panel. You can also open the run dialog box and type ODBCAD32.EXE...
In the Administrative Tools click the "Add" button and you'll get to the "Create a New Data Source" screen:
When you click the Finish button you'll see a screen similar to this (if you chose the 4.1.19 drivers):
Once you complete the form data you can test the connection with the Test Connection button.
Open a blank workbook and click on the "From Data Connection Wizard" menu item as shown here:
This is a very simple example. Play around in Excel and you'll find that you can write your own very detailed queries to pass through the ODBC driver to get any results back you'd want from Vertica.
Have fun!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: ODBC in Windows
may i ask how do you sever name ? Do you create your own ? if yes how can i create ? How do you do about the database also please kindly help me : ( very impportant .Thanks you
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Re: ODBC in Windows
What do you mean ?khine wrote:may i ask how do you sever name ? Do you create your own ? if yes how can i create ? How do you do about the database also please kindly help me : ( very impportant .Thanks you
Is if you need a running database on server ! is this ?
Last edited by adrian.oprea on Tue May 07, 2013 11:08 pm, edited 1 time in total.
trying so hard !!!
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: ODBC in Windows
Yeah, the "server name" is the Vertica database server name...
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: ODBC in Windows
How do i know sever name ? Sorry for stupid question By the way i am using community edition.