IT Process Automation

 View Only
  • 1.  CA ITPAM database hosting details

    Posted Jul 01, 2019 01:19 PM
    Hi Team,

    So we are building the infrastructure for the implementation of PAM in one of our environments. Can we create the 3 databases required for pam namely: library, reporting and runtime on 3 different instances of MS SQL standard edition? Do these 3 Databases have any kind of data exchange or synchronisation within them.

    Please validate whether hosting them in isolation is technically feasible and healthy for the application to work on expected lines.

    Thanks for your support.
    Regards,
    Vipul Waibhav

    ------------------------------
    Vipul Waibhav,
    Automation consultant
    HCL
    ------------------------------


  • 2.  RE: CA ITPAM database hosting details

    Posted Jul 02, 2019 12:20 PM
    Hi Vipul,


    I think someone from the product development team would have to answer your question. However, I am curious why you want to host the databases on separate instances of MSSQL?

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    ------------------------------



  • 3.  RE: CA ITPAM database hosting details

    Posted Jul 03, 2019 02:28 AM
    Hi Lindsay,

    We have some cost considerations in building a SQL cluster which requires a shared storage. So for this the 'MS SQL always on' solution is proposed which will support only one database in its standard edition. The enterprise edition  supports 3 databases but its too heavy on our pocket. So either we go with MySQL or 3 different instances of MS Sql. Is there any better way of doing it? Really appreciate your assistance in this regard.

    Thankfully,
    Vipul Waibhav


  • 4.  RE: CA ITPAM database hosting details

    Posted Jul 04, 2019 10:18 AM
    If you are installing only one Orchestrator, PAM can be installed with library, reporting, runtime all using the same database.

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    ------------------------------