Daniel:
My fellow subscribers to this NS forum may cringe at this answer, but I
don't think NS would be a good choice. It's pretty much one-way
communication, with no method to confirm to you (the sender) that the
recipient got the data.
If the systems you are connecting to are all SQL 2005, then I would look
into a Service Broker solution. Another option might be SSIS, the replacement
of 2000's DTS.
Just curious how you would build a 'generic' system if the requirements of
each of its uses is different! Seems like you are going to need to do some
custom work!
Good luck!
--
Todd C
[quoted text, click to view] "Daniel" wrote:
> My company has several customers that are requesting us to build
> interfaces to their existing systems. I'm looking for a generic and
> configurable solution since I need to interface with so many different
> systems and I don't want to have to write a custom program for each one.
> Each interface I need to build is slightly different in the data it should
> transmit and receive, the file formats used, delivery mechanisms, etc.
> I'm considering using SQL Notification Services but I am wondering if it
> is feasible to build something like this with it.
>
> The external systems can be programs watching for a file to be sent over
> FTP, programs exposing web services, programs using Microsoft Message
> Queues, etc. Also, some of these external systems will be sending data
> back that I will need to process. Again, this data can be sent in a
> number of formats and by a number of delivery methods.
>
> How feasible would it be to build a system like this using SQL
> Notification Services? What drawbacks are there to using it? Does anyone
> have any experiences or can anyone offer me advice in building interfaces
> to external systems using Notification Services?
>
>
> Daniel
My company has several customers that are requesting us to build
interfaces to their existing systems. I'm looking for a generic and
configurable solution since I need to interface with so many different
systems and I don't want to have to write a custom program for each one.
Each interface I need to build is slightly different in the data it should
transmit and receive, the file formats used, delivery mechanisms, etc.
I'm considering using SQL Notification Services but I am wondering if it
is feasible to build something like this with it.
The external systems can be programs watching for a file to be sent over
FTP, programs exposing web services, programs using Microsoft Message
Queues, etc. Also, some of these external systems will be sending data
back that I will need to process. Again, this data can be sent in a
number of formats and by a number of delivery methods.
How feasible would it be to build a system like this using SQL
Notification Services? What drawbacks are there to using it? Does anyone
have any experiences or can anyone offer me advice in building interfaces
to external systems using Notification Services?
