1 2 3 Previous Next 40 Replies Latest reply: Oct 16, 2012 5:39 AM by Andy Coates RSS

    Pre-requisites for the OBIA

    Saro
      Hi friends,

      What are the pre-requisites for the installation of OBIA(latest version), informatica(latest version) with the OBIEE 11.1.1.6.

      I have the following requisites like
      Software-------------------------------Version
      Oracle database ------------------11g Release 2
      Hibernate libraries--------------------3.2.5.ga
      OBIEE----------------------------------11.1.1.6
      Oracle BI Applications release-------7.9.5.1
      Informatica power center-------------8.1.1
      But i need to know the latest version of OBIA and informatica power center which is affordable with the OBIEE latest version(11.1.1.6).

      Can friends, anyone guide me with the pre-requisite that i need to follow.

      Thanks in advance.

      Regards,
      Saro
        • 1. Re: Pre-requisites for the OBIA
          Srini VEERAVALLI
          You need to go for Informatica 9.0.1 and bi apps 7.9.6.3

          Pls mark as correct
          • 2. Re: Pre-requisites for the OBIA
            Saro
            Hi Svee,

            Thanks for your reply.

            It is been a long time we met again. Also congrats for your New position in the OBIA forum with a top user.

            Is the hibernate files 3.2.5ga is okay for it.

            Also if possible, can you send me the installation and configuration of OBIA 7.9.6.3 with informatica 9.0.1 HF2 along with DAC V10.1.3.4.1. I mean any document with screenshot wise is available for it.

            since im going to install the OBIA freshly with informatica and also i need to configure with OBIEE 11.1.1.6. The link that you are proposing will be useful for my configuration.

            Thanks for your help.

            Regards,
            Saro
            • 3. Re: Pre-requisites for the OBIA
              Srini VEERAVALLI
              Thanks :)

              Check these links. If Hibernate files are related to DAC then just ignore it, no need.
              http://docs.oracle.com/cd/E23943_01/bi.1111/e10539/toc.htm
              http://docs.oracle.com/cd/E20490_01/bia.7963/e19038/toc.htm

              http://debaatobiee.wordpress.com/tag/step-by-step-obiee-11g-installation/
              http://www.in-oracle.com/Oracle-DataWarehouse-BI/Oracle-Business-Intelligence/OBIEE/obiee-11g-installation-linux.php

              Pls mark as correct/helpful.
              • 4. Re: Pre-requisites for the OBIA
                Saro
                Hi svee,

                Thanks, can you send the respective download link for the following s/w's like
                Oracle database --------------------11g Release 2
                Hibernate libraries----------------------3.2.5.ga
                OBIEE-------------------------------------11.1.1.6
                Oracle BI Applications release-------7.9.6.3
                Informatica power center-------------9.0.1 HF2
                DAC---------------------------------------10.1.3.4.1
                Thanks for your support

                Regards,
                Saro
                • 5. Re: Pre-requisites for the OBIA
                  Srini VEERAVALLI
                  You can get them from https://edelivery.oracle.com/
                  For DB
                  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

                  I dont think you need Hibernate libraries

                  Pls mark if helps
                  • 6. Re: Pre-requisites for the OBIA
                    Saro
                    Hi Svee,

                    Thanks for your reply.

                    Now im in the verge of installing and configuring OBIA and informatica with OBIEE 11g in my windows server 2003(64 bit).

                    For that i have installed OBIEE 11.1.1.6, with that i need to configure OBIA along with(Informatica and DAC) inorder to perform full load ETL in DAC for several modules like CRM, HRMS using my local R12 instance in DAC

                    For OBIA 7.9.6.3, DAC 10.1.3.4.1 and informatica 9.0.1  i have downloaded the following files from e-delivery and also from otn links. Im not sure with the s/w that i downloaded is right to proceed my configuration. These are those s/W's that i downloaded along with the following links.


                    Oracle Business Intelligence Applications 7.9.6.3 for Microsoft Windows
                    http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html
                    
                    https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=12854069
                    Oracle Business Intelligence Data Warehouse Administration Console (10.1.3.4.1)
                    Oracle Business Intelligence Data Warehouse Administration Console 10.1.3.4.1 for Microsoft Windows and Informatica Power Center and Power Connect Adapters 9.0.1 for Windows x86 (32-bit) (Part 1 of 2)
                    
                    Oracle Business Intelligence Data Warehouse Administration Console 10.1.3.4.1 for Microsoft Windows and Informatica Power Center and Power Connect Adapters 9.0.1 for Windows x86 (32-bit) (Part 2 of 2)
                    
                    
                    https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=12854069
                    Informatica power center – 9.0.1 HF2
                    Oracle Business Intelligence Applications Licensing and Packaging Guide 7.9.6.3 and Informatica Power Center and Power Connect Adapters Client 9.0.1 (Part 1 of 2)
                    
                    Oracle Business Intelligence Applications Licensing and Packaging Guide 7.9.6.3 and Informatica Power Center and Power Connect Adapters Client 9.0.1 (Part 2 of 2)
                    
                    https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=12854069
                    Is those software's that i downloaded is right from the above link.

                    And also since i installed obiee 11g and after that i need install OBIA and then need to create required users in my database and after that i need to install informatica.

                    Once all those software's are installed, then i need to configure informatica with DAC and OBIA. Is it right svee.

                    Is there any document available, then mentioning all the steps which includes installation and configuration of informatica with DAC and OBIA

                    You in my previous post preferred the below link, is that link includes all those steps.

                    http://docs.oracle.com/cd/E20490_01/bia.7963/e19038/toc.htm_+

                    Can you kindly confirm and clarify me SVee..

                    Thanks for your support.

                    Regards,
                    Saro
                    • 7. Re: Pre-requisites for the OBIA
                      Srini VEERAVALLI
                      I'm not sure what the varsion from, since you have done it proceede further..
                      http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html

                      And other software from edelivery are good and also rest(links) are good to go.

                      Pls mark if helps :)
                      • 8. Re: Pre-requisites for the OBIA
                        Saro
                        Hi Svee,

                        Thanks for your reply.

                        From e-delivery i was a bit confused of downloading the corresponding software, but with the help of your link below i can point out the right software to download which was very useful for me.

                        https://forums.oracle.com/forums/thread.jspa?messageID=10502217_+

                        After downloading and installing the required software's, i need to configure DAC and informatica with OBIA and for that you proposed the below link

                        http://docs.oracle.com/cd/E2049001/bia.7963/e19038/toc.htm__+

                        In the above link they referred before installing informatica u need to refer the "power center installation and configuration guide", but i couldn't find this guide can you point out where can i get that guide so that i can follow all the per-requisites before installing informatica.

                        Thanks for your support.

                        Regards,
                        Saro
                        • 9. Re: Pre-requisites for the OBIA
                          Andy Coates
                          Hi Saro,

                          http://docs.oracle.com/cd/E20490_01/nav/portal_booklist.htm

                          First link on the list.

                          Please mark if helpful.
                          Andy.
                          • 10. Re: Pre-requisites for the OBIA
                            Saro
                            Hi Andy,

                            Thanks for your reply. The document that you preferred explains the configuration of several modules like(SCM, HRMS etc from source) with informatica.

                            But i need the guide which explains about the Power center installation and configuration guide in the below link from the below line

                            http://docs.oracle.com/cd/E20490_01/bia.7963/e19038.pdf_+
                            This section explains how to install Informatica PowerCenter Client Tools 9.0.1 Hotfix
                            2 for an Oracle BI Applications deployment. For detailed generic information about
                            installing Informatica 9.0.1, refer to the PowerCenter Installation and Configuration Guide,
                            and related documentation
                            refer to the PowerCenter Installation and Configuration Guide, and related documentation
                            Im in need of the above document.

                            Thanks,

                            Regards,
                            Saro
                            • 11. Re: Pre-requisites for the OBIA
                              Srini VEERAVALLI
                              Earlier I was referring http://docs.oracle.com/cd/E20490_01/bia.7963/e19038/toc.htm

                              Read it once before you start.
                              • 12. Re: Pre-requisites for the OBIA
                                Saro
                                Hi svee,

                                I was referring that guide only and in that guide only they asked to refer to the PowerCenter Installation and Configuration Guide. Thats why im in search of that guide. Where can i find that guide.

                                Also im in need of the informatica power center administrator guide 9.0.1

                                Thanks

                                REgards,
                                Saro
                                • 13. Re: Pre-requisites for the OBIA
                                  Srini VEERAVALLI
                                  Follow this link
                                  http://bloggingaboutoracleapplications.org/installation-informatica-powercenter-9-0-1-on-oracle-enterprise-linux-5-6/

                                  This helps for Windows too

                                  Pls mark if helps
                                  • 14. Re: Pre-requisites for the OBIA
                                    Saro
                                    Hi Svee,

                                    I have installed OBIEE 11.1.1.6 and OBIA 7.9.6.3 and after that i need to install informatica client and server and then DAC.

                                    But im confused of which software is for informatica client and which one is for informatica server.


                                    From this link

                                    https://forums.oracle.com/forums/thread.jspa?messageID=10502217

                                    You mentioned like below that
                                    Informatica Server:
                                    Oracle Business Intelligence Data Warehouse Administration Console 10.1.3.4.1 for Microsoft Windows
                                    and Informatica PowerCenter and PowerConnect Adapters 9.0.1 for Windows x86 (64-bit) (Part 1 of 2) V30854-01 Part 1 of 2 2.0G
                                    Oracle Business Intelligence Data Warehouse Administration Console 10.1.3.4.1 for Microsoft Windows
                                    and Informatica PowerCenter and PowerConnect Adapters 9.0.1 for Windows x86 (64-bit) (Part 2 of 2) V30854-01 Part 2 of 2 26M
                                    
                                    Informatica Client:
                                    Oracle Business Intelligence Data Warehouse Administration Console 10.1.3.4.1 for Microsoft Windows
                                    and Informatica PowerCenter and PowerConnect Adapters 9.1 for Windows x86 (64-bit) (Part 1 of 2) V30859-01 Part 1 of 2 2.0G
                                    Oracle Business Intelligence Data Warehouse Administration Console 10.1.3.4.1 for Microsoft Windows
                                    and Informatica PowerCenter and PowerConnect Adapters 9.1 for Windows x86 (64-bit) (Part 2 of 2) V30859-01 Part 2 of 2 1.4G
                                    But from the above i have doubt like for server you mentioned the informatica version like 9.0.1 and for the client you mentioned the informatica version like 9.1

                                    Since the version is of different, whether this will cause any difference.

                                    And also while installing it is asking for a license key and for that which file that i need to specify.

                                    Whether i need to install informatica client first or informatica server first.

                                    Thanks for your support.

                                    Regards,
                                    Saro
                                    1 2 3 Previous Next