You have two options:
Options 1: (Exiting BI 4.0 w/ SP4+ Install, migrate Derby Database)
If you have existing data in your Derby trending database, you will need to migrate the Derby database to the auditing database, and then configure the BI platform to record monitoring information in the auditing database. These are the high-level steps you'll need to follow. For details, see the related topics.
Option 2: (New BI 4.0 w/ SP4 Install, No Data in Derby Database)
If you do not have data in your trending database, that is, you have a fresh installation, you do not need to migrate the database; you only need to configure the BI platform to record monitoring information in the auditing database. These are the high-level steps you'll need to follow.
Logon into CMC > Application > Monitoring Application Properties > Export
For best results Export Data to CSV. If you a cluster BI Platform environment then export data from most heavy used server environment and you should only import the data from one Derby instance. Importing data from multiple Derby instances will result in data inconsistency and is therefore not recommended.
Date will be export in CSV format to the default location of the Derby Trending Database folder, located in \SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\TrendingDB. This is also the same location of all the database scripts to create the tables manually (optional).
BEFORE EXPORT:
AFTER EXPORT:
The following four CSV files are generated in the default Trending Database location; each CSV file is a representation of each table to be created in the monitoring DB:
Launch MS SQL Server Management Studio to validate Auditing database have been created properly
Use the SQL Scripts provided by BI Platform install to create the monitoring tables manually, location
\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\TrendingDB\
\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Data\TrendingDB |
Internally, the Monitoring application uses Connection Server libraries, and the SBO configuration is required for the Connection Server to establish connectivity to the database driver. You need to specify the database driver and its location in the SBO file to establish this connectivity, file location is <Install_Dir>\dataAccess\connectionServer\odbc\<dbType>.sbo
BEFORE:
AFTER:
Logon into CMC > Application > Monitoring Application Properties > Select Use Audit Database
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |