Using SSAS with a Vertica database
Posted: Sat 06 Mar 2010 14:33
I have a Vertica Analytical database with large volumes that I want to use with MS SSAS for both cube creation and data mining.
I am able to connect to the database through their ADO.NET driver at the data source view, however when I try to run a mining application within SSAS I get an error as SSAS generates SQL code to the MS spec with square brackets [] around the table and field names.
I have read the information on your dot connect universal product and would like to know if this product would solve my problem.
tdeane
I am able to connect to the database through their ADO.NET driver at the data source view, however when I try to run a mining application within SSAS I get an error as SSAS generates SQL code to the MS spec with square brackets [] around the table and field names.
I have read the information on your dot connect universal product and would like to know if this product would solve my problem.
tdeane