JDBC Adapter against MS SQL server does not list synonyms when creating JDBC services or notifications.
Is this a limitation in the MS SQL driver, I seem to remember this working for me earlier though that was an Oracle DB.
We have a scenario where tablenames changes between environments. It’s a tool that replicates data from one db/table to another. It sufixes the original name with the source along the way. Until they can fix this we thought perhaps synonyms could solve the problem.
Synonym in each database would be person and point to the correct table. The adapter would then reference person isntead of personTblFromX.