Migrate Hyperion Interactive Reports v11.1.2.4 to OBIEE v11.1.1.7

This post intends to provide an assessment to determine if the Hyperion Translation Workbench could play a role in the migration of Hyperion IR assets to the target OBIEE 11.1.1.7. Follow this link for more information on the Translation Workbench http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/obiee-conv-txnwb-406022.pdf Below are the technical characteristics of the software components involved in this exercise Hyperion […]

Hyperion Interactive Reporting Sandbox Setup

This post is intended to provide the steps needed to build a sandbox environment to try out the Hyperion Interactive Reporting (IR) in preparation for a migration to the Oracle OBIEE 11/12 Analytics. For background information on Hyperion IR, go to this link http://www.oracle.com/technetwork/middleware/bi-foundation/index-101307.html The sandbox to be set up will be hosted in a […]

Configure Oracle 12g Connection in Cognos 10.2

This post is a follow-up discussion after the initial installation of the new IBM Cognos 10.2 evaluation software. Below are the steps that help you configure a Cognos connection to connect to an Oracle database. I am using the Oracle 12g database in this example, but it should also be applicable to the other Oracle […]

JDBC Drivers

You can download some of the jdbc drivers mentioned in my posts on this site. Oracle 11g ojdbc5.jar ojdbc6.jar Oracle 12g ojdbc6.jar ojdbc7.jar MySQL mysql-connector-java-5.1.38-bin.jar SQL Server sqljdbc4.jar sqljdbc41.jarsqljdbc42.jar jtds jtds-1.3.1.jar Below are the links that you might want to go directly for any latest updates http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html https://dev.mysql.com/downloads/connector/ https://www.microsoft.com/en-us/download/details.aspx?id=11774 http://jtds.sourceforge.net/

Install OBIEE 12C on Windows 10

Just in case you want to try out the new Oracle Business Intelligence Suite OBIEE 12C on Windows 10 OS, below are the steps you would likely need. Notes: You can download the necessary software from Oracle http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-2717951.html. You might also need the JDK 1.8 if you do not have it yet on your PC/Laptop. […]