>- see footer for list info -< For a good understanding of the pros and cons of different forms of integration the first few chapters of this book are invaluable:
Patterns of Enterprise Application Architecture http://www.amazon.com/Patterns-Enterprise-Application-Architecture-Fowler/dp /0321127420 Essentially your choices boil down to Messaging, Shared database, Remote procedure calls (including webservices) and the good old reliable file transfer. While the books focus is on integration using messaging, it does a good job of discussing the pros and cons of the other choices. There is also some good info on the accompanying site: http://www.enterpriseintegrationpatterns.com/ http://www.enterpriseintegrationpatterns.com/Introduction.html If you have a Safari subscription you can read the first few chapters online... HTH Kola > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dev- > [EMAIL PROTECTED] On Behalf Of Marketsuite Support > Sent: 28 September 2006 18:20 > To: [email protected] > Subject: [CF-Dev] Integrating with third party databases / datasets > > >- see footer for list info -< > Evening all, > > > > I have been asked to evaluate whether there are any api's / connectors etc > which can connect our application / SQL database to our clients external > datasets. > > > > I really have absolutely no knowledge in this area but it seems our clients > want their data to reside in-house (as always) and we have to build > something to parse information > > Backwards and forwards between the client database and ours. At the moment > clients are doing CSV uploads into our system which is fine for smaller > clients but larger clients don't like it. > > > > God I hate not knowing things when the sales boys ask questions!! Damn it! > > > > Any help / advice you could give would be much appreciated. > > > > Chris > > > > > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
