> From: Lunt, Bruce > Both ways. They will receive our order info and we > will receive their updated inventory and customer data.
Two things: First, is JDBC the only connectivity option they offer? There could be easier ways to do this. Second, I wrote a blog entry in August that answers all of these "how do I connect my MV system to X?" Please remove the anti-spam 'remove': <removeNebula-RnD.com/blog/tech/mv/2009/08/mv-to-anything.html> The answer to connecting MV to anything is always simplified if you don't try to go directly from U2 to every "X". Just use one good pipe in and out of your U2 system. Then you just need to work out the individual pipes into other environments - which you need to do anyway so this is no extra effort. For example. Rather than this: U2<jdbc>Partner1 U2<odbc>Partner2 U2<socket>Partner3 U2<CSV>Partner4 U2<FTP>Partner5 U2<webservice>Partner6 ... Try this: U2<Z>middle<jdbc>Partner1 U2<Z>middle<odbc>Partner2 U2<Z>middle<socket>Partner3 U2<Z>middle<CSV>Partner4 U2<Z>middle<FTP>Partner5 U2<Z>middle<webservice>Partner6 ... Why do that? Because all you need to do is work out the "Z" part once, and you'll never again have to ask "can I do this with U2?" At that point you're just another developer/company using whatever technology people ask you to use. U2/MV is no longer some isolated, unknown, questionable entity. What is Z? Anything you want. At this point YOU control what the technology is, and you can change it any time you want. ODBC? UO.NET? UOJ? Something else? You pick it. What is "middle"? You move data to some middle tier where you're comfortable, then move data from there to any "X". You control that middle tier which can be a text file, memory stream, ADO.NET DataSet, MySQL table, or some other holding area. From there getting the data to anywhere else is relatively easy. This is also good for security too since no one ever needs to get directly into your system. Only you control the <Z>middle component. Everyone else interfaces to the middle tier. If you try to use a bunch of technologies to get in and out of your U2 box, driven by the dictates and limitations of your trading partners, the patchwork of U2-centric solutions will be difficult to maintain, and it will be tough to hire/contract someone who can maintain all of the components because doing X with U2 is a specialty knowledge set. If you use the above method, you just need to learn/use a single "Z" pipe, whatever that is, and you can get anyone who doesn't know a thing about U2 to do the other part. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
