Solved
External Database Oracle Connection
Originally posted by Krishna Srinivasan Does anyone connected Oracle Database as external DB ? If so could you please provide the connection string OLEDB or ODBC ? When I try to connect am getting ...
Forum Discussion
Thanks Jeff. It really helped.
I was able to fix it today. I have to install Oracle Client and Create DSN name for OLEDB provider information. I was able to create DSN & able to establish the connection. When I try to test the connection.
The Below steps I followed to connect to Oracle EBS ERP System. It is required if it is an On-Premise system.
- Install Oracle Client.
- Create a TNS Name Entry with the Alias. See the below sample.
EBS=
(DESCRIPTION =
(ADDRESS_LIST =(ADDRESS =(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)
))
(CONNECT_DATA=
(SID=SIDName)
(SERVER=DEDICATED)
)
)
- Create UDL and test the connection. The Data Source is EBS defined in previous step.
- Provide the connection string in the Config file (External DB).