Skip to Content
author's profile photo Former Member
Former Member

Database

During the installation of BOE XI 3.1, we're choosing to use the default Database, which is MySQL.

Now if we would like it to be move and use SQL Server / Oracle, can we do it? How? Any impact?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Sep 30, 2010 at 03:34 AM

    Yes, it could be done in two steps.

    1: Use update data source under configuration tab of SIA properties in CCM to create a new cms db

    2: Once you have ed pionted the CMS db to the required new database, stop the SIA, go to the properties -> configuration tab -> Specify db -> copy data from another data source and provide the required details and pointto you My Sql db.

    Regards,

    Ramu.

    Edited by: Gowda Timma Ramu on Sep 30, 2010 10:16 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      >

      > In that case, I think I will just choose to install the Audit database during installation.

      > Another thing is the BOE Admin Document also mention about the "Reporting Database".

      > But during the installation, I dont get to see this option at all.

      > Do you know where I can get it?

      .

      The BOE Audit Documents will be queried on the Audit Databse you are confguring during installation. that is also called as "Reporting Databse" for Audit Docuemnts

      >

      > Also, instead of using SQL Server (which required us to create ODBC as your steps), what about if we're using Oracle database? Do we need to create the ODBC with the same steps?

      > Any other thing need to take note?

      .

      You have to install oracle client first and then updated the tnsnames.ora file with the Oracle Database server details.

      Regards,

      Ramu.

  • Posted on Sep 30, 2010 at 02:42 AM

    Hi,

    Could you be more specific what you mean by move.

    If you are looking at the impact of installing the BOE to any other DB's apart from the default DB then i think there should not be any issues and make sure you are following the proper admin or install guide for this.

    -Noor.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2010 at 08:43 AM

    No impact by changing default DB to any Database.

    Steps are listed out in previous posts.

    if you are in :

    Oracle: Use TNSNAMES.ora file to know the Oracle Service Name.

    SQL Server: Create System DSN or OLEDB also work.

    Thank You!!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.