Comparing Window Function Features by Database Vendors

Jiří Mauritz Data Warehouse, Redshift, SQL for Analysis, Window Functions

We will round off the series on window functions with comparison of what database vendors offer. There are various mutations of window functions and every vendor supports a different subset or feature. Some also add extra window functions or features beyond standard ANSI SQL. One of the most powerful features is user-defined aggregate functions (UDAF), which some databases allow using ...

Tips for Reverse Engineering complex XSDs such as SEPA and NDC in ODI

Maciek Kocon Flexter, Oracle, Oracle Data Integrator (ODI), XML, XSD

In this post we will show you a few tips and ODI issues when reverse engineering complex industry XML schemas (XSD) such as NDC FlightPriceRS or SEPA Pain.001. This is the first part in a multi part series. The second part gives you some tips and tricks when parsing XML files in ODI. The third part compares ODI to Flexter, ...

Converting XML files to Oracle without writing a single line of code

Maciek Kocon Flexter, Oracle, XML, XSD

Parsing XML files to Oracle without writing a single line of code In a previous post we demonstrated how to use Flexter to convert XML data into TSV files. This was just an introduction demonstrating some basic features of Flexter including concepts around XML schema normalization and optimization. Converting XML into an Oracle Database This time we are going to ...

New Oracle Data Miner tool is now Available

Uli Bethke Business Intelligence, data mining, Uncategorized

Today the new Oracle Data Miner tool has been made available as part of the SQL Developer 3.0 (Early Adoptor Release 4). The new ODM tool has been significantly redeveloped, with a new workflow interface and new graphical outputs. These include graphical representations of the decision trees and clustering. To download the tool and to read the release documentation go ...

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 ...