Business Intelligence, Data Warehousing, and Database Magazines

Uli Bethke BI Magazines

I did some research around business intelligence and data warehousing magazines. If you think I have missed one let me know. Magazines – print version Business Intelligence Journal (TDWI) "The Business Intelligence Journal is an in-depth, unbiased information resource for business intelligence and data warehousing professionals. This quarterly publication provides fresh ideas and perspectives to help organizations operate more intelligently" ...

Using subqueries in Oracle Data Integrator (ODI) interfaces for complex data integration requirements

Uli Bethke Oracle Data Integrator (ODI)

Oracle Data Integrator does not have any built in functionality for subqueries in interfaces. This is one of the reasons why you will find people claiming that ODI has shortcomings when dealing with complex transformations. Shortcomings of existing workarounds In the ODI community various workarounds have been suggested to address this. The following discussion thread on OTN summarises these efforts. ...

Oracle data warehousing and business intelligence books

Uli Bethke Books, Business Intelligence Books, Data Warehousing Books

Today I continue in my series on Data Warehousing books. In a previous post we have had a look at data warehouse design and architecture books. We have also had a look at data warehousing and business intelligence books for project managers and business analysts. We will focus on Oracle data warehousing books this time. If you know of any ...

ODI Snippets: OdiSqlUnload with header

Uli Bethke Oracle Data Integrator (ODI)

OdiSqlUnload is a handy tool to quickly dump the content of a table into a CSV file. This is a lot quicker than first creating a file data server, interfaces etc. However, OdiSqlUnload has one major drawback. It does not allow you to load the header columns of your table(s) into the CSV. This makes the tool pretty much useless ...