Syntax error / SSAS
Posted: Wed 30 Oct 2013 11:14
Hi,
I'm trying to create a Cube in SQL Server using devArt connector for PostgreSQL.
Im using SQL Server 2008 R2 x64 and Visual Studio 2008 Business Intelligence Studio and Analysis Service project.
Creating Data Source is ok and connection test is ok. Retrieveing tables works too. But when Analysis Service tries to refresh data by querying it devArt connector fails with error "syntax error at or near "["." This is becasue SSAS is adding brackets to query automatically. I can't modify query as it is dynamically generated by runtime.
This is very likely same problems that has been here on these forums a couple of times before with MySQL:
http://forums.devart.com/viewtopic.php?t=10211
http://forums.devart.com/viewtopic.php?t=18233
I have downloaded both free and trial versions but both have same error. I'm trying to evaluate this connector for our company needs.
I'm trying to create a Cube in SQL Server using devArt connector for PostgreSQL.
Im using SQL Server 2008 R2 x64 and Visual Studio 2008 Business Intelligence Studio and Analysis Service project.
Creating Data Source is ok and connection test is ok. Retrieveing tables works too. But when Analysis Service tries to refresh data by querying it devArt connector fails with error "syntax error at or near "["." This is becasue SSAS is adding brackets to query automatically. I can't modify query as it is dynamically generated by runtime.
This is very likely same problems that has been here on these forums a couple of times before with MySQL:
http://forums.devart.com/viewtopic.php?t=10211
http://forums.devart.com/viewtopic.php?t=18233
I have downloaded both free and trial versions but both have same error. I'm trying to evaluate this connector for our company needs.