Re: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE
HI Alistair, Good point, I didn't think about sending the data via WFS, but the problem there is you've got yet another intermediate layer to set up and maintain (ArcSDE one too many if you ask me!). A direct connect would obviate that problem which is why its our preferred solution. The fewer pieces of middleware we need to support and maintain, the better. Thanks though, Jonathan On 24 August 2012 07:42, Alister Hood alister.h...@synergine.com wrote: Hi, Date: Wed, 15 Aug 2012 10:09:40 +0100 From: Jonathan Moules jonathanmou...@warwickshire.gov.uk To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE Message-ID: CAA-xNcW_LyK35Ug=usqKLK=qBP= ujwkt9fsoj2_rstg2xwk...@mail.gmail.com Content-Type: text/plain; charset=iso-8859-1 Hi List, I'm investigating QGIS as a possible suplement to our corporate systems (ArcGIS/MapInfo). We store all of our vector data in an Oracle Locator database and can either connect to it directly or through ArcSDE. Unfortunately it doesn't seem that QGIS is able to natively connect to either of these. I've done some brief searching, but most of the results point to qgis.orgwhich isn't responding for me currently. What I can find suggests that most things want to go either either OGR or GDAL as an intermediary layer, but I'm concerned these will greatly slow down data loading (some of our layers are very big, including Ordnance Survey MasterMap). Did you make any progress with this after the server came back up? I guess you are using Windows (not that I would recommend doing so :) ). The gdal-sde plugins I posted on the old forum don't work with the latest gdal. But I extracted some new ones from http://dl.maptools.org/dl/ms4w/ms4w_3.0.6.zip and they seem to work fine (I finally found a publicly accessible server that I could successfully test with!). So my question is simple - what would be the optimal way for QGIS to read this data (we're not interested in writing)? Can your server not provide WFS? If you could enable it easily on the server I would have thought that would be the easiest and most flexible option. This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE
Hi, regarding OracleLocator/Spatial: in the QGIS developer version there will be native Oracle support - Jürgen Fischer will be working on it (contract with Province Vorarlberg and City of Dornbirn). I don't know the exact dates when it will be available, but probably late autumn, early winter 2012. Andreas On Fri, 31 Aug 2012 12:50:05 +0100, Jonathan Moules wrote: HI Alistair, Good point, I didn't think about sending the data via WFS, but the problem there is you've got yet another intermediate layer to set up and maintain (ArcSDE one too many if you ask me!). A direct connect would obviate that problem which is why its our preferred solution. The fewer pieces of middleware we need to support and maintain, the better. Thanks though, Jonathan On 24 August 2012 07:42, Alister Hood wrote: Hi, Date: Wed, 15 Aug 2012 10:09:40 +0100 From: Jonathan Moules To: qgis-user@lists.osgeo.org [2] Subject: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE Message-ID: Content-Type: text/plain; charset=iso-8859-1 Hi List, I'm investigating QGIS as a possible suplement to our corporate systems (ArcGIS/MapInfo). We store all of our vector data in an Oracle Locator database and can either connect to it directly or through ArcSDE. Unfortunately it doesn't seem that QGIS is able to natively connect to either of these. I've done some brief searching, but most of the results point to qgis.orgwhich isn't responding for me currently. What I can find suggests that most things want to go either either OGR or GDAL as an intermediary layer, but I'm concerned these will greatly slow down data loading (some of our layers are very big, including Ordnance Survey MasterMap). Did you make any progress with this after the server came back up? I guess you are using Windows (not that I would recommend doing so :) ). The gdal-sde plugins I posted on the old forum don't work with the latest gdal. But I extracted some new ones from http://dl.maptools.org/dl/ms4w/ms4w_3.0.6.zip [4] and they seem to work fine (I finally found a publicly accessible server that I could successfully test with!). So my question is simple - what would be the optimal way for QGIS to read this data (we're not interested in writing)? Can your server not provide WFS? If you could enable it easily on the server I would have thought that would be the easiest and most flexible option. This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. Links: -- [1] mailto:jonathanmou...@warwickshire.gov.uk [2] mailto:qgis-user@lists.osgeo.org [3] mailto:ujwkt9fsoj2_rstg2xwk...@mail.gmail.com [4] http://dl.maptools.org/dl/ms4w/ms4w_3.0.6.zip [5] mailto:alister.h...@synergine.com -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE
Il 31/08/2012 13:50, Jonathan Moules ha scritto: Good point, I didn't think about sending the data via WFS, but the problem there is you've got yet another intermediate layer to set up and maintain (ArcSDE one too many if you ask me!). A direct connect would obviate that problem which is why its our preferred solution. The fewer pieces of middleware we need to support and maintain, the better. This is right, but using standard interfaces (WFS) will make you more free to move and migrate parts of your infrastructure. Always a good move in my experience. All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE
I'm glad to hear about the native Oracle provider. Is it something public? I mean, can we preannouce it to clients? @Paolo You're aware that WFS transport protocol isn't always adequate, especially with huge datasets... Sent from Nexus Il giorno 31/ago/2012 15:17, Paolo Cavallini cavall...@faunalia.it ha scritto: Il 31/08/2012 13:50, Jonathan Moules ha scritto: Good point, I didn't think about sending the data via WFS, but the problem there is you've got yet another intermediate layer to set up and maintain (ArcSDE one too many if you ask me!). A direct connect would obviate that problem which is why its our preferred solution. The fewer pieces of middleware we need to support and maintain, the better. This is right, but using standard interfaces (WFS) will make you more free to move and migrate parts of your infrastructure. Always a good move in my experience. All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE
Hi, Date: Wed, 15 Aug 2012 10:09:40 +0100 From: Jonathan Moules jonathanmou...@warwickshire.gov.uk To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Accessing an Oracle database, natively or through ArcSDE Message-ID: CAA-xNcW_LyK35Ug=usqKLK=qBP=ujwkt9fsoj2_rstg2xwk...@mail.gmail.com Content-Type: text/plain; charset=iso-8859-1 Hi List, I'm investigating QGIS as a possible suplement to our corporate systems (ArcGIS/MapInfo). We store all of our vector data in an Oracle Locator database and can either connect to it directly or through ArcSDE. Unfortunately it doesn't seem that QGIS is able to natively connect to either of these. I've done some brief searching, but most of the results point to qgis.orgwhich isn't responding for me currently. What I can find suggests that most things want to go either either OGR or GDAL as an intermediary layer, but I'm concerned these will greatly slow down data loading (some of our layers are very big, including Ordnance Survey MasterMap). Did you make any progress with this after the server came back up? I guess you are using Windows (not that I would recommend doing so :) ). The gdal-sde plugins I posted on the old forum don't work with the latest gdal. But I extracted some new ones from http://dl.maptools.org/dl/ms4w/ms4w_3.0.6.zip and they seem to work fine (I finally found a publicly accessible server that I could successfully test with!). So my question is simple - what would be the optimal way for QGIS to read this data (we're not interested in writing)? Can your server not provide WFS? If you could enable it easily on the server I would have thought that would be the easiest and most flexible option. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Accessing an Oracle database, natively or through ArcSDE
Hi List, I'm investigating QGIS as a possible suplement to our corporate systems (ArcGIS/MapInfo). We store all of our vector data in an Oracle Locator database and can either connect to it directly or through ArcSDE. Unfortunately it doesn't seem that QGIS is able to natively connect to either of these. I've done some brief searching, but most of the results point to qgis.orgwhich isn't responding for me currently. What I can find suggests that most things want to go either either OGR or GDAL as an intermediary layer, but I'm concerned these will greatly slow down data loading (some of our layers are very big, including Ordnance Survey MasterMap). So my question is simple - what would be the optimal way for QGIS to read this data (we're not interested in writing)? Thanks, Jonathan This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
