Hi All,
I'm currently working on establishing a connection between Oracle Data Integrator (ODI) 12c and a Microsoft SQL Server instance, and I'm encountering an issue during the reverse engineering process.
The data server has been successfully created and the connection test passes without any issues. However, when I attempt to create a model and perform reverse engineering, I receive the following error:
java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]Error establishing socket to host and port: hostname:1433. Reason: Connection timed out: connect
We are using the following JDBC URL in the data server configuration within Topology:
jdbc:weblogic:sqlserver://hostname:1433;database=SAMPLE;
Could anyone provide guidance or suggestions on how to resolve this connectivity issue?
Thanks in advance for your support.