Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms


arcgis-egdb (3) Versions 1.0.2

Creates enterprise geodatabases in SQL Server or PostgreSQL DBMS and registers them with ArcGIS Server.

cookbook 'arcgis-egdb', '~> 1.0.2'
cookbook 'arcgis-egdb', '~> 1.0.2', :supermarket
knife supermarket install arcgis-egdb
knife supermarket download arcgis-egdb
Quality -%


arcgis-egdb cookbook creates enterprise geodatabases in SQL Server or PostgreSQL DBMS and registers them with ArcGIS Server.


  • Windows 8 (8.1)
  • Windows 10
  • Windows Server 2008 (R2)
  • Windows Server 2012 (R2)
  • Windows Server 2016
  • Windows Server 2019
  • Ubuntu 14.04, 16.04, 18.04
  • RHEL 6.5, 7.0

Database Servers

The cookbook was tested with:

  • Amazon RDS for SQL Server
  • Amazon RDS for PostgerSQL
  • Amazon Aurora PostgerSQL-compatible


The following cookbooks are required:

  • arcgis-enterprise

The cookbook uses ArcPy to create and enable geodatabases. ArcPy is installed by ArcGIS Server setup.

ArcPy does not support creating databases in Amazon RDS database servers. The cookbook uses sqlcmd and pqsl utility for SQL Server and PostgreSQL database servers to create the databases. 'sqlcmd' and 'psql' recipes could be used to install these utilities. ArcGIS DataStore and Portal for ArcGIS include embedded PostgreSQl client with psql utility, that can be used by arcgis-egdb cookbook.


  • node['arcgis']['egdb']['engine'] = DB engine <nil|postgres|sqlserver-se>. Default DB engine is nil.
  • node['arcgis']['egdb']['endpoint'] = DB instance endpoint domain name. Default endpoint is nil.
  • node['arcgis']['egdb']['keycodes'] = Geodatabase license file path. Default path is node['arcgis']['server']['keycodes'].
  • node['arcgis']['egdb']['master_username'] = RDS DB instance master username. Default username is EsriRDSAdmin.
  • node['arcgis']['egdb']['master_password'] = RDS DB instance master user password. Default password is nil.
  • node['arcgis']['egdb']['db_username'] = Geodatabase username. Default username is sde.
  • node['arcgis']['egdb']['db_password'] = Geodatabase user password. Default password is node['arcgis']['egdb']['master_password'].
  • node['arcgis']['egdb']['postgresbin'] = Path to PostgreSQL client bin directory. Default path s C:\Program Files\ArcGIS\DataStore\framework\runtime\pgsql\bin on Windows and /arcgis/datastore/framework/runtime/pgsql/bin on Linux.
  • node['arcgis']['egdb']['sqlcmdbin'] = Path to Miscrosoft SQL Server Client SDK ODBC Tools 17 Binn directory. Default path s C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn on Windows.
  • node['arcgis']['egdb']['connection_files_dir'] = Directory path for geodatabase connection files created by the recipes. Default directory is node['arcgis']['misc']['scripts_dir']/connection_files.
  • node['arcgis']['egdb']['data_items'] = Array with properties of geodatabases. Default value is
    "database" : "egdb",
    "data_item_path" : "/enterpriseDatabases/registeredDatabase",
    "connection_file": "C:\\chef\\misc_scripts\\connection_files\\RDS_egdb.sde",
    "is_managed" : true,
    "connection_type" : "shared"



Creates EGDBs and registers them with ArcGIS Server.


Creates EGDBHOST alias for SQL Server endpoint domain.


Creates EGDBs in PostgreSQL.


Creates EGDBs in SQL Server.


Registers EGDBs with ArcGIS Server.


Installs Microsoft SQL Server ODBC drivers and command line utilities used by SQL Server EGDB configuration scripts.


  "arcgis": {
    "version": "10.7",
    "server": {
      "private_url": "",
      "admin_username": "admin",
      "admin_password": "changeit"
    "python": {
      "runtime_environment": "C:\\Python27\\ArcGISx6410.7"
    "misc": {
      "scripts_dir": "C:\\chef\\misc_scripts"
    "egdb": {
      "engine": "postgres",
      "endpoint": "",
      "keycodes": "C:\\Program Files\\ESRI\\License10.7\\sysgen\\keycodes",
      "master_username": "EsriRDSAdmin",
      "master_password": "changeit",
      "db_username": "sde",
      "db_password": "changeit",
      "connection_files_dir": "C:\\chef\\misc_scripts\\connection_files",
      "data_items": [{
        "database": "egdb",
        "data_item_path": "/enterpriseDatabases/registeredDatabase",
        "connection_file": "C:\\chef\\msic_scripts\\connection_files\\RDS_egdb.sde",
        "is_managed": true,
        "connection_type": "shared"
  "run_list": [

See wiki pages for more information about using ArcGIS cookbooks.


Find a bug or want to request a new feature? Please let us know by submitting an issue.


Esri welcomes contributions from anyone and everyone. Please see our guidelines for contributing.


Copyright 2021 Esri

Licensed under the Apache License, Version 2.0 (the "License"); You may not use this file except in compliance with the License. You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

A copy of the license is available in the repository's License.txt file.

[](Esri Tags: ArcGIS GeoDatabase Server Chef Cookbook) [](Esri Language: Ruby)

Dependent cookbooks

arcgis-enterprise ~> 3.7

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

arcgis-egdb cookbook CHANGELOG

This file is used to list changes made in each version of the arcgis-egdb cookbook.


  • Use SQL Server RDS endpoint instead of EGDBHOST alias.


  • Updated and locked versions of dependent cookbooks.


  • Initial release of the cookbook.

No quality metric results found