Skip to main content

Connect to Dameng from ArcGIS

The following list summarizes the steps required to connect from ArcGIS to a Dameng database:

Install the DM client

A DM client is needed on all ArcGIS client machines that will connect to Dameng.

Contact Dameng to obtain the DM client. Follow the instructions provided by Dameng to install the DM client. If you do not have the privileges to install software on the machines where ArcGIS clients are running, you'll need to have your IT department install the DM client for you.

When you configure the DM client on ArcGIS Server Linux machines and the operating system contains a version of the libodbcinst.so library, create a soft link to libodbcinst.so. In the following example, a link is made to libodbcinst.so from libodbcinst.so.2.0.0:

ln -s libodbcinst.so /usr/lib64/libodbcinst.so.2.0.0

If you do not have the privileges to install software on the machines where ArcGIS clients are running, you'll need to have your IT department install and configure the DM client for you.

Alter the init_user_param. sh script

After you install the database client files, alter the init_user_param.sh script installed with ArcGIS Server to reference the client files. You can access this script by browsing to the <ArcGIS Server installation directory>/arcgis/server/usr directory.

You must update the init_user_param.sh on every machine in the ArcGIS Server site.

On most Linux operating systems, you must also create a link from the libodbcinst.so library version on your machine to libodbcinst.so.

  1. Ensure that the ArcGIS Server installation owner on each machine has at least read and execute permissions on the database client libraries.

  2. Open the init_user_param.sh script in a text editor.

  3. Remove the comment marks (#) from the lines beginning with export and replace <Dameng_InstallDir> with 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

  1. Save and close the script.

    The DM client requires the libodbcinst.so library.

  2. If you have a different version of the library, create a soft link to reference libodbcinst.so.

    In this example, a link is created between libodbcinst.so.2.0.0 and libodbcinst.so.

     In -S libodbcinst.so
 /usr/lib64/libodbcinst.so.2.0.0

  3. For the changes you made in the 'init_user_param.sh' file to take effect, you must restart ArcGIS Server.

    To do this, run the stopserver. sh script, then run the startserver. sh script on each machine in the ArcGIS Server site.

    ./stopserver.sh

    ./startserver.sh

Create a database connection

You must have a database connection (.sde file) that authenticates the connection to the database. To use the database connection file with ArcGIS Server, you must save user information with the connection file.

You can call the ArcPy CreateDatabaseConnection function from one of the machines in the ArcGIS Server site that needs to connect to the database. See Create Database Connection in the ArcGIS Pro help for information about running this function.

Tip:

Ensure the account used for the connection has the appropriate privileges in the database and on the data that the account needs to access. See Privileges for using ArcGIS with Dameng in the ArcGIS Pro help for more information.

Register with ArcGIS Server

For web services to access the data in the Dameng database, you must register the database with your ArcGIS Server sites.

You can use the database connection file you created to register the database with ArcGIS Server from the Manage registered data stores pane in ArcGIS Pro or from ArcGIS Server Manager.