Hello,
If your test connection is getting timed out, following the below troubleshooting steps.
- Check whether JDBC URL is correct.
- Check whether you have explicitly provided the port to which your Target DB is pointing to.
- Check whether through SQL Developer client, the credentials and URL are working as expected.
- If above 3 are as expected, then, it could be the connectivity issues from your VA.
- Check connectivity from VAs using ping and netstat command to check connection with host and port respectively.
- If connections are getting timed out from VAs as well, then, surely its a connectivity issue which could be resolved by the firewall team.
- Also, make sure that correct JDBC driver files are imported in your connector. It seems that is not issue in your case but still, its good to check it once.
- Also, check whether target DB is supporting the SQL Native Authentication or Windows Authentication & change your configurations of connections accordingly.