Oracle BI Server Online Repository Creation

                           How to create an online repository for Oracle BI Server

Repository Is use for the creating the relationship between the Physical Data Base and the BI Server for doing functionality.
It is divided into three Section

1. Physical layer.
2. Business Model and Mapping Layer.
3. Presentation Layer.

For making Repository we have to creates the OBI Server Data types.

Steps For Creating OBI Server Data Source.

Step 1:

 Open the Control Panel and go to Administrative Tools.

Step 2:

Then Select ODBC Source Type According to your System Configuration.

Step 3:

Then Select System DSN(Data Source Name) and go to Add

• DSN :- A data source name (DSN) is a data structure that contains the information about a specific database that an Open Database Connectivity ( ODBC ) driver needs in order to connect to it 

Step 4:

Select Oracle BI Server  for the Data Source and select Finish.

Step 5:

Enter a Name for the Your Data Source and also write Description about it and Click on next

Step 6:

Enter the User and Corresponding Password that we have set at the time OBI Installation.

• Select Next and then click on Finish.

Note: Port Number Is 9514.

Now we did Configuration of the BI Server DNS.

Part 2

Then we have to create the Data Source For BI and make it communicate with the Physical Data Base

As I told Above Repository Divided into 3 parts, here we describe also with creation

We start with Physical layer

• It defines the data Source to which Oracle Bi Server communicate with the Physical Data Base.
• By Importing (Recommended) and designing manually data source table.

Step 1

Go to the BI installed folder and go to user_projects and then after domains follow by bi-bitools-bin-admintools.cmd

Step 2

Select the File and then select the open and click on the Online.

Enter the user Name and Password  same as we enter in the Data source creation.

Step 3

Right in the Physical Layer Part and select the New Database Creation.

Step 4

Enter a name For you data base and Select the type of your data base.

Step 5

Right click on the Your Database and select the New Object  follow by Connection Pool

Step 6

Enter the Poll Name and then select the interface for the "Oracle 12c- Oracle 10g/11g".

Step 7

Then click on the Connection Poll and the That we have made and select import metadata.

Step 8

Verify the data source and Name (TNS Name) with the user name and password.

Step 9

Select the Sources that you want to import

Step 10

Select the user or the table that we want to explore and import 

Step 11

Right click on the BBM and select the Create the New Business Model

Step 12

Drag and drop the Physical layer data base in the BBM.

Do same Step in Presentation Layer

Now your Data Model is Created for BI server
You can Access in BI Publisher as well as BI Analytics.

------------------------------Welcome For Comment and Suggestion.------------------------------------------

WebLogic Server Infrastructure Installation From Scratch

WebLogic Server Infrastructure Installation

It is divided in two part
 1) Basic Installation.
 2) Server Configuration.

So we start with Part One.
Part 1:                                                                                                 
        Steps 1:

o   Download the WebLogic File from Oracle OTN or E-delivery websites.

o   Unzip the file.

o   Open the command prompt.

o   Gives java (jdk) location.

o   Follow by –jar infrastructure.zar (full file name).

·         Steps 2:

o   Click next on welcome dialog box.

·         Steps 3:

o   If you want Auto updates of your software then enter the path.

o   If not the skip the auto updates.

o   Click on next.

·         Steps 4 :

o   Set the path for the installation or remain as it is.

o   Click on next.

·         Steps 5:

o   Select the installation types.

o   Fusion middle gives you some tutorial example if we install as Fusion Middleware Infrastructure while second one comes without Examples.

                      o  Click on next.

·         Steps 6:

o   Checking Prerequisite items.

o   If Operating System error is show then not to worry it will not affect downloading or usage.

·         Steps 7:

o   It will show the list of the file it is going to install.

o   Click on install

·         Steps 8:

o   It shows the various steps of installation.

o   From View Messages we can view the list of file installing and configuring.

o   Click on next.

·         Steps 9 :

                    o   It show the installed files list.

      o   Click on finish to finishing the first part of installation.

Part 2:                                                                                                          

·         Step 1:

o   Open the command prompt go to the WebLogic install file locations (D:\Oracle\Middleware\Oracle_Home\wlserver\common\bin).

o   Find the config.cmd file.

o   Open the cmd. paste the links follow by cd.

o   Then execute the config file.

o   Then Configuration dialog box open.

o   Click on next.

·         Steps 2:

o   Select the template you want to configure.

o   Click on next.

·         Steps 3:

o   Enter the user name and password for the logging in WebLogic server.

o   Click on next.

·         Steps 4:

o   Choose the domain mode.

o   Development domain is used for development process and here security is little relaxed and auto played.

o   Production Domain is used for running the application. Here security is fully configured.

o   Click on next

·         Steps 5:

o   Advanced Configuration Wizard contains

§  Administration Server – It gives you administrative Privilege to operator servers.

§  Node Manager – It helps us to maintains remotely access the server.

§  Topology – It helps perform the action on the server.

o   Click on next.

·         Steps 6:

o   You have to set the Administrative Server with port number.

o   It is the center point of the server that we are going to configure.

o   Click on next.

·         Steps 7:

o   Node Manager Wizard gives us option to configure the Node credentials for logging.

o   Click on next.

·         Steps 8 :

o   Managed server is used to specify the unique server port and listing address that we want to access remotely.

o   Click on next.

o   You can configure server private ip address that will constant and port are always available to access.

§  We can do these things by clicking on your network links

§  Then you have to select/Double click on active  network

§  Then we have to select the in the network wizard.

§  Then select properties.

§  Then select the IPv4 and go to properties section of it.

§  Here you can set your IP Address.

§  Click on ok after setting it.

·         Steps 9:

o   Clustering is used for providing multiple servers for the WebLogic Server.

o   It is helpful to run the multiple instances for same application.

o   Click on next.

·         Steps 10:

o   It is the sever template here we have to defined the which ports are responsible to which kind of communications.

o   Click on next.

·        

            Steps 11:

o   It the logical representation of the computer that host one or more server WebLogic server instance.

o   The administration server used this Machine to operator with Node manager for accessing remotely.

o   Click on next.

·         Steps 12:

o   It is use to assign the server to machine how we want to access the machine or the server remotely.

o   Click on next

·     

                          Steps 13:

o   Virtual targets are used for assigning the virtual server for the different hosts to run the application.

o   It is mainly used in the partition of the server

o   Click on next.

·         Steps 14:

o   Partitions are used to configure different-different apps and instance in the same server.

o   Click on next.

·         Steps 15:

o   Configuration summary show the linkup and directory between the files.

o   Click on create.

·         Steps 16:

o   Show the list of the installed items.

o   Select the next to finish the installation.

·         Steps 17:

o   Note down the link address to launch the WebLogic console.

o   Click on finish.

Thank You
Please Gives Your Valuable Feedback.