The parameters needed to make a direct connection to an ArcSDE database depend on the underlying database and any client software required by that database.
Additional information is available in an FME Knowledge Center article.
For a compatibility chart, see the Esri Direct-connect documentation for your DBMS.
|
Underlying |
Mandatory |
Value |
|
Oracle (option 1) |
DATASET |
Any value can be specified as the value does not get used; however, a value must be supplied. |
| SERVER | Any value can be specified: the value does not get used but it must be supplied. | |
|
|
INSTANCE |
sde:oracle |
|
|
USERID |
<username> |
|
|
PASSWORD |
<password>@<Oracle Net Service Name> |
|
Oracle (option 2) |
DATASET |
Any value can be specified as the value does not get used; however, a value must be supplied. |
| SERVER | Any value can be specified: the value does not get used but it must be supplied. | |
|
|
INSTANCE |
sde:oracle:/;local=<sqlnetalias> (for ArcGIS 9) sde:<oracle client>:<sqlnetalias> (for ArcGIS 10) where <oracle_client> is your local client (e.g., Oracle11g or oracle) |
|
|
USERID |
<username> |
|
|
PASSWORD |
<password> |
|
Microsoft SQL Server |
DATASET |
<database_name> |
| SERVER | Any value can be specified: the value does not get used but it must be supplied. | |
|
|
INSTANCE |
sde:sqlserver:<SQL Server Instance Name> or sde:sqlserver:<SQL Server Instance Name>\<Named Instance> (for connecting to a named instance) |
|
|
USERID |
<username> |
|
|
PASSWORD |
<password> |
|
DB2 (option 1) |
DATASET |
<db alias name specified through DB2 Configuration Assistant> |
|
|
SERVER |
remote (if client application is remote, otherwise do not specify) |
|
|
INSTANCE |
sde:db2 |
|
|
USERID |
<username> |
|
|
PASSWORD |
<password> |
|
DB2 (option 2) |
DATASET |
Any value can be specified: the value does not get used but it must be supplied. |
|
|
SERVER |
remote (if client application is remote, otherwise do not specify) |
|
|
INSTANCE |
sde:db2:<db alias name specified through DB2 Configuration Assistant> |
|
|
USERID |
<username> |
|
|
PASSWORD |
<password> |
|
Informix |
DATASET |
Any value can be specified: the value does not get used but it must be supplied. |
|
|
SERVER |
remote (if client application is remote, otherwise do not specify) |
|
|
INSTANCE |
sde:informix:<odbc data source name> |
|
|
USERID |
<username> |
|
|
PASSWORD |
<password> |
| PostgreSQL | DATASET | Any value can be specified: the value does not get used but it must be supplied. |
|
|
SERVER |
Any value can be specified: the value does not get used but it must be supplied. |
|
|
INSTANCE |
sde:postgresql:<postgresql server host name>,<port number> |
|
|
USERID |
<username> |
|
|
PASSWORD |
<password> |
The directive VERSION_NAME can also be used to specify the version when making a direct connection.
Please refer to the ArcGIS Direct-connect documentation for your DBMS for more information on setting up the direct connect environment and tips on proper usage. The ArcGIS Resource Center also contains additional information.