My Oracle Support Banner

OBIEE 11g: How To Configure MySQL Database As A Data Source (Doc ID 2021699.1)

Last updated on MARCH 08, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.9.0 [Release 11g]
Information in this document applies to any platform.

Purpose

The document provides step by step instructions on how to configure MySQL database as a data source for OBIEE.

Scope

This document is informational and intended for Administrators and Advanced Users.
Before reading this document, the user must have a good understanding of OBIEE and MySQL Database.
The user must have experience installing all those products.
The user must have basic experience with MySQL database (creating users, tables, inserting rows).
This document is intended as a "cookbooK" enhancement to the documentation to fill in any gaps, missing or ambiguous information and to tie multiple documentation together in one location.
This example documents a self-contained machine (single server). If you install different components on different machines (such as the Enterprise Deployment Guide example), then please configure accordingly or follow the Enterprise Deployment Guide.
Any references to MySQL documentation, MySQL Database, MySQL native ODBC drivers or MySQL administration tasks are for information purposes only. If the customer experiences issues regarding MySQL then MySQL Support team should be contacted to address them.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Download and Install MySQL Database and ODBC Drivers
 Install MySQL Driver (Optional)
 Create a MySQL Database and Schema to be Used as the OBIEE Data Source
 Configure the MySQL Database as a Data Source for OBIEE
 Define a System DSN in the Client Machine Where the Administration Tool is Run
 Import Data into the Repository (RPD)

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.