Consuming a REST web service with Oracle

Uli Bethke March 12, 2009

SOAP web services dominate in a SOA environment. However, there is a new kid on the block: REST. This is a more lightweight approach to exchange data over HTTP, which is becoming more and more popular with web mashups and the web 2.0 in general. Amazon, Twitter, Yahoo all expose their APIs via REST. REST ...

Read More

It's the tool, stupid. Or is it?

Uli Bethke March 3, 2009

Every couple of months or so, they run an article on Business Intelligence in one of the Sunday business papers here in Dublin. The tenor of these articles goes like this: Just pick the right BI tool, sit back, and relax. It will all sort itself out. This reminds me of the Fast = On ...

Read More

Date dimension script with Oracle SQL

Uli Bethke February 24, 2009

The script below will create a date dimension in just one SQL statement. We don’t use performance-killer nonsense such as cursors, functions etc. We just pick a start date and the number of days we want to create and with a bit of magic of the Connect By clause and the NUMTODSINTERVAL function we do ...

Read More

One pass SCD2 load: How to load a Slowly Changing Dimension Type 2 with one SQL Merge statement in Oracle

Uli Bethke February 1, 2009

The other day I came across a useful new feature in the Merge statement for SQL Server 2008. This new feature outputs merged rows for further processing, something which up until now (Oracle 11.1.0.7) is not possible in Oracle. This extra functionality can be used to load a Slowly Changing Dimension Type 2 in one ...

Read More
1 75 76 77 78 79