OBIEE 11g Strange ODBC Driver Error with SQL Server

I came across an interesting error recently. I had a very simple data model with 1 fact table and 1 dimension, both coming from a SQL Server 2008 database. When querying the model through Answers I would get ODBC driver errors like the ones below. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A […]

OBIEE and SQL Server Analysis Services Cubes

Recently I’ve been working on a client project that brings together data from a number of sources, one of them being Microsoft SQL Server Analysis Services OLAP cubes. I thought I’d compile a few notes here to explain the current level of support for SSAS in OBIEE and some of the limitations in using this […]

Using Oracle SQL Developer with MS SQL Server

If, like me, you’re a fan of Oracle’s free SQL Developer application, then you may want to use it to access other types of database. This is possible by installing a third party JDBC driver. E.g. for SQL Server, Sybase or MySQL. Here’s the configuration needed for SQL Server: Download the JTDS driver from Sourceforge. […]

OBIEE 11g RCU: SQL Server 2008 Walkthrough

Running the OBIEE 11g Repository Creation Utility (RCU) against a SQL Server database wasn’t as straightforward as I’d hoped. There are a few preliminary tasks which aren’t obvious so I’ve decided to put this guide together. First log in to your SQL Server and create a new user. In this case I’m naming it obi_user. […]