Skip To Content
ArcGIS Developers
Dashboard

Edit Relational Data Store Type

Description

Legacy:

The use of all relational data store operations in the ArcGIS Server Admin API has been deprecated as of ArcGIS Enterprise 10.9. Starting at Insights 2021.1, the registration and management of relational data store types should be performed with ArcGIS Insights. For more information, see Manage connector types.

This operation allows you to edit a registered relational data store type to update its properties. Before proceeding with any edit, it is recommended that you make a backup copy of the relational data store type's JSON properties.

Request parameters

ParameterDetails
properties

The JSON object representing the relational data store type.

f

The response format. The default response format is html.

Values: html | json | pjson

Example usage

Below is a sample POST request for edit, formatted for readability:

POST /webadaptor/admin/data/relationalDatastoreTypes/esri.hana/edit HTTP/1.1
Host: machine.domain.com
Content-Type: application/x-www-form-urlencoded
Content-Length: []

properties={
  "name": "SAP HANA",
  "id": "esri.hana",
  "adminDefinedProperties": {
    "jdbcPoolProperties": {
      "factory": "org.apache.tomcat.jdbc.pool.DataSourceFactory",
      "driverClassName": "com.sap.db.jdbc.Driver",
      "url": "jdbc:sap://",
      "initialSize": 0,
      "minIdle": 0,
      "timeBetweenEvictionRunsMillis": 10000,
      "minEvictableIdleTimeMillis": 20000,
      "testOnBorrow": true,
      "validationQuery": "SELECT 1 FROM DUMMY"
    },
    "excludeSchemas": [
       "SYS","_SYS_REPO",
       "_SYS_TASK","SYS_XS_UAA"
    ]
  },
  "userDefinedProperties": [
    {
      "name": "username",
      "alias": "User Name",
      "defaultValue": "",
      "type": "string",
      "required": true
    },
    {
      "name": "password",
      "alias": "Password",
      "defaultValue": "",
      "type": "string",
      "required": true
    },
    {
      "name": "serverName",
      "alias": "Server Name",
      "defaultValue": "",
      "type": "string",
      "required":true
    },
    {
      "name": "databaseName",
      "alias": "Database Name",
      "defaultValue": "",
      "type": "string",
      "required": false
    },
    {
      "name": "portNumber",
      "alias": "Port Number",
      "defaultValue": "",
      "type": "int",
      "required": true
    }
  ],
  "dialectClass": "com.esri.ads2.dialect.impl.hana.SAPHANASupportImpl",
  "dialectFactoryClass": "com.esri.ads2.factory.PooledDataSourceDialectFactory"
}&f=json

JSON Response example

{"status": "success"}