Could not connect with MS Analysis Server to Bizgres

Could not connect with MS Analysis Server to Bizgres

Postby happyarts » Fri 02 Mar 2007 08:54

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)
happyarts
 
Posts: 1
Joined: Fri 02 Mar 2007 08:48

Postby Alexey » Fri 02 Mar 2007 11:52

Send us small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

PostgreSQL & MS SQL Server Analysis, Reporting, Integration Services

Postby pshsm » Tue 24 Apr 2007 23:33

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.
pshsm
 
Posts: 1
Joined: Tue 24 Apr 2007 23:18

Postby Alexey » Wed 25 Apr 2007 07:35

Unfortunately, I couldn't reproduce any error. Make sure you are using released version. Also your steps are unclear, because creating data source process doesn't allow to select any tables. Please advise.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL