Send Steady UDP Stream From MSSQL
Posted on 2013-01-25
We're looking either for some advice, direction, and/or a recommendation here.
We have an MSSQL database application, that runs our Point of Sale front end. The publisher of the Video Surveillance system that we use, to properly "integrate" the POS data to their system, requires us to transmit the MSSQL data...via UDP...in an ASCII "CSV" stream...to their servers. Note...this is a ONE-WAY stream...MSSQL must output *TO* the Vidoeo Surveillance system, and *NEVER* vice-versa. Because this is near real-time transactionally based, there will be a lot of traffic as a result...and we both expect that, and have the network infrastructure to handle it.
Having never done this before...we were hoping that someone that has done this...can shed some light here. Even if there's some 3rd Party package that can handle the data conduit...certainly that would be fine.
So...any suggestions y'all? Anyone ever done this? Looking for something tried & true. Please let us know...and THANK YOU very much in advance!...Mark