BO IDT Multi sourcing issue TNS error for oracle DB
We have oracle DB and MSSQL DB Connections, used below drivers.
Oracle – Oracle client and MS SQL – JDBC
Connections are working fine, if we use single Source while creating Data foundation.
But when I use Multi Sourcing with one is oracle and other is MSSQL – Oracle always showing TNS error timeout when I expand the table and MSSQL showing all the tables.
If I use both MSQSL DB’s its works fine.
Error screen below.