Report Builder/SRS connectio to Postgres

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).

Report Builder 401

When attempting to run Report Builder I get error below. After reading
earlier posts I have tried several combinations on the File Security
properties of the 6 Report Builder files and seem to get the furthest (I get
the Application Run - Security Warning dialog) while enabling Anonymous
access using the Report Server service account and also using Authenticated
access (Integrated Windows Authentication). I also tried changing the
RSWebApplication.Config from FullTrust to Partial Trust but that did not work.
Thanks in advance for any help
Please note that unlike earlier posts I have a Win32Exception at the end of
the error detail.
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.application
Server : Microsoft-IIS/6.0
X-Powered-By : ASP.NET
X-AspNet-Version: 2.0.50727
Application url :
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.exe.manifest
Server : Microsoft-IIS/6.0
X-Powered-By : ASP.NET
X-AspNet-Version: 2.0.50727
IDENTITIES
Deployment Identity : ReportBuilder.application, Version=9.0.2047.0,
Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=msil
Application Identity : ReportBuilder.exe, Version=9.0.2047.0,
Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=msil,
type=win32
APPLICATION SUMMARY
* Online only application.
* Trust url parameter is set.
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/reportbuilder.chm.deploy did not succeed.
+ The remote server returned an error: (401) Unauthorized.
+ The logon attempt failed
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [8/9/2006 11:26:32 PM] : Activation of
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/ReportBuilder.application has started.
* [8/9/2006 11:26:32 PM] : Processing of deployment manifest has
successfully completed.
* [8/9/2006 11:26:32 PM] : Installation of the application has started.
* [8/9/2006 11:26:32 PM] : Processing of application manifest has
successfully completed.
* [8/9/2006 11:26:35 PM] : Request of trust and detection of platform is
complete.
ERROR DETAILS
Following errors were detected during this operation.
* [8/9/2006 11:26:35 PM]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://reporting.voyagerlearning.com/ReportServer/ReportBuilder/reportbuilder.chm.deploy did not succeed.
- Source: System.Deployment
- Stack trace:
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at
System.Deployment.Application.FileDownloader.Download(SubscriptionState
subState)
at
System.Deployment.Application.DownloadManager.DownloadDependencies(SubscriptionState
subState, AssemblyManifest deployManifest, AssemblyManifest appManifest, Uri
sourceUriBase, String targetDirectory, String group, IDownloadNotification
notification, DownloadOptions options)
at
System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState
subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory&
downloadTemp)
at
System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState subState, ActivationDescription actDesc)
at
System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at
System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
-- Inner Exception --
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at
System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
-- Inner Exception --
System.ComponentModel.Win32Exception
- The logon attempt failed
- Source: System
- Stack trace:
at System.Net.NTAuthentication.GetOutgoingBlob(Byte[] incomingBlob,
Boolean throwOnError, SecurityStatus& statusCode)
at System.Net.NTAuthentication.GetOutgoingBlob(String incomingBlob)
at System.Net.NegotiateClient.DoAuthenticate(String challenge, WebRequest
webRequest, ICredentials credentials, Boolean preAuthenticate)
at System.Net.NegotiateClient.Authenticate(String challenge, WebRequest
webRequest, ICredentials credentials)
at System.Net.AuthenticationManager.Authenticate(String challenge,
WebRequest request, ICredentials credentials)
at System.Net.AuthenticationState.AttemptAuthenticate(HttpWebRequest
httpWebRequest, ICredentials authInfo)
at System.Net.HttpWebRequest.CheckResubmitForAuth()
at System.Net.HttpWebRequest.CheckResubmit(Exception& e)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.Never mind. Just use How to Enable Anonymous Access on the ReportBuilder
Folder in Configure a Report Server for Report Builder Access

replication/database mirroring

After reading about it, i'm still confused. Is replication and database mirroring the same? they seem to accomplish the same thing.No they are not the same. They are different technologies to attain high availability. While in Replication, the subscriber is available for querying and for reporting purposes, the mirrored DB is inaccessible. You can however create a snapshot of the mirror and use the snapshot Db which is in read only mode. Check out BOL for more differences.|||Additionally some flavors of Tran replication and Merge replication allow writes at subscribers and conflict detection/resolution.