Suggestions for how to make this work?

[doug_harmon]

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.

[JimKnicely]

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!