WebAnalysis Relational Database connection issue

This is for all the WebAnalysis Users who intend to create a SQL spreadsheet in WebAnalysis Studio.

When you try to add a SQL spread sheet you may have come across this error “Getting Connection Failed.”

WebAnalysis is not shipped with the JDBC drivers for making a relational database connection, and that’s the reason why you are getting this error.

To solve this error, download the respective JDBC drivers.

Location for Oracle JDBC drivers

Location for SQL JDBC drivers

Extract the downloaded JDBC drivers to the WEB-INFlib folder of your WebAnalysis installation.

E.g. G:HyperiondeploymentsWebLogic9serversWebAnalysiswebappsWebAnalysisWEB-INFlib

Restart WebAnalysis service and you are ready to go!!!!

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.