ODI and analytic functions (again???)

Uli Bethke analytic functions, Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes My friend and colleague Maciej Kocon has come up with the following trick. Rather than use a user defined function to implement an analytic function such as MAX() OVER or SUM() OVER as suggested by note 807527.1 there is another way ...

ODI and Integrated Security/Authentication with Microsoft SQL Server

Uli Bethke MS SQL, Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes Setting up integrated security with the SQL Server JDBC driver can be tricky. You often end up with the message “This driver is not configured for integrated authentication”. Below are the steps that you need to perform to get this to ...

What has ODI encryption got to do with clearing the OBIEE cache???

Uli Bethke OBIEE, Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes As part of a data mart refresh I am using nqcmd to clear the cache for the corresponding subject area in OBIEE. Thanks to John Minkjan for his post on properly documenting how the OBIEE cache can be cleared. Basically I ...

Oracle naming conventions and coding guidelines for SQL and PL/SQL

Uli Bethke Oracle

Reading the German database pro magazine this morning I saw that Swiss consultancy Trivadis has published a very useful document on Oracle naming conventions and Oracle coding guidelines for SQL and PL/SQL. Visit the Trivadis website for other useful stuff such as their blog and technology center.

Data warehousing and business intelligence books for project managers and business analysts

Uli Bethke Books, Business Intelligence Books, Data Warehousing Books

In other parts of this series we have had a look at data warehousing books that cover the design and architecture of a business intelligence solution. I have also covered data warehousing books in the world of Oracle. Today we will have a look at data warehousing and business intelligence books for project management and business analysis. The Profit Impact ...