When I created an adapter service using batchInsert templates I am unable to see any tables under current schema. We have given a DB user and DBA has created a Synonym for this table.
I can access the table from SQL developer (select * from Table_1) and I can access the same table using custom SQL template (in wM) only.
Can anyone help to resolve the issue so that tables appear in
current catalog → current schema and I can select from drop down.
Thanks in advance!!