Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring the Data Sources for Oracle Business Intelligence >

Process of Changing the Oracle BI Database Settings

The database you use with Oracle Business Intelligence may require that you change the Oracle BI database type or database connections settings. If this is the case for your deployment, perform the following tasks:

• Verify the database type and connection properties.
  • Physical database type.

    See the topic Changing the Oracle BI Database Type. For more details, see the topics about setting up database objects in Oracle Business Intelligence Server Administration Guide.

  • Database connection properties.

    Your operational application repository contains preconfigured database connections. You must reconfigure database connections to match your environment. See the following topics:

    • Changing the Oracle BI Database Connection Pool Settings

      For more details, see the topics about setting up and managing connection pools in Oracle Business Intelligence Server Administration Guide.

• If your deployment utilizes Virtual Private Database (VPD), see the topics on VPD in the Oracle Business Intelligence Server Administration Guide.
• If you use Oracle DBMS, you may need to perform the following tasks:
  • Configuring initialization blocks.

    Typically, initialization blocks do not have to be reconfigured if you use one of the supported database platforms, including Oracle.

  • Configuring Oracle Databases for the Oracle BI Server Under Windows
• If you use ODBC, you need to perform the following task:
  • Configuring an Oracle BI ODBC Data Source
  • Under Windows, configuring Oracle Business Intelligence ODBC Data Source Names is done through the Server Administration Tool. See the topic on configuring ODBC data source names in the Oracle Business Intelligence Server Administration Guide.

    NOTE:  For this release, the ODBC 3.5 interface is supported. The old ODBC driver has been renamed nqsodbc20.