Has anyone tested the ADO.NET connector "Microsoft Analysis Services integration" feature ?

François_JEHL

Hello! How to use the ADO.NET connector "Microsoft Analysis Services integration" feature? The data source creation is OK but I'm unable to create a table nor a view in a DSV, getting, depending on the case "The SchemaName could not be retrieved" of an error concerning the SQL generation of the DSV View. Thanks!

François_Jehl_1

Ok it's related to Visual Studio,you just need to manually copy the cartridge depending on your version. The DSV edition itself is quite buggy but it works, except for NUMERIC types (cf my other thread).

[Deleted User]

Hi Fracois, it seems you were able to get this working properly and for that, we're grateful! If you would like to see this process improved, be sure to suggest it in the "ideas" section of this community.

François_Jehl_1

Yes it "works" except for some datatypes, cf my other thread you replied to. (https://community.vertica.com/vertica/topics/microsoft_sql_server_analysis_services_problems_with_floating_point_datatypes). I think you could add support for SQL Server 2012 just by copying your SSAS cartridge to the appropriate Visual Studio subfolder. My other problem is not linked to a SQL Server version (error reproduced on SQL Server 2008).