1 Reply Latest reply on Dec 4, 2017 6:20 PM by Bill Robinson

    Reporting Server for BSA

    Siddharth Mahajan



      I need to install Reporting server for BSA, I want to use same db which BSA is using, can I do that or I will have to install separate db server for it?

        • 1. Re: Reporting Server for BSA
          Bill Robinson

          what kind of database server are you using - oracle or sqlserver ?



          for oracle bsa and bdssa (and bdssa_portal) must all be in separate instances if they are on the same system.


          for sqlserver that's not an issue.



          the reason for separating them on different database services is performance.  if you plan to have a high usage site for bsa and bdssa you need to have a database server that can handle whatever load you are throwing at it.  running lots of jobs and running an ETL all at the same time is very resource intensive.  so that can work fine on a single database server given the right hardware or you might need separate systems.


          Bill Robinson

          BMC Software