Mar 23, 2009
Mar 23, 2009

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.
Connections also work when specifying the hostname only (i.e. no FQDN).

Jan 1, 0001
Jan 1, 0001

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 (link:/2016/03/28/connecting-to-obiee-via-jdbc-with-jisql/) API that other tools could have built against.

Jan 1, 0001
Jan 1, 0001

Tip

  • 🔥 Not got time for all this? I’ve marked my top reads of the month :)

  • 📧 Want to receive this monthly round-up as an email? Subscribe to my Substack where I cross-post the same content

  • 🔗 Medium posts often skulk behind a gate, so I’ve hyperlinked to the Freedium version. You’ll see [Medium ↗] next to each link if you prefer the original.
Jan 1, 0001

About Me

whoami

Robin is a Sr. Principal Advisor, Streaming Data Technologies at Confluent.

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.

Jan 1, 0001
Jan 1, 0001

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!”
  • Architectural view of Kafka and its implications for data engineering & data warehousing: “The Changing Face of ETL: Event-Driven Architectures for Data Engineers”
  • Deep-dive on Kafka Connect: “From Zero to Hero with Kafka Connect”
  • Nitty-gritty examining options of how you get data into Kafka from RDBMS “No More Silos: Integrating Databases and Apache Kafka”
  • PoC showing how to build streaming ETL/data platform around live data feeds: “🚂On Track with Apache Kafka: Building a Streaming Platform solution with Rail Data”
  • Example of integrating IoT data over MQTT into Kafka and processing it: “Building IoT applications with Kafka and ksqlDB”

Detailed abstracts are available on request for these. Recordings and slides for many can be seen at https://talks.rmoff.net/