odbc How To Poke Around OBIEE on Linux with strace (Working with Unsupported ODBC Sources in OBIEE 12c) OBIEE 12c (and 11g and 10g before it) supports three primary ways of connecting to data sources: Native Gateway, such as OCI for Oracle. This is always the preferred option as it gives the greatest support and performance. Data Direct ODBC Drivers, a set of which are bundled with OBIEE
Technical System Metrics Collectors The need to monitor and control the system performances is not new. What is new is the trend of clever, lightweight, easy to setup, open source metric collectors in the market, along with timeseries databases to store these metrics, and user friendly front ends through which to display and analyse
Technical New OTN Article - OBIEE Performance Analytics: Analysing the Impact of Suboptimal Design I’m pleased to have recently had my first article published on the Oracle Technology Network (OTN). You can read it in its full splendour and glory(!) over there, but I thought I’d give a bit of background to it and the tools demonstrated within. OBIEE Performance Analytics Dashboards
Technical Using Linux Control Groups to Constrain Process Memory Linux Control Groups (cgroups) are a nifty way to limit the amount of resource, such as CPU, memory, or IO throughput, that a process or group of processes may use. Frits Hoogland wrote a great blog demonstrating how to use it to constrain the I/O a particular process could
Technical OBIEE Monitoring and Diagnostics with InfluxDB and Grafana In this article I’m going to look at collecting time-series metrics into the InfluxDB database and visualising them in snazzy Grafana dashboards. The datasets I’m going to use are OS metrics (CPU, Disk, etc) and the DMS metrics from OBIEE, both of which are collected using the support
Technical Linux cluster sysadmin -- OS metric monitoring with colmux In this mini-series of blog posts I'm taking a look at a few very useful tools that can make your life as the sysadmin of a cluster of Linux machines. This may be a Hadoop cluster, or just a plain simple set of 'normal' machines on which you want to
Technical Linux cluster sysadmin -- Parallel command execution with PDSH In this series of blog posts I'm taking a look at a few very useful tools that can make your life as the sysadmin of a cluster of Linux machines easier. This may be a Hadoop cluster, or just a plain simple set of 'normal' machines on which you want
Technical Linux cluster sysadmin -- SSH keys In this short series of blog posts I'm going to take a look at a few very useful tools that can make your life as the sysadmin of a cluster of Linux machines easier. This may be a Hadoop cluster, or just a plain simple set of 'normal' machines on
Technical SampleApp v406 - Automatic startup of OBIEE Last week Oracle released v406 of SampleApp. SampleApp is a one-stop-shop for a demonstration of pretty much any conceivable thing that OBIEE is capable of, and then some more on top of it. It is a VirtualBox appliance with everything on the one machine (Database, OBIEE, Endeca, TimesTen, Essbase, etc)
Oracle BI Suite EE Make Use of OBIEE's Command Line Tools with Reduced Exposure of Plain Text Passwords Introduction We all love a good commandline utility. It gives us that warm feeling of control and puts hairs on our chests. Either that, or it means we can script the heck out of a system, automate many processes, and concentrate on more important matters. However, some of the OBIEE
Oracle BI Suite EE Tips and Tricks for the OBIEE linux sysadmin As well as industry-leading solution architecture, consultancy and training on Oracle BI, here at Rittman Mead we also provide expert services in implementation and support of such systems. In this blog I want to share some of the things I find useful when working with OBIEE on a Linux system.
Technical Downloading OBIEE patches from Oracle with wget Last week saw the release of OBI 11.1.1.6.2 BP1, and with it, some eight patches to download (seven OBIEE, plus one JDeveloper). A very useful option when downloading the patches, particularly if you are working on Linux servers with no GUI, is to download the patches
Technical screen and OBIEE With the recent delivery of the Rittman Mead Exalytics server, I have been fortunate enough to be spending time setting it up, most of it at a Linux terminal window. One of the tools I come back to, again and again, is screen. It allows one to be so much
Business Insights Configuring OBI 11g to use port 80 Introduction By default, OBI 11g will listen for connections on port 7001 or port 9704 depending on your installation type. There are several reasons you may want to change this, and one of them would be to make it use port 80, the default http port. If you use port
Technical Running the OBIEE Administratiol tool on Unix using Wine The other day I was playing with getting OWB11gR2, which at the time of this writing, has only been released under Linux and Solaris, to run under Windows. In the pursuing comments Jon Mead threw down the gauntlet and asked if I could figure out a way to run the
Technical OWB 11gR2 Workspace Creation Issues First of all, I'd like to thank David Allan of the OWB Product Team for helping me solve the problem I discuss below... and also for identifying what he thinks to be the cause. A few days after Oracle Database 11gR2 was available, I went about building my first VM
Technical Managing multiple Presentation Services on the same Unix box As I had mentioned, I wanted to write up a bit on how to go about setting up multiple Oracle BI presentation services, each configured to access a different repository file (RPD) running on the BI Server. The thing is that you can easily set up the BI server so
Technical Installing OBIEE 10.1.3.2.1 on Ubuntu Part II Ok, so I tried running the OBIEE installer again, this time choosing only BI Server option. When I read through the install.log I noticed that it was complaining about that the UnixChk.sh didn't exist. The reason for that was simple, I had renamed it when I was writing
Technical Installing OBIEE 10.1.3.2.1 on Ubuntu 7.04 … not so fast Well, this was a productive 2 hour stint. I just managed to hack my way past the OBIEE installer to get ahead to the actual installation. After downloading the cpio (I chose the RedHat file, since I knew that I could at least install the Oracle Linux because I have
