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

François_JEHL · May 2013

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 · May 2013

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] · May 2013

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 · May 2013

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).

We're Moving!

Create My New Community Account Now

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

Comments

Leave a Comment