5

Just testing out the new QGIS2 install here and trying to connect it to our huge SDE/Oracle spatial database. Im struggling with the connection parameters. Here is the connection properties to the databse from within ArcGIS10.1:

Instance = sde:oracle10g:g01l10g

I can't figure out how this maps across to the connection fields in the QGIS2 popup. Can anyone help me please?

PolyGeo ♦
65.5k29 gold badges115 silver badges349 bronze badges
asked Oct 4, 2013 at 13:58

1 Answer 1

3

You will by-pass SDE control and will get all of the oracle spatial tables.

enter image description here

Example: (DB/IP/Username has been changed)

Database:Name of the Master database you are connecting to:

Host:IP of database (must be unique)

Port: Oracle is on 1521 (default)

Username:username (must be a USER not DBA or superuser)

Password:password (you MUST have password - no blank passwords)

Recommend: To speed the QGIS2 table reading up:

For speed check Only look for users tables and only existing geometry tables

Can take 10 minutes on large databases to read all the available tables.

answered Oct 4, 2013 at 14:16

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.