I’d like to highlight the following changes at ArcGIS 10.3 for Geodatabases:
ArcSDE application server and Connections
The ArcSDE application server is no longer available with ArcGIS for Server. New connections to 10.3 and later release enterprise geodatabases are made through database management system clients installed on the ArcGIS client machines. If you upgrade your geodatabase to 10.3, you will need to update the existing connections used by your maps and web services to connect through the database management system clients. You can still use an ArcSDE service to connect from ArcGIS 10.3 clients to 10.2.2, 10.2.1, 10.2, and 10.1 enterprise geodatabases.
Default number of Connections
In previous releases of the enterprise geodatabase, the default number of connections allowed was 64. This limit helped prevent overloading the server when all or most connections to the geodatabase were made through an application server running on the same server as the geodatabase. Beginning with 10.3, there is no limitation imposed on the number of connections to new 10.3 geodatabases or geodatabases upgraded to the 10.3 release. You will find this number set to 999999 in the SDE_server_config table.
ArcSDE administration command line utilities
ArcSDE administration command line utilities are no longer available with ArcGIS for Server. Instead, use the tools in the Geodatabase Administration toolset of the Data Management geoprocessing toolbox and the geodatabase administration items available from the database connection in ArcMap.
New tools in Data Management Toolbox
The following Nine tools have been added to the Geodatabase Administration toolset to help you manage your enterprise geodatabases. They replace functionality previously performed using ArcSDE administration command line utilities.
- Configure Geodatabase Logfile Tables
- Create Raster Type
- Delete Schema Geodatabase
- Diagnose Version Metadata
- Diagnose Version Tables
- Export Geodatabase Configuration Keyword
- Import Geodatabase Configuration Keyword
- Repair Version Metadata
- Repair Version Tables
ArcGIS now supports the 1.0 OGC GeoPackage format. When you create SQLite databases using the CreateSQLiteDatabase ArcPy function, you now have the option to use the GeoPackage format. You can also add GeoPackage tables to an existing SQLite database and connect to GeoPackages you create outside of ArcGIS.
You can connect from ArcGIS for Desktop to view subsets of data from ALTIBASE and SAP HANA databases. You can use the data in your maps and perform analysis on the data.
You can view features with z-coordinates stored in Teradata 15.0 from ArcGIS 10.3.
Enterprise geodatabases in DB2 now use a DB2 function—MON_GET_CONNECTION—to clean up connections. Grant execute privileges on this function to your geodatabase users rather than grant SYSMON authority them. Additionally, the sde user no longer requires SYSMON authority to create or upgrade a geodatabase in DB2. See Privileges for geodatabases in DB2 for more information.
The Generate Licensed File Geodatabase and Generate File Geodatabase License tools have been added to the File Geodatabase toolset. Use these tools together to apply export and time restrictions to the file geodatabase data you send to clients or other agencies.
ArcGIS Data Store
ArcGIS Data Store is a new component available with ArcGIS 10.3 for Server, which allows you to easily set up a highly available enterprise geodatabase to store data for the hosted feature layers you publish to Portal for ArcGIS. See What’s new in Portal for ArcGIS 10.3 for more information.