DX Operational Intelligence

Expand all | Collapse all

Is there a way to log into CABI from SOI Dashboard w/o creds

Jump to Best Answer
  • 1.  Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 03-08-2018 11:36 AM

    Hello,

    I was wondering is there a way to configure a customer account such that when they are logged into the SOI Dashboard, when they click on any of the graphs in the bottom section (Quality, Risk, Health) that it automatically logs into the CABI reporting pages w/o having to enter all the info? 

    This needs to be simplified for end user customers. They have 1 set of creds for the SOI dashboard then if they want to view reports they have to then enter their specific CABI creds; organization, username, passwords.

    Can this be skipped somehow? 



  • 2.  Re: Is there a way to log into CABI from SOI Dashboard w/o creds
    Best Answer



  • 3.  Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 03-21-2018 10:14 AM

    Ahh thanks Michael... Did not know what this was called so didn't know to search fro this specifically..

    But this might do it. Thank you...

     

    For Reference:

    Configure CA SOI Reports Single Sign-On

    Single sign-on (SSO) is available for reports, so that you can run reports from the CA SOI Dashboard without providing the login credentials for CABI JasperReports Server. You can still access reports without SSO configured, but you need to enter the login credentials each time. 

    Perform following steps in the system where CA SOI Reports is installed:

    1. Browse to the following location: <SOI_REPORT_HOME>\Reports\deploy\keystore.
    2. Open the soi.properties file, type plain password value in place of "<STORE_PASSWORD>" against key "ks.storepass", and save the file.
      Example: ks.storepass=jasper-soi-encrypt
    3. Browse to the following location: <SOI_REPORT_HOME>\Reports\deploy
    4. Execute the jkscreation.bat file to create the jks file.
    5. Create a folder and name it as "config" in the following location: <Jaspersoft Install Folder>\<tomcat folder>\webapps\<Jasper_Instance_Name>\WEBINF\
      Example: D:\Program Files (x86)\CA\SOI\Reports\jr\apache-tomcat-7.0.68\webapps\jasperserver-pro\WEB-INF 
    6. Copy soi.jks and soi.properties from the following location: <SOI_REPORT_HOME>\Reports\deploy\keystore and paste to the location <Jaspersoft Install Folder>\<tomcat folder>\webapps\<Jasper_Instance_Name>\WEB-INF\config\
    7. Restart CABI JasperReports Server.

    Perform the following steps in the system where CA SOI UI Server is installed:
    Do these steps after you configure single sign-on in the CA SOI Reports system. 

    1. Copy soi.jks and soi.properties file from the CA SOI Report system and paste it at any location.
      Example: C:\Program Files\CA\SOI\SSO
    2. Create an environment variable named CA_TRUSTEDAUTH_HOME and set the path where jks and properties files is copied in Step 1.
      Example: CA_TRUSTEDAUTH_HOME=C:\Program Files\CA\SOI\SSO
    3. Restart the CA SOI User Interface service.


  • 4.  Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 03-21-2018 11:51 AM

    Michael, any change you know what password they are referring to in step 2 above?

     

    2. Open the soi.properties file, type plain password value in place of "<STORE_PASSWORD>" against key "ks.storepass", and save the file.

    Example: ks.storepass=jasper-soi-encryp

     

    Which password is the doc asking for here?



  • 5.  Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 03-22-2018 02:50 AM

    Hi Dan,

    you can choose whatever you want in this password.

    It is none of the existing passwords from the system, but only used on both sides of the communication SOI-CABI.

     

    MichaelBoehm



  • 6.  Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 03-23-2018 09:21 AM

    Thanks Michael. I configured this and got this working! Nice thank you...



  • 7.  RE: Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 07-18-2019 11:01 AM
    Hello ,

    I did same configuration but it is not working. is there anything else to be done ?
    SOI version is 4.2 with no additional patches installed.
    CA Business Intelligence 6.3.0
    SOI Reports : Used from SOI 4.2 install media
    OS : Windows Server 2016

    Thanks !


  • 8.  RE: Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 07-18-2019 12:32 PM
    Hi Mukul, its works depending on what you click on. If you click on the "Reports" link at the top it will bring you to the login page and ask for credentials. 
    If you click on any of the Quality / Risk / Availability SLA graphs on the bottom portion, it will bring you to that specific report in CABI w/o prompting.

    ------------------------------
    Daniel Blanco
    Enterprise Tools Architect
    Alphaserve Technologies
    ------------------------------



  • 9.  RE: Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 07-19-2019 04:25 AM
      |   view attached
    Hi Mukul,

    Yes, What Daniel said is correct. 
    If you click on "Reports" link this single sign on doesn't work. 
    So, you need to select a service and then click on any graph|chart like Quality, Risk etc, it should work.

    I've uploaded a word document with screenshots for your reference.

    Hope this helps.

    Thanks
    Brahma

    Attachment(s)

    docx
    SOI-Jasper-SSO.docx   1.52MB 1 version


  • 10.  RE: Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 07-19-2019 11:48 AM
    Thank you Daniel and Brahma !!

    This is working now as you guys suggested. Thanks Brahma for the reference document.


    Regards
    Mukul


  • 11.  RE: Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 07-23-2019 05:36 AM
    Hello Daniel and Brahma,

    I had one more query regarding CABI though it is not related to SSO but with SOI Reports.
    Can we create some Customized reports other than available templates in SOI Reports ? e.g. from CABI, making connection to SOI Database and then running queries to form reports or is there any other process.

    I also read article about Jasper Studio, is it recommended to use that for creating SOI reports?

    Thanks !
    Mukul


  • 12.  RE: Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 07-23-2019 06:05 AM
    Hi Mukul,

    Yes, it is possible to create custom reports using Jasper Studio. It depends on the requirement whether to create custom reports or not, out of the box reports would give CI, Service etc details, so if your customer is looking for data which is not available in OOTB reports, then you may go for custom reports.

    Thanks
    Brahma


  • 13.  RE: Re: Is there a way to log into CABI from SOI Dashboard w/o creds

    Posted 07-24-2019 02:17 AM
    Thanks Brahma !!


    Regards
    Mukul