Enable Enterprise Geodatabase (Data Management)
Summary
The Enable Enterprise Geodatabase tool creates geodatabase system tables, stored procedures, functions, and types in an existing enterprise database, thereby enabling geodatabase functionality in the database.
Usage
- You must have ArcGIS for Desktop (Standard or Advanced), ArcGIS Engine Runtime, or ArcGIS for Server Standard or Advanced installed on the computer from which you will connect to the database and enable geodatabase functionality (create a geodatabase in the database). You must be able to connect directly to the database. This may require you to install and configure a database management system (DBMS) client on the computer where the ArcGIS client is installed.
If you are connecting to an IBM DB2, Informix, Oracle, or PostgreSQL database, you must connect as a user named sde. If you connect to a Microsoft SQL Server database, you can connect as a user named sde or as a user who is dbo in the SQL Server instance. Note that the SQL Server instance to which you connect must use a case-insensitive collation. See the topic appropriate to your database for information on required privileges to create a geodatabase:
Syntax
| Parameter | Explanation | Data Type |
input_database |
Provide the path and connection file name for the database in which geodatabase functionality is to be enabled. The connection must be made as a geodatabase administrator. | Workspace |
authorization_file |
Provide the path and file name of the keycodes file that was created when you authorized ArcGIS for Server Enterprise. This file is in the \\Program Files\ESRI\License<release#>\sysgen folder on Windows and /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release#>/sysgen directory on Linux. If you have not already done so, authorize ArcGIS for Server to create this file. | File |
Code Sample
This script uses an existing database connection file (my_db_connection.sde) located in the default ArcGIS for Desktop database connection location to enable geodatabase functionality with a keycodes file on a remote server.
##Import Arcpy module
import arcpy
arcpy.EnableEnterpriseGeodatabase_management("Database Connections\my_db_connection.sde", "//myagsserver/Program Files/ESRI/License10.1/sysgen/keycodes")
This script uses an existing database connection file (database1.sde) in a user-defined location to enable geodatabase functionality with a keycodes file in a user-defined location on the local computer.
##Import Arcpy module
import arcpy
arcpy.EnableEnterpriseGeodatabase_management("C:\myconnections\database1.sde", "C:\authfiles\keycodes")