Hi,
we need access with Microsoft SQL Server Tools (namly Analysis Server) to our Bizgres (http://www.bizgres.org, Postgres variant for data warehousing). While Adding a new data source I get the following error:
Tested with newst 2.50 Build and 3.00 Beta 2.
What can we do?
===================================
syntax error at or near "[" (Microsoft Visual Studio)
------------------------------
Program Location:
at CoreLab.PostgreSql.PgSqlCommand.a(Boolean A_0, Int32 A_1, Int32 A_2)
at CoreLab.Common.DbCommandBase.c(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType)
at Microsoft.AnalysisServices.Design.DSVUtilities.ExportDataSet(DataSourceView& dsv, DataSourceConnection conn, ArrayList tableList, ArrayList viewList, ArrayList sysTableList, ArrayList sysViewList, IServiceProvider serviceProvider, ProgressBar progressBar)
at Microsoft.AnalysisServices.Wizards.DSVWizardForm.OnFinish(CancelEventArgs e)
Could not connect with MS Analysis Server to Bizgres
PostgreSQL & MS SQL Server Analysis, Reporting, Integration Services
We've encountered the same problem with both drivers listed above.
After connecting successfully to a PostgreSQL instance from MS SQL Analysis Services (SSAS) SQL Server Business Intelligence Development Studio when selecting tables (new data source view in SSAS) the app/driver ended up quoting all identifiers in brackets [] (Old SQL Server syntax) instead of the standard doublequotes “”. So queries looked like SELECT * FROM [public].[mytable], and get a syntax error from the system.
Is it possible the driver was setup incorrectly?
To reproduce would require downloading MS SQL Server 2005 Standard Trial & installing the client tool SQL Server Business Intelligence Development Studio Trial.
Create new SSAS 'Project' within SQL Server Business Intelligence Development Studio using PostgreSQLDirect .NET & define connection to PostgreSQL server (test schema --> table test (a int) <-- 1)
Create new 'Data Source', select any test table , click 'Finish'. Error should present.
After connecting successfully to a PostgreSQL instance from MS SQL Analysis Services (SSAS) SQL Server Business Intelligence Development Studio when selecting tables (new data source view in SSAS) the app/driver ended up quoting all identifiers in brackets [] (Old SQL Server syntax) instead of the standard doublequotes “”. So queries looked like SELECT * FROM [public].[mytable], and get a syntax error from the system.
Is it possible the driver was setup incorrectly?
To reproduce would require downloading MS SQL Server 2005 Standard Trial & installing the client tool SQL Server Business Intelligence Development Studio Trial.
Create new SSAS 'Project' within SQL Server Business Intelligence Development Studio using PostgreSQLDirect .NET & define connection to PostgreSQL server (test schema --> table test (a int) <-- 1)
Create new 'Data Source', select any test table , click 'Finish'. Error should present.