Suggestions for how to make this work?

Moderator: NorbertKrupa

Post Reply
doug_harmon
Beginner
Beginner
Posts: 36
Joined: Fri Feb 17, 2012 6:09 pm
Contact:

Suggestions for how to make this work?

Post by doug_harmon » Fri Feb 24, 2012 5:19 pm

SSAS 2008 R2 requires a .Net or OLE DB data provider for the data source.
Vertica has ODBC and JDBC drivers.
I don't think SSAS can connect to Vertica, but would welcome any suggestions on how to make this work.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Suggestions for how to make this work?

Post by JimKnicely » Fri Feb 24, 2012 10:18 pm

Hi,

Unfortunately the ADO.NET driver isn't included in the Vertica 5.1 client drivers. But you should be able to use an OLEDB to ODBC bridge (via MSDASQL) or simply use the legacy Vertica 4.1 client drivers. We use the 4.1 drivers against a 5.0 server, and the documentation says that the 4.1 drivers will also work with the 5.1 server.

Hope this helps.

Thanks!
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Microsoft SQL Server Analysis Services (SSAS)”