OBIEE Admin Tool - parent-child hiearchy not working properly. Ask Question. Obiee 12c admin Tool not starting Error: bimetadatart.dll file missing. How to make default expand level for OBIEE Parent Child Hierarchy. Issues with OBIEE Parent-Child Hierarchy Drilldown. This post covers managing users in Oracle Business Intelligence Server (OBIEE) using Security Manager in BI Administration Tool Security Manager – is used to setup users, groups, synchronize LDAP users and Groups, set access rights for Objects (tables, columns) and to control over when and what data a user can access.
![]() What is MySQL?
MySQL is an open source relational database.
MySQL is cross platform which means it runs on a number of different platforms such as Windows, Linux, and Mac OS etc.
In this tutorial, you will learn-
Why use MySQL?
There are a number of relational database management systems on the market.
Examples of relational databases include Microsoft SQL Server, Microsoft Access, Oracle, DB2 etc.
One may ask why we would choose MySQL over the other database management systems.
The answer to this question depends on a number of factors.
Let's look at the strengths of MySQL compared to over relational databases such as SQL Server-
In order to interact with MySQL, you will need a server access tool that can communicate with MySQL server. MySQL supports multiple user connections.
Introducing MySQL Workbench
MySQLWorkbench is a Visual database designing and modeling access tool for MySQL server relational database. It facilitates creation of new physical data models and modification of existing MySQL databases with reverse/forward engineering and change management functions.
Getting Started MySQL workbench- Modeling and Design tool
The figure shown below shows the modeling window for MySQLWorkbench.
MySQL workbench - SQL development tool
Structured Query Language (SQL) allows us to manipulate our relational databases. SQL is at the heart of all relational databases.
![]()
The figure shown below shows the SQL development window for MySQL Workbench.
MySQL workbench - Administration tool
Server administration plays a critical role in securing the data of the company. The major issues concerning server administration are users' management, server configuration, server logs and many more. Workbench MySQL has the following features that simplify the process of MySQL server administration;
The figure shown below shows the Admin panel for Workbench MySQL .
Install MySQL workbench Guide(for Windows)
This is a 2 step process
1) Install MySQL Community Server
2) Install MySQL workbench. - You can install the workbench using a zip file or an msi installer (recommended)
Note: You will require Administrator or Power User Privileges to perform installation.
Getting Started
Once you have finished installing above you need to set up MySQL Workbench as shown below -
1. First step is launching the Workbench MySQL . What you see is called Home Window
2. Next you need to create your MySQL Server Connection which contains details about target database server including how to connect to it. Click ' + ' in MySQL Workbench Home Window. This will open Setup New Connection . Wizard
3. As a beginner you can create a connection for a locally installed server. Click Configure Server Management button in Setup New Connection window to check the cofiguration of the MySQL server.
![]()
4. A new window opens named Configure Local Management . Click Next button to continue.
5. Next the Wizard will test connections to database. If test fails, go back and correct database connection parameters.5. Next it will open a pop up window asking your root password to test your connection with the local mysql server instance. The password is the one you set during installation of MySQL Workbench. Enter your password and press OK
6. Next the Wizard will test connections to database. If test fails, go back and correct database connection parameters. Else if all tests are sucessful click Next to continue.
7. After that a new wizard will open about Local Service Management - It lets you switch between multiple mysql severs installed on one machines. As a beginner you can bypass this and click Next to continue.
8. The Wizard will then check ability to access MySQL Server Configuration File, and test start/stop commands.
9. Next you can review current configurations. After reviewing the configurations, Click Finish to finsh server cofiguration
10. Next Step is to setup a connection, which can be used to connect to server. If you have not created a connection already, you can use the default values given. Click on Test Connection [ 2 ] after entering the Connection Name [ 1 ].
11. A new dialog box will open asking you password to root/selected user. If your MySQL root user has a password, you can enter that using Store in Vault feature. Click OK.
If the entered password for the user is correct then the following screen will show. Click on both OK buttons and you will be good to go.
A new instance is shown in the homepage
Double click and start querying.
Summary
This appendix gives a quick version of the Business Intelligence Administration tool installation steps.
E.1 Installing the Tool
The Repository, or RPD, is the file that contains the metadata for the BI Server in Fusion Applications. This includes database connections, tables, joins, and the structures by which these are presented to the report writer. In order to read or make changes to the RPD file, the BI Administration Tool must be installed.
E.1.1 System Prerequisites
E.1.2 Locate and Install the Software
There are two different ways to obtain the correct version of the tool:
Once you have downloaded, run the bi
ee_client_install_x64.exe executable to install the tool.
E.1.3 Set up ODBC Connection to Fusion Applications
To set up the ODBC connection from the Windows machine, you must locate the correct port on the Fusion Applications BI Server. Typically it is 10206, but if ports were changed as part of the FA install, perform the following steps:
Armed with the correct port, you are ready to create a new ODBC connection.
E.1.4 Connect to RPD in BI Admin Tool
The user could now connect to the BI Server in On-Line mode and could update the live RPD. CAUTION! Depending on network speed and the size of the RPD, this can be both slow and dangerous. Updating a live RPD while Fusion Applications users and reports are working with it is not advised.
A better solution is to copy the RPD file from the BI Server to a local or shared drive the Windows client can access, updating the RPD in off-line mode, and then publishing it through the BI Server's Enterprise Manager console.
The RPD files are stored in the following path on the BI Server:
BIInstance/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository .
To find the correct version:
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |