Firefox add-ins - ones I find useful
Delicious Bookmarks FireGestures FoxyProxy Greasemonkey HttpFox Screengrab User Agent Switcher
Metalink Metalink Metalink
I’m learning about a lot of the Oracle BI stack through reading manuals and trial-and-error.
One thing I’ve realised is that Metalink holds a whole heap of useful information.
For example, simply searching on “publisher cluster” throws up these two very pertinent docs:
OBIEE Clustered Installation with BI Publisher (Doc ID 744515.1) BI Publisher does not accept cluster jdbc connection strings (Doc ID 559795.1) The first one is a publically available PDF, the second one is the answer to the problem I spent more time than I needed to scratching my head over yesterday.
Which jdbc driver to use
In setting the scheduler in Publisher I discovered a useful difference in jdbc drivers.
Our repository is on Oracle 11g.
According to the manual oracle.jdbc.driver.OracleDriver should be used, but previous installations have used oracle.bi.jdbc.AnaJdbcDriver so I tried this too.
In experimenting with both I found you get more useful feedback from the second one. Here’s the same problem reported by both drivers:
· Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.
Finding config files in unix
Following my previous work on configuring Publisher, I wanted to note down where the changes were written to.
The -mname syntax of the unix find command comes in handy here:
find /app/oracle/product/obiee -mtime -1
Shows me all files under the specified path which were modified in the last 1 day
and helpfully throws up:
/app/oracle/product/obiee/xmlp/XMLP/Admin/DataSource/datasources.xml
OBIEE Publisher - configuring connection to clustered BI Server
I’m setting up a clustered OBIEE 10.1.3.4 production environment. There are four servers; two BI Server + Cluster Controller + Scheduler and two OAS + Presentation Services + Publisher. Clustering of BI is configured, now I’m setting up the other bits. Today is Publisher.
On publisher instance A connections to the BI Servers directly work fine:
jdbc:oraclebi://serverA.fqdn.company.net:9703/ jdbc:oraclebi://serverB.fqdn.company.net:9703/
both work individually as Connection Strings (with database driver class of oracle.bi.jdbc.AnaJdbcDriver) - verified with “Test Connection” button.
As I explore the current world of data & analytics engineering, one of the things I’m trying to grok is the idea of a Metric Layer (described by Drew Banin
in this keynote: https://www.youtube.com/watch?v=MdSMSbQxnO0 and Benn Stancil here https://benn.substack.com/p/metrics-layer).
It strikes me as conceptually similar to what #OBIEE did in its logical layer with measures. Admittedly it was almost always exposed through the tool’s front end itself, but there was an ODBC and JDBC (https://rmoff.
About Me
whoami Robin is a Principal DevEx Engineer at Decodable.
He has been speaking at conferences since 2009 including QCon, Devoxx, Strata, Kafka Summit, and Øredev.
You can find his talks online, subscribe to his YouTube channel, and read his blog. Outside of work, Robin enjoys running, drinking good beer, and eating fried breakfasts—although generally not at the same time.
👉🏻 Bio & speaker photos Speaking experience Speaker since 2009 at conferences including QCon, Devoxx, O’Reilly Strata, NDC, USENIX LISA, Kafka Summit, Øredev, O’Reilly SACon, Oracle OpenWorld, JavaZone, Big Data LDN, UKOUG, Oracle CODE, PGConf, etc plus numerous meetups.
Talks
See talks
Talks
You can find all my recent talks on Notist at https://talks.rmoff.net/. Older ones are on Speaker Deck.
I have a variety of talks, around several different aspects of Apache Kafka and related technologies.
Kafka 101 / introductory talk : “Kafka as a Platform: the Ecosystem from the Ground Up” Introduction to ksqlDB and stream processing principles and semantics - with lots of live demos. “An introduction to ksqlDB” Live demo showing use of Kafka Connect and ksqlDB: “Apache Kafka in Action : Let’s Build a Streaming Data Pipeline!
