C
Integrating Interactive Dashboards and Operational Applications Data
C-1
C
Integrating Interactive Dashboards and
Operational Applications Data
This appendix describes the additional configuration steps required for you to run an
Oracle Business Intelligence application with a Siebel CRM application.
The integration of Oracle Business Intelligence with a Siebel operational application
involves two general processes:
Section C.1, "Importing Oracle's Siebel Industry Applications Seed Data"
Section C.2, "Completing the Initialization in the Siebel Operational Application"
C.1 Importing Oracle's Siebel Industry Applications Seed Data
Oracle Business Intelligence seed data is not installed with Oracle's Siebel Industry
Applications. You must import the seed data into your database after the Oracle
Business Intelligence installation is completed. You only need to perform this
procedure if you are using Oracle's Siebel Industry Applications.
To import Oracle Business Intelligence seed data into a transactional database
1.
Obtain the required language.inp and .dat files from the Oracle Business
Intelligence language directory ORACLE_HOME\biapps\seeddata\l_xx, where
xx is the two-letter code for the language you want to import.
2.
Copy the .dat and corresponding .inp file from the language directory to the server
installation directory ORACLE_HOME\bifoundation\server\locale.
3.
From the command prompt in ORACLE_HOME\biapps\seeddata\bin, run the
following command:
dataimp /u $USERNAME /p $PASSWORD /c "$ODBCDatasource" /d $Tableowner /f
analytics_seed_<XXX>.dat /i metadata_upgrade_<XXX>_<DBPlatform>.inp /w y
Replace the XXX with the three-letter code (FRA, ITA) and the DBPlatform with
the abbreviation for the database platform being used. For example:
dataimp /u sadmin /p sadmin /c JPN_CRMDEV1 /d siebel /f analytics_seed_JPN.dat
/i metadata_upgrade_JPN_db2.inp /w y
For information about merging content into Oracle Business Intelligence Presentation
Services, see the topics about using the Catalog Manager in Oracle Business Intelligence
Presentation Services Administration Guide.
Tip:
See Oracle Business Intelligence Server Administration Guide before
performing any of the tasks in this section.