msami07

msami07 ·

Hi @msami07,

I designed the integration for a single Oracle db-connection, your use case is not expected.
Can you use database links to your SQL Server database? This is the typical workaround in those cases in the "Oracle world".

• https://duckdu...

I have created a jasper report using jasper studio:-main query from oracle DB-another dataset from SQLServer-load the jdbc driver using parameter and assign the "Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver")" to its Default-Expression-m...