Devart Forums

We have licensed version of the dotConnect for MySQL data provider. So far we were using Sql Server 2012 and its corresponding products SSRS, SSAS. We don't use the relational storage of SQL server, but MySQL instead (for reasons I won't explain) and that is why we need dotConnect. It was working fine until we migrated to SQL Server 2014.

When trying to process OLAP cube we receive the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[XXX_D_ACQUIRER].[acquirer_id] AS [XXX_D_ACQUIRERacquirer_id0_0],[XXX' at line 3.

Obviously the problem lies with the '[' while the correct SQL produced shall be like this (working fine on SSAS 2012 and SQL Management Studio 2012):
SELECT
DISTINCT
`XXX_D_ACQUIRER`.`acquirer_id` AS `XXX_D_ACQUIRERacquirer_id0_0`,`XXX_D_ACQUIRER`.`acquirer_name` AS `XXX_D_ACQUIRERacquirer_name0_1`
FROM `XXX`.`D_ACQUIRER` AS `XXX_D_ACQUIRER`

Is this a known bug ot what could possible went wrong when we migrated to SSAS 2014? Is there a way arround this issue?

Thanks

Unfortunately, SSDT-BI for Visual Studio 2013 is currently not supported. We will notify you when the corresponding support is implemented.
As a temporary workaround, please use the dotConnect for MySQL SSIS components in VS 2008, 2010, or 2012.

The new build of dotConnect for MySQL will include the following improvements:

• Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
• SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013

We will notify you when the corresponding build is available for download.

New build of dotConnect for MySQL 8.3.379 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=2&t=31497.