Data integration, ETL, and data quality with Google Refine 2.0

Uli Bethke google

On 10 November, Google announced Google Refine 2.0. The tool is open source. It has some advanced data quality and data transformation functionality. But nothing really we haven't seen before. However, where the tool really shines is in the area of data augmentation. The tool ships with pre-defined data augmentation services that automate the process of reconciling and augmenting your ...

Accessing a mapped network drive with the ODI agent as a Windows service

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes The problem The other day we had a requirement to extract data from an Access database on a mapped network drive. For reasons too complicated to outline here, we could not use a UNC. While there is no problem to access ...

ODI 11g standalone agent as a windows service

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes In the documentation for ODI 11g you can read that you need Oracle Process Manager and Notification Server (OPMN) to create your standalone agent as a windows service. OPMN is not available as a standalone install but is installed as part ...

ODI snippets: Converting a temp interface to a regular interface

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes Amongst other things, temp interfaces in ODI are a great way of prototyping data flows. However, what if you want to convert a temp interface from a prototyping exercise to something more permanent? This is actually quite easy, just follow the ...