When we migrate across different environments, the schema name changes. For example, in Dev we have a DB schema called DEVDB, in SIT SITDB and in Production its PRODDB.
When we configure JDBC Adapter Notifications, under Tables tab, we specific the name of the table (Table Name, center option) as DEVDB.table_name. When we migrate the code to SIT, the table resides in SITDB.table_name and not DEVDB.table_name. How do we handle this scenario.
In Adapter Services, we can use the custom SQL Templates and the issue is taken care of. I am not sure how we do for Adapter Notifications.