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: [email protected] [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:[email protected]
[2] mailto:[email protected]
[3] mailto:[email protected]
[4] http://dl.maptools.org/dl/ms4w/ms4w_3.0.6.zip
[5] mailto:[email protected]

--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to