Skip To Content

Add databases to an ArcGIS Server site on Microsoft Azure

To store service data, you can add a Microsoft Azure SQL Database, Microsoft Azure Database for PostgreSQL (new at 10.6.1), or a SQL Server database on Microsoft Azure to your stand-alone or federated ArcGIS Server sites on Microsoft Azure using ArcGIS Enterprise Cloud Builder for Microsoft Azure. The database can serve one of the following roles:

  • A managed database—Managed databases store feature service data. When you publish, the data from your data source is copied to the managed database and the feature service reads the data from it. When you delete the feature service, the data is deleted. Managed databases provide a way for you to copy data to Azure so that it is running in the same region as your ArcGIS Server site. An ArcGIS Server site can have only one managed database.
  • A registered database—You can register a database to store simple source data on Azure. Use data loading methods recommended by Microsoft Azure to load existing on-premises data to the registered database. You can connect to the database from an ArcGIS Desktop client running in the same region on Azure to publish services that reference this data.
  • A registered database that contains a geodatabase—You can add an enterprise geodatabase to store source data on Azure. Use data loading methods recommended by Microsoft Azure to load existing on-premises data to the geodatabase that you've registered with your ArcGIS Server site. If you want to create new datasets in the geodatabase, connect to it from an ArcGIS Desktop client running in the same region on Azure. Once the geodatabase contains data, you can connect to it from an ArcGIS Desktop client running in the same region on Azure and publish services that reference this data.

Lizenz:

Registered databases that use geodatabase functionality and managed databases on Microsoft Azure are only supported with enterprise level licenses.

Create and register a database

  1. Start ArcGIS Enterprise Cloud Builder for Microsoft Azure.
  2. Sign in to Microsoft Azure.

    If you want to use the Microsoft Azure Government cloud and have an Azure Government subscription, check U.S. Government Cloud.

  3. Choose the Azure subscription that contains the ArcGIS Server site to which you want to add a registered database and click next.
  4. In the Deployments list, open the details for the ArcGIS Server site with which you want to register a database by clicking the down arrow next to the site name.
  5. Click the Register a database with the site button Register a database with the site.
  6. Specify the type of database to use: Microsoft Azure SQL Database, Microsoft Azure Database for PostgreSQL, or Microsoft SQL Server.
  7. Choose what to register:
    • To register a managed database, check both the As a Managed Database and Enable As Geodatabase check boxes. Only one managed database is allowed per ArcGIS Server site.
    • To register an enterprise geodatabase to use as a data source, uncheck the As a Managed Database check box, and check the Enable As Geodatabase check box.
    • To register a database to use as a data source, uncheck both the As a Managed Database and Enable As Geodatabase check boxes.
  8. Click next.
  9. If you chose Microsoft Azure SQL Database, provide the following information to create the database server and database:
    1. Click the Create button (+) next to Database Server.
    2. Type a name for the server.
    3. Type the user name and password for the database server administrator.
    4. Click create.
    5. Click the Create button (+) next to Database and type a name for the database.
    6. Click Check Availability to confirm the database name is unique.
    7. Choose a performance level from the Type drop-down menu.
    8. Click create.
  10. If you chose Microsoft Azure Database for PostgreSQL, provide the following information to create the database server and database:
    1. Click the Create button (+) next to Database Server.
    2. Type a name for the server.
    3. Choose an instance type for the database server.
    4. Choose the version of Microsoft Azure Database for PostgreSQL to use.
    5. Specify a storage size for the database server. You can either type a number or use the up or down arrows to change the size from the default.
    6. Type the user name and password for the database server administrator.
    7. Click create.
    8. Click the Create button (+) next to Database and type a name for the database.
    9. Click Check Availability to confirm the database name is unique.
    10. Click create.
  11. If you chose Microsoft SQL Server, provide the following information to create the database server and database:
    1. In the Database Server field, type a name for the virtual machine.
    2. Click Machine Options next to Database Server.
    3. Choose an instance type from the Image drop-down menu.
    4. To change specifications for the database server size, click the Configure Virtual Machine button Configure Virtual Machine.
    5. Choose to use a hard disk drive (HDD) or solid state drive (SSD) for the operating system disk (OS Disk Type).
    6. From the Machine Type drop-down menu, choose the type of virtual machine to use.
    7. Choose the size, in gibibytes, of the operating system disk.
    8. To add another drive to the virtual machine to store data, check Add a data disk? and choose the disk type and size for the data drive.
    9. Click apply to close the Configure Virtual Machine dialog box.
    10. Click apply to close the Database Server Machine Options dialog box.
    11. Type a name for the database.
  12. In the Site Administrator section, type the user name and password for the ArcGIS Server primary site administrator account for your ArcGIS Server site.
  13. Type the user name and password to be used for the database administrator in the Database Administrator section. If you are creating a geodatabase, this same password will be used for the geodatabase administrator (sde) account.
  14. Type the user name and password to be used for a data owner in the Database User section. This is the account that services will use to authenticate with the database to access the data.
  15. Click next to proceed to Deployment Options.
  16. Choose or create a storage account for your deployment. To create a storage account, follow these steps:
    1. Type a name for the storage account. Names must be unique. Click Check Availability to confirm the storage account name is unique.
    2. Choose the Azure region where your storage will reside.
    3. Choose an existing resource group or create a new one.
    4. Choose the type of redundancy for your storage account: Geo-Redundant, Locally Redundant, or Read-Access Geo-Redundant.

      See Azure Storage replication in Microsoft Azure documentation for a description of each redundancy option.

    5. Once the storage account is created, click close.
  17. Click next to view a summary of your settings.
  18. Review the settings in the Summary pane. If anything needs to be changed, click back to go to the page where you need to change the information.

    Tipp:

    Click save summary to save your site configuration information to a text file so you can refer to it for information such as user names or machine names.

  19. Click save automation artifacts to export an archive (.zip) file containing information and files you can use in automation scripts to re-create this deployment.
    1. Browse to a location on the local disk where the archive file will be created and type a name for the file.
    2. Choose the type automation format you will use.
    3. Click generate to create the file.
  20. When all settings are correct and you have saved the files you need, click finish to register your database.

Use an existing database

If you have an existing Azure SQL Database, Azure Database for PostgreSQL, or SQL Server instance in the Azure portal you want to register with your ArcGIS Server site, provide the name of the existing Database Server, Database, and Database Administrator user name and password when you register it using Cloud Builder.

To register an existing SQL Server instance on Azure, do the following to allow communication with the instance: