Chapter 6. Working with MySQL

ODI's normal operating environment is being surrounded by a number of different database systems. We saw in the previous chapter that ODI comes ready for use with Oracle databases, having the required JDBC driver installed automatically out of the box. However, ODI's heritage means that there doesn't have to be an Oracle database anywhere within ODI's reach. So let's take a look at how ODI interoperates with another popular database, MySQL, that historically had nothing to do with the Oracle Corporation.

The reason for choosing MySQL is simply to illustrate some additional steps that must be performed when using many third-party databases. These steps are required to make the required JDBC drivers for those databases ...

Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.