Enterprise geodatabases are collections of tables, views, and stored procedures inside a database management system. SAP HANA database management systems can be enabled to store a geodatabase. You can enable a geodatabase in an SAP HANA database and continue to store your database data alongside geodatabase data. You can view and publish both types of data in ArcGIS Pro.
How do I create a geodatabase in SAP HANA?
Since geodatabases are a collection of objects inside a database, you (or someone in your organization) needs to be an SAP HANA database administrator and must configure the database and a database user named sde using tools provided by SAP HANA.
Once the database administrator creates the database and sde user needed for the geodatabase, the geodatabase administrator uses the Enable Enterprise Geodatabase tool in ArcGIS Pro to create a geodatabase.
What functionality is available?
The following functionality is available for geodatabases in SAP HANA:
- Tables, feature classes, and feature datasets
- The ability to register tables, feature classes, and database views with the geodatabase
- Relationship classes
- Subtypes and domains
- Editor tracking
- Nonversioned archiving
- Branch versioning for long transaction editing through feature services
- Utility networks
- Mosaic datasets and raster datasets
- Multipatch data
- Network datasets (read only)
- The ability to publish web layers
- Topologies (requires branch versioned data published in a web feature layer)
- Offline editing of web feature layers
Functionality not currently available
The following functionality is not available in geodatabases in SAP HANA:
- Editable network datasets
- Parcel fabrics
How do I manage a geodatabase in SAP HANA?
The SAP HANA database administrator maintains the database using tools provided by SAP HANA.
The database administrator can use tools in SAP HANA to create database users and grant them the privileges they require. To create standard users, the database administrator has the option to use the Create Database User tool in ArcGIS Pro.
Differences exist in how data is stored and accessed in the database management systems supported by ArcGIS, which affect how you interact with the database and geodatabase objects in it. For this reason, topics on geodatabase management are grouped into sections based on database management system. This section provides information on managing a geodatabase in SAP HANA. If you access a topic by way of a search, be sure you are reading the topic that applies to the correct database management system.
Considerations when using a geodatabase in SAP HANA
Keep in mind the following when using a geodatabase in SAP HANA:
- Once you enable a geodatabase in SAP HANA, you can only connect from ArcGIS Pro. You can share data from ArcGIS Pro to federated ArcGIS Server sites.
- You can edit geodatabase data from ArcGIS Pro when accessed via the database connection. Since versioned data in SAP HANA geodatabases uses branch versioning, you must share data using a feature service and access it as web feature layers for editing workflows.
- Geodatabases in SAP HANA can contain a mixture of datasets that are registered with the geodatabase and database tables that are not registered with the geodatabase. Unregistered database tables are accessed as read-only datasets in ArcGIS Pro when using a database connection. These tables can be published to an editable feature service and consumed as web feature layers to perform edits.
- If your database contains geodatabase system tables, ArcGIS considers it a geodatabase. Therefore, even if you access tables that are not registered with the geodatabase, ArcGIS client and geodatabase release compatibility rules still apply.