I'm having the same problem. Here is my setup...
I've created a (MSORA) Microsoft Connector for Oracle by Attunity connection. I populate the connection with a tns-name, username, and password. I click the Test Connection button, and I see the following:
The full error is as follows:
===================================
Error at Export SingleFile [Connection manager "Sample"]: Oracle Home not found.
(Microsoft Visual Studio)
===================================
Test connection failed
===================================
Oracle Home not found.
(Export SingleFile)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.AcquireConnection(Object txn)
at Attunity.IntegrationServices.DataFlowUI.OracleUI.OraConnectionDialog.testConBtn_Click(Object sender, EventArgs e)
===================================
Oracle Home not found.
(Export SingleFile)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.AcquireConnection(Object txn)
If its not pulling oracle_home from my system variable, where does it pull it from?
Here is the ORACLE_HOME environment variable on my system:
There was an issue documented in the post Attunity Oracle Conenctor doesn't work after update, which identified a compatibility issue between version-5.0 of the Oracle connector and the latest version of SSDT (15.9.x as of 02/01/2019). Until the compatibility issue has been resolved, the de-facto solution is to deploy the 15.8.0-release of SSDT. This will install the 14.0.3002.113 Microsoft SQL Server Integration Services Designer.
Here were the steps I executed to resolve:
Here are shots from my environment...
Cheers, Adam