[zeromq-dev] zmq & mssql queue to insert data

[Baranski, Antek]

We've actually come up with a potential solution :) what we are going to try and do is the following.

Our collector will reside in the production network and will be written in Java so that it's just easy to develop and maintain, the collector will use 0MQ to publish (queue) the results.

On the corporate network we will build a C# extention to the MSSQL queue service that will watch the collector queue using 0MQ this should enable us to marry the 2 systems together with as little custom code written as possible.

Antek S. Baranski
Technical Director - Development Transformation
EA Sports, Canada
Work : 	604 - 456 - 1746 (x11746)
Cell : 	778 - 668 - 7174

-----Original Message-----
From: Martin Sustrik [mailto:sustrik at fastmq.com] 
Sent: Thursday, August 06, 2009 7:06 AM
To: Baranski, Antek
Cc: 'Pieter Hintjens'; 'zeromq-dev at lists.zeromq.org'
Subject: Re: [zeromq-dev] zmq & mssql queue to insert data

Baranski, Antek wrote:
> The java plug-in lives in the production network my DB lives in the
> office network and the connectivity between the 2 is very much
> limited.
> 
> We could off course write an app on the receiving side that listen to
> the various 0MQ queues and insert the data that way, but I was hoping
> not having to create a server/app to do this and use MSSQL's queue
> mechanism but that would only work if I can somehow hookup the 0MQ &
> MSSQL queues which probably is a no-go judging by the responses so
> far.

No, it's not part of 0MQ and AFAIK no messaging system does this. What 
happens with the message after it is delivered is considered to be 
application's responsibility. Thus, I would either look for a different 
product to stack on top of 0MQ (googling for 'logger' or so may yield 
some pointers) or implement the logging functionality myself. In the 
latter case making it open source would make sense.

Martin