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.
The Direct Connection section is a Flare snippet. It's used in SDE30 and Geodatabase formats. Changes to one will show up in both formats.
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 or sde:oracleversion (For example, sde:oracle12c ensures that the proper driver is used.) |
|
|
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) (<oracle_client> is your local client, like Oracle12c) |
|
|
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.
End snippet.