5 Replies Latest reply: Jul 24, 2012 2:59 PM by Srini VEERAVALLI RSS

    obiee 11g import


      i am using obiee 11g i want to import sh schema from oracle 10g

      how can i import
      any plz help me

      Thx in Advance
        • 1. Re: obiee 11g import
          Srini VEERAVALLI
          Update the TNS entry at location

          and Import Metadata or else

          use tns entry at Data Source Name at connection pool using OCI 10/11g

          If helps Pls mark correct or helpful
          • 2. Re: obiee 11g import
            thx a lot

            can u tell clearly plz dont mind
            • 3. Re: obiee 11g import
              Srini VEERAVALLI
              Select Start > Programs > Oracle Business Intelligence > BI Administration to open the Administration Tool.
              Select File > New Repository
              Enter a name for the repository. Leave the default location as is. It points to the default repository directory
              Leave Import Metadata set to Yes.
              Enter and retype a password for the repository

              Import Metadata:
              Change the Connection Type to OCI 10g/11g. The screen displays connection fields based on the connection type you selected.
              Enter a data source name (You can go for any of one what i mentioned earlier). In this example the data source name is orcl. This name is the same as the tnsnames.ora entry for this Oracle database instance.
              Enter a user name and password for the data source
              Click Next
              Accept the default metadata types and click Next
              In the Data source view,
              The Connection Pool dialog box appears. Accept the defaults and click OK
              The Importing message appears

              If helps, Pls mark correct or helpful
              • 4. Re: obiee 11g import
                thx a lot

                where we have to create tsn and where we have to copy and paste code
                • 5. Re: obiee 11g import
                  Srini VEERAVALLI
                  From location

                  If helps close this thread by marking as correct or helpful