David Arc SDE is a middleware process that does not allow guaranteed sharing of data with other programs that use Oracle Spatial. Others more cynical than me have suggested that this is deliberate. (Actually I think I've suggested it too). SDE will use lots of different DBMS as a repository for data and use database indexing as available to optimise performance but essentially it maintains its own indexes - and why not, its a proprietary product.
The result being that if you use MapInfo (or AutoCAD etc) to EDIT (not view) data thats being maintained elsewhere by SDE you will get unpredictable results. so you probably need two schemas containig the same data. To shunt edits made by different clients on the same spatial data AS THEY OCCUR is probably a non-starter - triggers etc have their place but keep them out of the business layer. The likelihood is that you could probably get away with a once-a-day or once-a-week replication. True live access may not be necessary. And somebody please tell me I'm wrong, it would make life much easier. Paul Crisp Syntegra Innovation Place Delta Bank Road Newcastle NE11 9DJ Tel 0191 461 4522 Fax 0191 460 1987 -----Original Message----- From: Eagle, David A [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 12:36 To: [EMAIL PROTECTED] Subject: MI-L MapInfo reading ArcSDE? Folks, I have a situation that I would like some advice on. ANY comments welcome or shared experience! We have a client that has converted MasterMap data (vector data from Ordnance Survey, UK) using ESRIs MapManager 8.1 from *.GZ format into ARC SDE format and have stored it in Microsoft SQL Server. The data is then read by ARC IMS and ARC MAP as the clients. I would like to access that data with another client, namely MapInfo and I would rather not re-convert the data or have to manage a second data holding. What are my options? Would using FME as middleware to convert on the fly be feasible or restrictive due to speed. Maybe I could covert to TAB from ARC SDE using FME as the middleware and then put a trigger in SQL to trigger data management in my second holding when the first is updated...or maybe I'm trying too hard? MapInfo corp advise me that Spatialware will not read ARC SDE so I don't think that is an option unless anyone knows better? Any thoughts? Best Regards, David This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.syntegra.com ******************************************************************** --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 7688
