We are using the ODBC connector to interface with a SQL Server based ERP and have a couple of requests:
1. It would be helpful, at least for us, if the ODBC connector could see and link to views as well as tables in the SQL Server database, so that we could conveniently link to data contained in multiple tables without having to used custom query code to upload and download data.
2. As a B to B manufacturer/wholesaler, we not infrequently ship COD and Saturday delivery. Neither of these options can be passed from SQL Server to Shipworks via ODBC. Both have to be selected manually at the time of shipment. Also neither is available in the XML for upload back to SQL Server, so the ERP cannot be updated for the COD amount or Saturday delivery option. Either or both of these would be helpful additions for us.
Please sign in to leave a comment.