ESRI ArcSDE is middleware software that ESRI software requires to inter-operate with Relational Database Management System (RDBMS) to store both spatial and non-spatial data. SDE is the proprietary binary format with which ArcSDE stores geometry data within databases. In accordance with normal ESRI operation; points, LineString and Polygon items are stored in separate tables.
SIS desktop software can connect to SDE data held on Oracle 8 and later databases.
User is : SDE
Password is : SDE
HOST is the TNS Oracle name, this can be found in the TnsNames.ora file and is the connection to the oracle server.
The TnsNames file can be found in the Network/Admin area, for example:
C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
And will look in the form:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORAC10G2_11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORAC10G2)
)
)
In the example above the HOST would be ORAC10G2_11
Note: The SDE Plug-in is a memory dataset. SIS will need to read all data in the table into memory before displaying the data. Be aware of this behaviour when working with large tables.
See full list of Dataset Formats
Send comments on this topic.
Click to return to www.cadcorp.com
© Copyright 2000-2017 Computer Aided Development Corporation Limited (Cadcorp).