Summary of ArcSDE spatial database connection

Summary of ArcSDE spatial database connection

1. Use the ArcSDE service to connect to a spatial database
To connect to a spatial database using the ArcSDE service, follow these steps:
1) in the directory tree of arccatalog, expand the database Connections folder.
2) double-click Add spatial database connection to open the "Spatial Database Connection Properties" dialog box.
3) in the server text box, enter the server name or IP address;
4) in the service text box, enter the service name or port number. If you want to connect to the spatial database of a user solution in the Oracle database, enter the port number and schema, and separate them with colons, for example, 5151: geodata.
5) if the data is stored in SQL Server, IBM DB2, Informix, or PostgreSQL relational databases, enter the name of the pre-connected database in the database text box. Skip this step for Oracle databases.
6) If you use database authentication, enter the user name and password of the database. You need to save the user and password, and check "Save the user name and password with this connection file". Otherwise, do not save the password.
7) if operating system authentication is used, click "operating system authentication. Database authentication is not available.
8) if you are using an oracle user's schema database or using the DBO-schema database in SQL Server, you must change the "connection details" section in the attribute dialog box, select the database version from the transaction version list.
9) If you do not want to save the version connection information you provide in the last step, uncheck Save the version with the connection file. if you do not save the connection information of a version, remove the check box before "Save the version with the connection file.
10) Click "test connection" to test the connection. The test is successful. The "test connection" button is grayed out. Otherwise, data cannot be obtained from the database.
11) Click OK.
12) enter the database connection name.
13) Press enter.

 

2. direct connection to Oracle space database
The following describes three methods of direct connection to the Oracle space database: first, use database authentication to connect directly to the Oracle space database; second, use the operating system authentication to connect directly to the Oracle space database; third, how to connect to the spatial database of a user solution.
Use Database Authentication to directly connect to the Oracle space database
1) in the directory tree of arccatalog, expand the database Connections folder.
2) double-click Add spatial database connection.
3) enter the server name or IP address;
4) Service: Enter the connection string based on the Oracle client version. Connect Oracle9i, input: "SDE: oracle9i"; Connect to Oracle 10g, input: "SDE: Oracle10g"; Oracle 11g, input: "SDE: oracle11g ".
5) User name: Enter the user name.
6) password: enter the password and the Oracle network service name. Format: SDE @ oradb.
7) Click OK.
8) enter the database connection name.
9) Press enter.
Use operating system authentication to directly connect to the Oracle space database
1) double-click the database Connections folder in the catalog tree.
2) double-click Add spatial database connection.
3) in the server text box, type the name of the server on which the Oracle database resides.
4) if you're connecting to Oracle9i, In the service text box, type "SDE: oracle9i: //; Local = <SQL _net_alias> ".
If you're ing to Oracle 10g, type "SDE: Oracle10g:/; Local = <SQL _net_alias> ".
The SQL net alias was set when your computer was configured to use a direct connection. contact your system administrator if you do not know what value to substitute here.
5) Click the operating system authentication button. The database authentication information becomes unavailable.
6) Click OK.
7) type a new name for the spatial database connection.
8) Press enter.
Connect to the specified user's Spatial Database
1) double-click the database Connections folder in the catalog tree.
2) double-click Add spatial database connection.
3) in the server text box, type the name of the server on which the Oracle database resides.
4) if you're connecting to Oracle9i, In the service text box, type "SDE: oracle9i: //: <Schema_name> ".
If you're ing to Oracle 10g, type "SDE: Oracle10g:/: <Schema_name> ".
5) type your user name in the User Name text box.
6) type your password, followed by @ <Oracle network service Name>, In the Password text box.
7) uncheck save username and password if you don't want your login information saved with the connection.
8) spatial database connections are made to the SDE. Default version by default. You must change to a user-schema version. Click Change in the connection details section.
9) when the connection details dialog box opens, choose the version of the User-schema Geodatabase to which you want to connect. this cocould be <schema>. default or any other version of that Geodatabase. for example, if the schema the Geodatabase is in is tubor, and you want to connect to the qa77 version, choose tubor. qa77 from the transactional version list.
10) Click OK on the connection details dialog box to close it.
11) Click OK.
12) type a new name for the spatial database connection.
13) Press enter.
3. Direct Connection to the SQL server space database
You can use a direct connection for an ArcSDE Geodatabase stored in SQL Server. when reading the steps, note that there are slight differences in how you make that direct connection based on the type of ArcSDE Geodatabase.
1) double-click the database Connections folder in the catalog tree.
2) double-click Add spatial database connection.
3) in the server text box, type the name of the server on which the SQL Server database resides.
4) to connect to an ArcSDE Geodatabase on a default instance of SQL Server, type the following in the service text box: "SDE: sqlserver: <name or IP address of the server> ".
To connect to an ArcSDE Geodatabase on a named instance of SQL Server, type the following in the service text box: "SDE: sqlserver: <name or IP address of the server >\< instance_name> ".
If connecting to an ArcSDE Geodatabase on SQL Server Express, type the following in the service text box: "SDE: sqlserver: <SERVER_NAME >\< instance_name> ".
Note: You cocould also create a spatial database connection to an ArcSDE Geodatabase on SQL Server express by right-clicking the Geodatabase under the database servers node and clicking.
5) type the name of the database to which you want to connect in the database text box.
6) if using database authentication, type your user name and password.
Note: you cannot use Database Authentication for a connection to an ArcSDE Geodatabase on a database server (an instance of SQL Server express ).
7) uncheck save username and password if you do not want your login information saved with the connection.
8) If using operating system authentication, click the operating system authentication button. The database authentication information becomes unavailable.
9) If you are connecting to an ArcSDE Geodatabase with a DBO schema, you must change the transactional version to DBO. Default rather than SDE. default.
For instructions on connecting to a different version of the database, see connecting to a specific version of the database.
10) Click OK.
11) type a new name for the spatial database connection.
12) Press enter.

 

Reference: http://www.gisall.com /? Uid-9941-action-viewspace-itemid-988