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

Last updated on AUGUST 27, 2021

Applies to:

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

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