Devart Forums

niksloter

Thank you for quick replay. I placed file as you sugested and it helped.
Your driver seems most complete and best solution out there for getting data from MySql and created OLAP-s with MS SSAS, so if we get this client we are buying your driver

.

niksloter

I have downloaded and installed dotConnect for MySql 5.80.140.0 trial version. We need to connect MS SQL 2005 SSAS cube with large MySql database. I was able to create Data Source and Data Source View and browse data. But when I create dimensions and measures and try to deploy project to Analysis Service Server I get this error:

Code: Select all

Processing Dimension Attribute 'Title' failed.
SELECT 
		DISTINCT
	[mydb_events].[title] AS [mydb_eventstitle0_0]
		FROM 
			(
		
SELECT *   FROM events
			)
		 AS [mydb_events]
Error Messages 1
				Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: 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 '[mydb_events].[title] AS [mydb_eventstitle0_0]
		FROM 
			(
		
S' at line 3.

I have read similar post about same error but it was from 2006 and in much older version http://www.devart.com/forums/viewtopic. ... 907fa90057 . Is the solution for this problem the same?
We really need some solution to connect SSAS and MySql because our customer required that we use MySql as Data Source for SSAS so we cannot use SSIS to import data in SQL 2005 database.

Devart Forums

Search found 2 matches

MS SQL 2005 SSAS issue