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.
Restart WebAnalysis service and you are ready to go!!!!