Return
-
Title
Invalid data source definition: Invalid response. Ensure you are connecting to the correct OBIEE URL -
Description
Following documentation to connect to a OBIEE server one may see the error:Data Service Database ErrorInvalid data source definition: Invalid response. Ensure you are connecting to the correct OBIEE URL.The issue happens when connecting to a 12C instance, and, when checking the "System Requirements" section in the Release Notes for Toad Data Point (TDP) version 4.3, in the "Business Intelligence Connections" list, the only one listed is:*** Oracle Business Intelligence Enterprise Edition 11g -
Resolution
Although it's not mentioned in TDP's Release Notes, v4.3 was tested connected to 12c OBIEE servers, and it works.But, one has to add "-ws" to the URL:http://[YourBIserver]/analytics-ws/saw.dllAs in the "Enabling the Online Catalog Manager to Connect" section in the Oracle's document:"New Features in Oracle Business Intelligence Security"It says:"the Oracle Business Intelligence URL http://hostname:port_number/analytics becomes protected, and you must point the online Catalog Manager to the URL http://hostname:port_number/analytics-ws instead. "