This will pop up another window which gives you an information of your successful connection, as shown below. G.) Password : Enter corresponding password of username Connect QGIS to oracle spatial This will return the 32 bit address as shown below in figure: Connect QGIS to oracle spatialĭ.) Database : Write database name, i.e the name you have given while installing oracle software. Type : Oracle Spatial Connect QGIS to oracle spatialī.) Name : Type in any desired name you wish to give to connectionĬ.) Host : For finding your host name, make a query in your oracle sql plus application as written below: SELECT UTL_INADDR.GET_HOST_ADDRESS FROM DUAL Here is the way to fill up the information :Ī.) Type : In type select oracle spatial from drop down box. Connect QGIS to oracle spatialĤ.) In the same Add Vector Layer window, select new button under connection label. This will open up a simple form with following Connection information to be filled, i.e, Type, Name, Host, Database, Port, Username and Password. Now in Database Type drop down box, select Oracle Spatial. If you have properly installed QGIS with the requirement stated above Oracle spatial would be present.
If oracle library is not installed, see the following post : Install QGIS for oracle connection via OSGeo4w.Ģ.) After starting the QGIS application, select Add Vector Layer as shown below: Connect QGIS to oracle spatialģ.) A new window will pop up on clicking the above, now select Database Radio button as appeared in Source. How to connect QGIS to oracle spatial :ġ.) Firstly you should have downloaded QGIS with GDAL/OGR required oracle library for bridging oracle connectivity and must have installed oracle on your machine. As a newbie to QGIS user, i can just give a way, that i connected to it. QGIS can now connects to oracle to view spatial data and process it, great news for an open source software believers.