Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Integrate BI Publisher with OIM 11g

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    Integrate BI Publisher with OIM 11g

    [ora11g@dbaloungeapps ~]$ pwd
    /u02/bi_publisher/Oracle_Business_Intelligence_Publisher_Standalone/manual

    [ora11g@dbaloungeapps manual]$ ls
    fonts generic oc4j XMLP

    [ora11g@dbaloungeapps manual]$ cd generic
    [ora11g@dbaloungeapps generic]$ ls
    xmlpserver.ear xmlpserver.war

    [ora11g@dbaloungeapps generic]$ pwd
    /u02/bi_publisher/Oracle_Business_Intelligence_Publisher_Standalone/manual/generic
    [ora11g@dbaloungeapps generic]$ cd $WL_HOME
    [ora11g@dbaloungeapps wlserver_10.3]$ ls
    bugsfixed common inventory L10N server sip uninstall
    [ora11g@dbaloungeapps wlserver_10.3]$
    [ora11g@dbaloungeapps wlserver_10.3]$ cd ..

    [ora11g@dbaloungeapps Middleware]$ ls
    coherence_3.6 logs ocm.rsp Oracle_IDM1 registry.dat user_projects wlserver_10.3
    domain-registry.xml modules oracle_common Oracle_SOA1 registry.xml utils
    [ora11g@dbaloungeapps Middleware]$ cd ..
    [ora11g@dbaloungeapps Oracle]$ ls
    Middleware Middleware_old

    [ora11g@dbaloungeapps Oracle]$ mkdir xmlpserver
    [ora11g@dbaloungeapps Oracle]$ cp /u02/bi_publisher/Oracle_Business_Intelligence_Publisher_Standalone/manual/generic/xmlpserver.war ./xmlpserver/xmlpserver.war
    [ora11g@dbaloungeapps Oracle]$



    [ora11g@dbaloungeapps xmlpserver]$ pwd
    /u01/accounts/ora11g/Oracle/xmlpserver
    [ora11g@dbaloungeapps xmlpserver]$
    [ora11g@dbaloungeapps xmlpserver]$jar xvf xmlpserver.war
    [ora11g@dbaloungeapps xmlpserver]$ ls
    [ora11g@dbaloungeapps xmlpserver]$ rm xmlpserver.war



    [ora11g@dbaloungeapps xmlpserver]$ cd /u02/bi*
    [ora11g@dbaloungeapps bi_publisher]$ ls
    Oracle_Business_Intelligence_Publisher_Standalone
    [ora11g@dbaloungeapps bi_publisher]$ cd *
    [ora11g@dbaloungeapps Oracle_Business_Intelligence_Publisher_Standalone]$ ls
    doc install manual runInstaller stage Translations welcome.html
    [ora11g@dbaloungeapps Oracle_Business_Intelligence_Publisher_Standalone]$
    [ora11g@dbaloungeapps Oracle_Business_Intelligence_Publisher_Standalone]$ cd manual
    [ora11g@dbaloungeapps manual]$ ls
    fonts generic oc4j XMLP
    [ora11g@dbaloungeapps manual]$ cp -R ./XMLP /u01/accounts/ora11g/Oracle/xmlpserver/
    [ora11g@dbaloungeapps manual]$

    [ora11g@dbaloungeapps xmlpserver]$ cd -
    /u01/accounts/ora11g/Oracle/xmlpserver/WEB-INF
    [ora11g@dbaloungeapps WEB-INF]$ vi xmlp-server-config.xml
    [ora11g@dbaloungeapps WEB-INF]$ cat xmlp-server-config.xml
    <?xml version="1.0" encoding="UTF-8"?>
    <xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp">
    <resource>
    <file path="/u01/accounts/ora11g/Oracle/xmlpserver/XMLP"/>
    </resource>
    </xmlpConfig>
    [ora11g@dbaloungeapps WEB-INF]$ ls /u01/accounts/ora11g/Oracle/xmlpserver/XMLP
    Admin DemoFiles Reports Tools
    [ora11g@dbaloungeapps WEB-INF]$








































    [ora11g@dbaloungeapps Oracle]$ cd xmlpserver
    [ora11g@dbaloungeapps xmlpserver]$ cd XMLP
    [ora11g@dbaloungeapps XMLP]$ ls
    Admin DemoFiles Reports Tools Users
    [ora11g@dbaloungeapps XMLP]$ cd Reports
    [ora11g@dbaloungeapps Reports]$ ls
    Boilerplates Executive HR Manager Sales Manager Training
    Business Intelligence Financials Marketing Supply Chain Management
    [ora11g@dbaloungeapps Reports]$ mkdir OracleIdentityManager
    [ora11g@dbaloungeapps Reports]$ cd OracleIdentityManager
    [ora11g@dbaloungeapps OracleIdentityManager]$ pwd
    /u01/accounts/ora11g/Oracle/xmlpserver/XMLP/Reports/OracleIdentityManager
    [ora11g@dbaloungeapps OracleIdentityManager]$



    [ora11g@dbaloungeapps xmlpserver]$ cd XMLP
    [ora11g@dbaloungeapps XMLP]$ ls
    Admin DemoFiles Reports Tools Users
    [ora11g@dbaloungeapps XMLP]$ cd Reports
    [ora11g@dbaloungeapps Reports]$ mkdir OracleIdentityManager
    [ora11g@dbaloungeapps Reports]$ cd OracleIdentityManager
    [ora11g@dbaloungeapps OracleIdentityManager]$ pwd
    /u01/accounts/ora11g/Oracle/xmlpserver/XMLP/Reports/OracleIdentityManager
    [ora11g@dbaloungeapps OracleIdentityManager]$
    [ora11g@dbaloungeapps OracleIdentityManager]$ pwd
    /u01/accounts/ora11g/Oracle/xmlpserver/XMLP/Reports/OracleIdentityManager
    [ora11g@dbaloungeapps OracleIdentityManager]$ cd $OIM_HOME/server/reports
    [ora11g@dbaloungeapps reports]$ ls
    oim_product_reports_11_1_1_5_0.zip
    [ora11g@dbaloungeapps reports]$ pwd
    /u01/accounts/ora11g/Oracle/Middleware/Oracle_IDM1/server/reports
    [ora11g@dbaloungeapps reports]$ cd /u01/accounts/ora11g/Oracle/xmlpserver/XMLP/Reports/OracleIdentityManager
    [ora11g@dbaloungeapps OracleIdentityManager]$ unzip $OIM_HOME/server/reports/oim_product_reports_11_1_1_5_0.zip















    performing the following steps:

    a. Log in to Oracle BI Publisher from a web browser as an Administrator.
    b. Click the Admin tab, then click JDBC Connection under Data Source, and then click the Add Data Source button. The Add Data Source screen appears.

    c. Enter the following information in the fields on the Add Data Source screen. Replace the variable values in the following examples with the actual values for your Oracle Identity Manager database.
    Field Data to Enter

    Data Source Name OIM JDBC

    You must name this Data Source OIM JDBC for Oracle Identity Management BI Publisher Reports to generate reports against the JDBC data source without additional configuration. If you do not name this Data Source OIM JDBC, you must update the data source property in all report files with the name you enter in this field.

    Connection String jdbcracle:thin:@hostort:sid

    Username Username for a database schema user that has access to Oracle Identity Manager.
    Password Password for user identified in the Username field.
    Database Drive Class oracle.jdbc.driver.OracleDriver

    Use Proxy Authentication Select (enable) this option only if you use proxy authentication.

    d. Click the Test Connection button to test the connection to the JDBC Data Source. You will receive the Connection established successfully message if your connection is successful.

    If you do not receive the Connection established successfully message, verify the data you entered is accurate and check if the Oracle Identity Manager database is running.

    Click the Apply button on the Add Data Source screen after you have received the Connection established successfully message


























+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics