Edit Relational Data Store Type

Description

Edit a registered relational data store type to update its properties. Before proceeding with any edit, make a backup copy of the type’s JSON.

NoteNote:

The JSON is submitted to the Edit operation URL as a value for a parameter named type.

Request Parameters

Parameter

Details

type

The JSON object representing the relational data store type.

f

The response format. The default response format is html.

Values: html | json

Example Usage

http://services.myserver.com:port/arcgis/admin/data/relationalDatastoreTypes/esri.hana/edit
  type= {
  "name":"SAP HANA",
  "id":"esri.hana",
  "adminDefinedProperties":{  
    "jdbcPoolProperties":{  
      "urlSeparator":"/?",
      "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"
    },
    "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"
}

JSON Response Syntax

{
	"status": "success" | "error",
	"messages": ["message1", "message2"],
	"code": <errorcode>
}

JSON Response Example

{"status": "success"}

3/3/2017