You can connect to a Dameng database from an ArcGIS client. To do so, install and configure the DM client on your ArcGIS client machines.
Once the client is configured, create a connection file. When connecting from ArcGIS Server, register the database connection file with your GIS Server.
Connect from ArcMap
To connect from ArcMap to Dameng, install a supported version of the 32-bit DM client on the ArcMap machine and create a connection file in the Catalog tree.
Install the DM client
Obtain the 32-bit DM client from Dameng and install it on the ArcMap machine. Follow instructions provided by Dameng to install the client.
Connect to the database
Add a database connection using the Database Connection dialog box or Create Database Connection tool. The following steps describe using the Database Connection dialog box.
- Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.
- Choose Dameng from the Database Platform drop-down list.
- In the Data source text box, type the name of the server where Dameng is installed.
- Choose Database authentication for the Authentication Type.
- Provide a valid user name and password in the User name and Password text boxes, respectively.
A file is created in \\<computer_name>\Users\<user_name>\AppData\Roaming\ESRI\Desktop<release#>\ArcCatalog.
You can move the connection to another location. Just be sure users and applications that need to make a connection have read access to the directory where you place the connection file.
If you use the data from this connection as the source for a service, such as a geoprocessing or geocoding service, you may need to place the connection file in a shared location on your network. See Preparing resources for publishing as services for more information about sharing a connection file.
Connect from ArcGIS for Server
If you will be publishing data from Dameng to ArcGIS Server and want the resultant services to use the data in your Dameng database, do the following:
- If ArcGIS Server is installed on a different machine than Dameng, install the DM client on the ArcGIS Server machine. If your ArcGIS Server site includes multiple machines, install the client on all ArcGIS Server machines.
- If ArcGIS for Server is installed on a Linux server, edit the init_user_param.sh script to include information about the DM client and restart ArcGIS for Server.
- Register your Dameng database with ArcGIS Server if you want your GIS services to use the data in your database.
Install the DM client
Obtain the 64-bit DM client installation from Dameng and install it on the machine where ArcGIS for Server is installed. Follow instructions provided by Dameng to install the client.
Alter the init_user_param.sh script (Linux only)
Once you have installed the database client files, alter the init_user_param.sh script to reference them. You can access this script by browsing to the <ArcGIS Server installation directory>/arcgis/server/usr directory.
On most Linux operating systems, you must also create a link from the libodbcinst.so library version on your machine to libodbcinst.so.
- Ensure that the ArcGIS Server installation owner has at least read and execute permissions on the database client libraries.
- Open the init_user_param.sh script in a text editor.
- Remove the comment marks (#) from the lines beginning with export and provide the path to your DM client installation.
# -------------------------------------------------- # Modify this section to configure a connection to Dameng. # # ---------------------------------------------------------------- #export DAMENGDIR=<Dameng_InstallDir> #export LD_LIBRARY_PATH=$DAMENGDIR/bin:$LD_LIBRARY_PATH
- Save and close the script.
- The DM client requires the libodbcinst.so library. If you have a different version of the library, you must create a soft link to reference libodbcinst.so.
In this example, a link is created between libodbcinst.so.2.0.0 and libodbcinst.so.
ln -s libodbcinst.so /usr/lib64/libodbcinst.so.2.0.0
- Restart each GIS server in your ArcGIS Server deployment by running the startserver.sh script.
./startserver.sh
Register the database
If you want your GIS web services to use the data in your Dameng database, register the database with ArcGIS Server. You can do this from ArcMap or ArcGIS Server Manager.