[Klug-general] Open Database Standards/Protocols
danattwood at googlemail.com
Mon Feb 8 19:57:49 UTC 2010
have a look as apatar: http://www.apatar.com/
and there's an other more complicated one the name of which escapes me.
Is that the kind of thing you want?
On 8 February 2010 19:51, Ian Pascoe <ianpascoe at btinternet.com> wrote:
> Slightly OT, but hopefully someone out there can provide some pointers.
> At work we're looking for a transport mechanism that will allow various
> databases to communicate with one another, this is in the form of a 3 tier
> aproach, over multiple systems. At the base level we have the live
> databases, these then send snapshots into a data warehouse, and on top of
> this we have users and other interested parties connected. This is great
> for us as it means the users can't damage the live systems!
> So far so good. The problem that we have is that most of the top and
> layers are on different database platforms, Oracle, MySQL, MS SQL, MS
> and quite a few others besides.
> The headache we have at the moment is between the data warehouse and end
> user systems, and instead of having to write a dedicated app to communicate
> between each system we were going to look at some type of protocol /
> mechanism that we could generalise out. This is going to be a BIG task!
> So, the question is, does anyone know of such a protocol that will work
> a VPN as well as a LAN / WAN / SAN setup?
> Yes, I know there's XML and that's probably where we'd go from stage 1, but
> the schema, oh the schema ....
> Pointers welcome.
> Kent mailing list
> Kent at mailman.lug.org.uk
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Kent