RE: SSO: SAP BW – Crystal 2011 – BOE 4.0

      Hi,

      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?

      Thanks,

      Hi Leo,   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…

      User Rating: Be the first one !
      Add Comment
      1 Answers

        Hi Leo,

         

        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.

        Regards,

        Harald

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.