Book Image

Oracle Business Intelligence Enterprise Edition 12c - Second Edition

By : Adrian Ward, Christian Screen, Haroun Khan
Book Image

Oracle Business Intelligence Enterprise Edition 12c - Second Edition

By: Adrian Ward, Christian Screen, Haroun Khan

Overview of this book

Oracle Business Intelligence Enterprise Edition (OBIEE) 12c is packed full of features and has a fresh approach to information presentation, system management, and security. OBIEE can help any organization to understand its data, to make useful information from data, and to ensure decision-making is supported by facts. OBIEE can focus on information that needs action, alerting users when conditions are met. OBIEE can be used for data analysis, form production, dashoarding, and workflow processes. We will introduce you to OBIEE features and provide a step-by-step guide to build a complete system from scratch. With this guide, you will be equipped with a good basic understanding of what the product contains, how to install and configure it, and how to create effective Business Intelligence. This book contains the necessary information for a beginner to create a high-performance OBIEE 12c system. This book is also a guide that explains how to use an existing OBIEE 12c system, and shows end users how to create.
Table of Contents (24 chapters)
Oracle Business Intelligence Enterprise Edition 12c - second Edition
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Configuring a connection to the database


As you will see in the following chapter, one of the tasks that we set is to create a set of tables in the repository that mirror the tables in your database. This is best done when you can connect your client to the database you are modeling.

Creating a connection to your database is simple if you have the client software already installed on your workstation. For example, if you are connecting to Oracle, you will need the Oracle drivers on your machine.

We are connecting to the AdventureWorks database on SQL Server, which is on our local machine where the OBIEE client is installed; this means the software is already in place. In your installation, you may have to download the driver. Search Microsoft.com for an ODBC driver that matches your Windows version and database version, and install that first.

When the software is in place, create a new DSN using the SQL Server driver and you are ready to go.

At this point, you can move on to the next chapter...