We are on wM v.9.7. I have two connections to a MS SQL Server for an integration, XA & LOCAL. The connection isconnected and I can create adapters, but in the Tree Chooser, I do not see the tables that I need to read and write. I do see these tables in Squirrel, but not in IS. Both Squirrel and IS are using the same user in MSSQL.
I’ve attached screen grabs from both Squirrel and Designer.
You can see that tables ETL_IN, ETL_OUT, do not show up in designer.
The MS environment in Windows Server 2012, MSSQL 2014, wM version 9.7 and JDBC adapter version 6.5.