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.
Hi, In your case it have worked but in all cases User name might not match Schema name as we are also using MS SQL and we do have different User names and Schema names where no User name matches with their corresponding Schema Name. Thanks any ways for reply.