What you can and can't do with MySQL
We'll be using MySQL for hosting our source data in this chapter, but MySQL is equally suitable as a target or for use as a staging area.
MySQL is one of the platforms listed in the Topology Navigator's Technologies view, so ODI knows about its database functions, datatype capabilities, SQL syntax variations and other characteristics. So the additional work to use a database such as MySQL with ODI is in fact minimal.
However, you cannot use MySQL (at least versions up to and including v5.1) as a host for ODI's Master or Work repositories. Because MySQL has a limitation in its SQL capability. This limitation is not present in all non-Oracle relational databases by any means and should you wish to use a different database for hosting ODI repositories you should consult the following ODI Certification Matrix on the Oracle support website at
|
ODI 11.1 Repository Database Certification Matrix |
|---|
|
Oracle 10.2.0.4+ Oracle 11.1.0.7+ Oracle 11.2.0.1+ Microsoft SQL... |
