Hi
I have a customer who wants to connect Reporting Services, Report Builder in particular to Postgres database.
By reading the forums, it looks like ODBC is out of picture.
Can they use some sort of .net provider etc.
I am getting the customer to ETL the data into a SQL Server ODS/Data mart
Has anyone got this working ? would like to hear from you.
Regards.. Yasin
Masestro Systems Ltd, New Zealand.
Report Builder currently works only with MS SQL databases. Semantic queries produced by Report Builder are tranbslated to TSQL and translation uses some of TSQL specifics. So sending those queries directly to any database server other than SQL will not work.
You can either pump data into MSSQL or use linked servers.
If you pump data, make sure that db schema in MSSQL has valid PKs/FKs
If you use linked servers or OPENDATASOURCE you will need to manually craft DSV, specify FKs/PKs and the generate model off it (all is done in Model Designer).
No comments:
Post a Comment