Data Source Connectivity from BI Admin Tool

When creating a new repository or while importing from a data source using OCI interface, you get the “connection has failed” error.

This is because, the BI Admin tool is not able to find the TNS entry. to resolve this,

Copy your tnsnames.ora (from your oracle database home\network\admin) to {Oracle_BI1}\network\admin directory & {oracle_common}\network\admin directory

OR

go to $ORACLE_INSTANCE\bifoundation\OracleBIApplication\coreapplication\setup

add this entry in the user.cmd / user.sh file

set TNS_ADMIN=D:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN

you might want to restart the BI Admin Tool.