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 available for ODI to use.
In the previous chapter we integrated data from one database table into another as a simple foundation example. In this chapter we're going to extend the skills we gained as follows, by incorporating a number of new elements...
