[Qgis-user] Accessing an Oracle database, natively or through ArcSDE

[Andreas Neumann]

 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 at 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:jonathanmoules at warwickshire.gov.uk
> [2] mailto:qgis-user at lists.osgeo.org
> [3] mailto:UJwkt9fsOj2_rsTg2XWkbjg at mail.gmail.com
> [4] http://dl.maptools.org/dl/ms4w/ms4w_3.0.6.zip
> [5] mailto:Alister.Hood at synergine.com

-- 
 --
 Andreas Neumann
 Böschacherstrasse 10A
 8624 Grüt (Gossau ZH)
 Switzerland