We are wanting to integrate Milestone Transact to just a simple SQL table in our warehouse environment. Basically, if an inventory move is conducted with a mobile scanner we want to pick up that pallet ID, date/time, and dock number in the SQL table for that transaction and associate it with a specific transaction. I see there are serial connections and TCP XML streams supported, is there a pre made SQL connector or are we going to have to roll our own?
You’ll have to roll your own as there’s no transact connector plugin for SQL.
Are you wanting to just monitor a table and wait for new data to arrive? Would you setup a trigger on the table(s)?
SQL just seems like a natural thing to have a connector for out of the box, wishful thinking I guess. Yes, we’d just wait for new data to arrive, we could set up a SQL trigger pretty easily. Basically, when a pallet is received an entry will be made to the table. We want to link that entry to the video of the pallet in our staging area as it is loaded onto the trucks for QA purposes. The Transact documentation is awfully light (at least from what I’ve seen in the Admin guide, couldn’t find anything else), and I’m hoping we can additionally associate the shipping dock number in that SQL record to the specific camera pointing to that particular dock.
If you end up deciding to write your own Transact connector you can find the documentation for doing that here:
https://doc.developer.milestonesys.com/html/index.html?base=transacthelp/index.html&tree=tree_1.html
The SDK also includes a sample of a connector.