Code templates

The Oracle Warehouse Builder has always provided a rich set of SQL and PL/SQL code that is included for extracting data, transforming it and loading it: but that rich feature set was always centered around an Oracle database. There was, and still is, support for connecting to non-Oracle databases via an ODBC connection or via a gateway module specifically designed for connecting to a non-Oracle database as we discussed earlier in the book, but that feature does not provide any way to perform transformations of data or loading data directly in those other databases. There is also no support for alternative data sources other than flat files via SQL Loader and SAP Enterprise Resource Planning system.

Code template description

With the addition of code templates, which leverage the knowledge module feature of ODI, we now have the capability to perform complex transformations and data integration natively in non-Oracle databases and to access any number of alternative data sources...