Configuring a connection to the OBIEE Server
by Haroun Khan, Christian Screen, Adrian Ward
Oracle Business Intelligence Enterprise Edition 12c - second Edition
- Oracle Business Intelligence Enterprise Edition 12c - second Edition
- Oracle Business Intelligence Enterprise Edition 12c - second Edition
- Credits
- About the Authors
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Preface
- 1. Oracle BI 12c Architecture
- Let's look at the big picture
- Terminology differences from Oracle BI 11g
- What is Oracle Fusion Middleware?
- Why is there a database repository for OBIEE?
- Overall components
- WebLogic Server
- System tools controlled by WebLogic
- Security
- System requirements
- Scaling out Oracle BI 12c
- Enterprise Deployment Guide
- Directory folder structure
- Download Oracle BI 12c
- System requirements
- References
- A review - what I should now know!
- Summary
- 2. Installing the Prerequisite Software
- 3. Installing on Windows Server 2012
- 4. Reviewing the Features of the Reporting Repository
- 5. Installing and Configuring Client Tools
- 6. Understanding the Systems Management Tools
- Let's talk management tools
- WebLogic Server Administration Control
- Servers
- Clusters
- Machines / IP address or DNS
- Data Sources / JDBC connections
- Security Realms
- WebLogic Server is its own application
- Using WLST
- Enterprise Manager Fusion Middleware Control
- Oracle BI 12c Lifecycle Management
- What is a BAR File?
- Deploying, migrating, and backing up artifacts
- Creating users, roles, and associations
- Creating users and groups in WebLogic Server
- Assigning users to groups
- Creating and assigning Application Roles
- JMX, MBeans, Java, and interfacing Oracle BI
- Migrating FMW Security to other environments
- FMW Security Import/Export utility
- Using the Security Realm migration utility
- Oracle BI Publisher system management
- Monitoring system performance
- Have a backup plan!
- Recommendations for further learning
- A review - what I should know now!
- Summary
- 7. Developing the BI Server Repository
- 8. Creating Dashboards and Analyses
- 9. Agents and Action Framework
- 10. Developing Reports Using BI Publisher
- Don't miss the installation integration checkpoint!
- What's all this XML talk?
- Where to administer BI Publisher
- Where to build a data model
- Let's get publishing
- Administration management of BI Publisher
- Accessing the BI Publisher Administration page
- Verifying application roles
- Creating the data source JDBC connection
- Creating a file (XLS) data source
- Verifying application role data source privileges
- Setting up a data model
- Creating a new Presentation Catalog folder
- Creating a new data model
- Creating an SQL query data set
- Adjusting data set display names
- Creating a parameter
- Creating a list of values
- Connecting the parameter to the list of values
- Getting the sample data
- Creating a BI Publisher report using the Layout Editor
- Auditing and monitoring BI Publisher
- Modifying a few configuration files
- Enabling Audit Policy in the Fusion Middleware Control Enterprise Manager
- Connecting to Oracle BI server data sources
- A review - what I should now know!
- Summary
- 11. Usage Tracking
- 12. Improving Performance
- 13. Using the BI Admin Change Management Utilities
- 14. Ancillary Installation Options
- Oracle BI 12c on its own server
- Custom ports and port management
- Installing Oracle BI 12c on *Nix
- Listening on port 80
- Configuring a HTTP proxy with the NGINX web server
- Enabling compression on web servers
- Automating starting and stopping
- Recommendations for further learning
- A review - what should I know now?
- Summary
- 15. Reporting Databases
- 16. Customizing the Style of Dashboards
- 17. Upgrading to 12c
In order to use our newly installed software, we have to tell it how to connect to our OBIEE Server. This is done through a simple Data Source Name (DSN), created on the PC where you installed the client.
We will create a new DSN, even if you have one installed:
- Open the ODBC Data Source Administrator (64 bit). This can be done from a link in the Control Panel or by typing
odbcad32.exein a Windows Run (windows key + R) command line.This opens the Administrator tool window on the User tab.
- Select the System DSN tab:
- Click on Add....
This will open the Create New Data Source dialog box:
- Select the Oracle BI Server from the list of available drivers. Make sure you select the 12c version if you have 11g already installed.
- Click on Finish. Weird to click on finish already!
- Enter the name (we have chosen to call it something meaningful).
- Enter the details of the server (name or IP address).
- Click on Next:
- Now enter the username and password you created during the installation.
- Change the port number to the one that was installed; in our case, it was
9514. If you are unsure, and9514did not work, go to the BI Instance Availability page in Enterprise Manager, where you will see what port numbers are in use. - Click on Next.
If your settings are correct, you will get the following dialog page. If you have an error on the screen, go back and make sure the port numbers, server name, username, and password are all correct:
You now have a connection set up and nearly ready to use in the OBI Admin Tool.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.