Feed items
ODI 11g - Parallel, Pipelined Unload to File
Here we can see how we can leverage table functions as targets in ODI interfaces to do cool stuff! It carries on from my pipelining post. Table functions let you do all kinds of powerful transformations and are a great way for incorporating in-memory custom transformations on sets. The illustration here is using a table function to parallel unload to file, it was initially posted on the OWB blog here.
ODI SDK: Leveraging ODI Tools with Groovy
In a previous post, Uli Bethke asked if it would be possible to leverage ODI Tools using Groovy.
It turns out that yes, you can do so by combining Groovy and the SDK: dynamically build a package that contains the tools, and execute the code - all in one shot.
The key elements in the code are:
ODI SDK: Leveraging ODI Tools with Groovy
In a previous post, Uli Bethke asked if it would be possible to leverage ODI Tools using Groovy.
It turns out that yes, you can do so by combining Groovy and the SDK: dynamically build a package that contains the tools, and execute the code - all in one shot.
The key elements in the code are:
ODI SDK: How to Automate Changes to Interfaces
One of the most promising features of ODI 11g is its SDK that allows you to perform any action you want against the repository. A good introduction to the SDK is available here (and I used this as a starting point for my code)
ODI SDK: Browsing The Repository to List All Interfaces
One of the most promising features of ODI 11g is its SDK that allows you to perform any action you want against the repository. A good introduction to the SDK is available here (and I used this as a starting point for my code)
Oracle acquires Datanomic and Expands Data Quality
Data quality has historically been an after thought in the enterprise. Organizations often have to be convinced that trusted information, of high data quality arms the enterprise with information consistency, quality and authoritative data for improved, actionable business insight. Oracle recently announced the acquistion of Datanomic, a leading provider of customer data quality software and related applications for risk and compliance screening.
ODI 11g - Pipelines
Carrying on from the simple,
flexible, powerful posting on the code generation capabilities of ODI 11g
which illustrated the SQL as a Source option we can see how additional new code
generation components can be defined (which let us capture information about
specific transformations) and assemble in a pipeline. This is the kind of info I covered in my ODTUG KScope11 'Pushing the Envelope with ODIEE' talk at Long Beach this year - had a great time meeting everyone there!
Oracle Data Integrator 11.1.1.5 Complex Files as Sources and Targets
Overview
ODI 11.1.1.5 adds the new Complex File technology for use with file sources and targets. The goal is to read or write file structures that are too complex to be parsed using the existing ODI File technology. This includes:
Complex File Processing - 0 to 60
The Complex File technology adds a powerful new driver into the ODI capabilities. It leverages the Fusion Middleware capabilities for supporting complex files, you can then build ODI interfaces just as you are used to!
Using an example from the Oracle® Fusion Middleware User's Guide for Technology Adapters 11g Release 1 (see here), the viewlet quickly builds up the model based on the XSD for the complex file (use Native Format Builder to construct).
