Register Relational Data Store Type
- Required Capability:Administrator
- Version Introduced:10.5
Registers a new relational data store type with the server. Once registered, a relational data store type enables Insights users to create Relational Database Connection portal items to browse and query data from relational databases.
This operation should only be called on an ArcGIS Server site that has been designated as a Portal for ArcGIS hosting server. In order to register a relational data store type, you must obtain the correct Java Database Connectivity (JDBC) driver from your database vendor. These drivers are typically delivered as one or more Java Archive (.jar) files, which you must compress/package into a ZIP file. The name of the ZIP file does not matter, except that the file extension must be .zip. Before calling this Register operation, you must first upload the ZIP file to your server. Be sure to make note of the Item ID property of the newly created upload item. Repeat the upload step for each database platform your organization supports.
Zip file contents
Microsoft SQL Server
SAP HANA 1.0 SPS11* or SPS 12
tdgssconfig.jar and terajdbc4.jar
Teradata 14.10, 15.0 or 15.10
*For spatially-enabled databases, SPS11 Revision 2 (1.00.112) or better is required to avoid 'Unregistered function name: "__cs_field_Geometry__" ' errors during certain workflows (BUG-000101435).
Call this register operation once for each upload item you created (i.e. once for each database driver ZIP file you uploaded).
Once all relational data store types have been registered, you must completely re-start ArcGIS Server on each machine in your site. To do this, you need to re-start the Windows Service or use the stopserver/startserver scripts on Linux.
Once all relational data store types have been registered, do not delete the upload items created for the zipped database drivers. They might be needed at a later date.
Identifier of uploaded ZIP file containing JDBC driver file(s).
Identifier of the relational data store type you are registering.
The response format. The default response format is html.
Values: html | json
http://server.myserver.com:port/arcgis/admin/data/relationalDatastoreTypes/register uploadedItemId= <upload id> typeId= <type_id>
http://server.myserver.com:port/arcgis/admin/data/relationalDatastoreTypes/register uploadedItemId:ic600379e-be10-4fd2-ab7e-76d37989d3bf typeId:esri.hana