BO IDT Multi sourcing issue TNS error for oracle DB

[Former Member]

Hi All,

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.

Thanks

Nageswara Polaka

[amitrathi239]

Hi,

check this sap note.

2127285 - What is the best practice for troubleshooting Oracle connectivity issues within Informatio...

Amit