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?

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.

1

http://docs.qgis.org/2.8/de/docs/user_manual/working_with_vector/supported_data.html#oracle-spatial-layers actual QGIS documentation, well I have to write some more characters.....

  • Can you please expand on your link and explain why it is an answer? Add some quotes? Unfortunately, links are easily broken or outdated and if someone searches for an answer to this question next month there is no guarantee that the link will work. gis.stackexchange.com/help/how-to-answer – MaryBeth Jan 27 '16 at 14:14
  • The important bits of this answer are: Name: A name for this connection. It can be the same as Database Database: SID or SERVICE_NAME of the Oracle instance. Host: Name of the database host. This must be a resolvable host name such as would be used to open a telnet connection or ping the host. If the database is on the same computer as QGIS, simply enter ‘localhost’ here. Port: Port number the Oracle database server listens on. The default port is 1521. Username: Username used to login to the database. Password: Password used with Username to connect to the database. – chrismarx Jan 5 '17 at 15:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.