Has anyone tested the ADO.NET connector "Microsoft Analysis Services integration" feature ?
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!
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).
+2Hi 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.
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).
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
