13 Replies Latest reply on May 8, 2013 2:47 PM by Joyo Wijaya

Tableau Desktop 6.1 and Vertica 5.0.4

Jeremy Alexander Aug 4, 2011 3:44 PM

Installed Tableau Desktop 6.1, unable to connect to Vertica 5.0.4 via driver pack 4.1.14 (ODBC v4.01.13). Tableau Desktop 6.0 and 5.2 still connect and work fine, but 6.1 returns the following error stack:

###############################

The drivers necessary to connect to this database server are not properly installed. You may visit http://www.tableausoftware.com/drivers to download driver setup files.

Database error 0x80004005: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Unable to connect to the server "XXX". Check that the server is running and that you have access privileges to the requested database.

Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

###############################

1. Re: Tableau Desktop 6.1 and Vertica 5.0.4

Robert Morton Aug 4, 2011 5:26 PM (in response to Jeremy Alexander)

Hi Jeremy,
This is a known issue which we believe we can address in our upcoming 6.1.1 maintenance release. If you would like immediate support on this issue, please contact our support team and they can provide you more information.
-Robert
Like Show 0 Likes(0)

Actions
2. Re: Tableau Desktop 6.1 and Vertica 5.0.4

guest contributor Aug 18, 2011 2:00 PM (in response to Jeremy Alexander)

We are facing the same issue. Is there a timeline on when we can expect 6.1.1 to be released. Also for minor releases how can we be notified of updates ?

Thanks
Like Show 0 Likes(0)

Actions
3. Re: Tableau Desktop 6.1 and Vertica 5.0.4

Robert Morton Aug 18, 2011 2:08 PM (in response to Jeremy Alexander)

Hi Steven,
This problem is addressed in the 6.1.1 maintenance release which became available yesterday. You can subscribe to the Release News feed to receive announcements for maintenance releases: http://www.tableausoftware.com/forums/release-news/feed
-Robert
Like Show 0 Likes(0)

Actions
4. Re: Tableau Desktop 6.1 and Vertica 5.0.4

guest contributor Aug 18, 2011 2:10 PM (in response to Jeremy Alexander)

Great news. Thanks for the info Robert.
Like Show 0 Likes(0)

Actions
5. Re: Tableau Desktop 6.1 and Vertica 5.0.4

quinngil Aug 19, 2011 11:39 AM (in response to Jeremy Alexander)
Like Show 0 Likes(0)

Actions
6. Re: Tableau Desktop 6.1 and Vertica 5.0.4

Robert Morton Aug 19, 2011 12:50 PM (in response to Jeremy Alexander)

Tableau is a 32-bit app which requires that you install the 32-bit Vertica drivers.
-Robert
Like Show 0 Likes(0)

Actions
7. Re: Tableau Desktop 6.1 and Vertica 5.0.4

quinngil Aug 19, 2011 1:44 PM (in response to Jeremy Alexander)

Thank you, Robert. that solved my problem for 6.1.1. I didn't have the 32bit drivers installed.

I'd be curious for the reason why 6.0.7 worked with only 64bit drivers installed and 6.1.1 didn't.
Like Show 0 Likes(0)

Actions
8. Re: Tableau Desktop 6.1 and Vertica 5.0.4

Robert Morton Aug 19, 2011 1:52 PM (in response to Jeremy Alexander)

It is not possible that Tableau 6.0.7 used the 64-bit drivers, but it may have successfully used older 32-bit Vertica drivers. In 6.1 we had to introduce stricter requirements for using compatible Vertica drivers for each Vertica server version, so Tableau 6.1 was no longer able to take advantage of older drivers you had installed. You may have used 6.0.7 successfully with older Vertica drivers by not leveraging certain functionality in Tableau, but the problems were certainly present then.

-Robert
Like Show 0 Likes(0)

Actions
9. Re: Tableau Desktop 6.1 and Vertica 5.0.4

quinngil Aug 19, 2011 1:58 PM (in response to Jeremy Alexander)

That makes sense. :)
Thanks
Like Show 0 Likes(0)

Actions
10. Re: Tableau Desktop 6.1 and Vertica 5.0.4

guest contributor Sep 8, 2011 1:43 AM (in response to Jeremy Alexander)

Hi,

I got the same problem, so the only way to use the 32 bit driver for vertica in order to connect to Tableau?

Tony Li
Like Show 0 Likes(0)

Actions
11. Re: Tableau Desktop 6.1 and Vertica 5.0.4

guest contributor Sep 8, 2011 1:43 AM (in response to Jeremy Alexander)

Hi,

I got the same problem, so the only way to use the 32 bit driver for vertica in order to connect to Tableau?

Tony Li
Like Show 0 Likes(0)

Actions
12. Re: Tableau Desktop 6.1 and Vertica 5.0.4

mark.warner Apr 9, 2012 6:38 AM (in response to Jeremy Alexander)

Tableau 6.1.8 and Tableau 7.0.2 which are the fixed maintenance releases which support Vertica 5.1 via the native connector. Tableau customers should be able to get this from normal downloads. For release histories go here http://www.tableausoftware.com/support/releases.
Like Show 0 Likes(0)

Actions
13. Re: Tableau Desktop 6.1 and Vertica 5.0.4

Joyo Wijaya May 8, 2013 2:47 PM (in response to mark.warner)

I am getting this in Tableau 8 even after I installed the driver: mysql-connector-odbc-5.2.5-win32.msi

A regression perhaps?
Like Show 0 Likes(0)

Actions