Losing timestamp in ODI when using ojdbc14.jar

Uli Bethke Oracle Data Integrator (ODI)

The ojdbc14.jar version of the JDBC driver is losing timestamp information when returning DATE datatypes from Oracle. As per Oracle JDBC driver FAQ this is a known issue. As a workaround it is suggested to set the oracle.jdbc.V8Compatible JDBC parameter to true. You can set this parameter in ODI when defining a Topology: However, a better solution for this is ...

Oracle Data Integrator vs. Oracle Warehouse Builder: What to do, what to do?

Uli Bethke ETL, Oracle, Oracle Data Integrator (ODI), Oracle Warehouse Builder

One of the questions that regularly comes up in the forums, or during presentations on Oracle data integration products, is on the future of Oracle Warehouse Builder and Oracle Data Integrator. People wonder which tool to use for new projects? What should be done with existing implementations? In this article we will first compare the features and functionalities of both ...

Essential skills any BI Consultant should have. Or why a fool with a tool is still a fool.

Uli Bethke Business Intelligence

Today I'm gonna be mean. Before we start though, here is my definition of a BI consultant. In my eyes, a BI consultant is the guy at the frontend of a data warehouse/business intelligence project. He creates and designs reports, and is responsible for setting up the logical layer between the data source(s) and the ad hoc query tool. His ...

Greenplum, MapReduce, and Hadoop

Uli Bethke Business Intelligence

If your job involves processing massive amounts of data you should familiarize yourself with Greenplum, MapReduce, and Hadoop. With 6.5 Petabytes of data eBay runs the world's largest data warehouse on Greenplum. Facebook runs a 2 PB warehouse on Hadoop. Impressive. Both Greenplum and Hadoop make use of the MapReduce framework pioneered by Google. You can run Hadoop on Amazon ...

Oracle on Windows in the EC2 cloud. Persist computer name across instance shutdown.

Uli Bethke Amazon EC2, Oracle

For various reasons it is important that your Windows computer name persists across instance shutdown on EC2 (listener, tnsnames.ora, loopback adapter etc.). To achieve this you need to perform the following steps: 1. Connect to your instance via remote desktop 2. Change the computer name via control panel 3. Open windows explorer and browse to the EC2 config tool. By ...