RE: SSO: SAP BW – Crystal 2011 – BOE 4.0
I have delevoped a Crystal 2011 report which is connected to SAP BW. In turn I publish this report to BOE 4.0.
The users login using BOE usernames/password as they do not have a BW logon. So that the the user is not prompted for a username and password I have go to the Crystal Report in CMC and right click on it and select Database configuration – i set the username /password in here.
is there a way to avoid having to set the username and password for each report in this manner?
this is a security feature and is “by-design” to prevent unauthorized users to get hold on information from a source system, they are not authorized to see.
You could either make sure all users that run that report on-demand have a SAP BW user and use SSO or you could use Crystal Reports for Enterprise and utilize a central connection to your BW system with predefined username and password. Or maybe you could write a script you can run on your system that automatically sets the desired username/password on a bunch of reports.
Or if you do not need personalized data, just schedule the report with an authorized user and let the other users use the generated instance.