Register databases with ArcGIS Server on Microsoft Azure
In this topic
If you want to place web service source data on Microsoft Azure, create a Microsoft Azure SQL Database or a SQL Server database on Microsoft Azure using the Azure portal, and register this database with your enterprise GIS server on Microsoft Azure using ArcGIS Server Cloud Builder for Microsoft Azure.
If you want to use geodatabase functionality in the registered database, choose to create a geodatabase when you register the database using ArcGIS Server Cloud Builder for Microsoft Azure.
Registered databases that use geodatabase functionality and managed databases on Microsoft Azure are only supported with ArcGIS for Server enterprise licenses.
Also note that geodatabase creation and use in Microsoft Azure SQL Databases is supported with ArcGIS 10.3.1 for Server if you use ArcGIS Server Cloud Builder for Microsoft Azure. These 10.3.1 geodatabases are in a beta state, and are for use only with your GIS server or web GIS deployment on Azure.
Create a database
Create the Azure SQL Database or SQL Server instance in the Azure portal. Create it in the same subscription and location as your GIS server or web GIS site on Microsoft Azure.
If you create a SQL Server instance, do the following to allow communication with the instance:
Register the database
- Start ArcGIS Server Cloud Builder for Microsoft Azure.
- 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 account.
- Choose which Azure subscription you want to manage and click next.
- Click manage my site.
- Choose the ArcGIS Server on Microsoft Azure site to which you want to add a registered database and click register a database.
- Specify which type of database to use: Microsoft Azure SQL Database or Microsoft SQL Server.
- Choose what to register: either a database to store simple source data to be used with a GIS server or web GIS deployment or a managed database for your GIS server's feature services.
Note that only one managed database is allowed per site.
- If you chose to register a database for source data (in other words, if you unchecked As a Managed Database) and you want geodatabase functionality in the registered database that stores your simple source data, check Enable As Geodatabase.
- Click next.
- Provide information for the database you are registering:
- Choose your existing Database server.
- Choose the existing database you want to register.
- Type the user name and password of the database server administrator.
- Type the user name and password of the database administrator.
- Type a user name and password for the database user you want to connect to the database for data loading. You can specify the name and password of an existing user or, if the user does not exist, ArcGIS Server Cloud Builder for Microsoft Azure creates the user for you. If you are registering a managed database, the user will own the data that gets
- Click next to register the database with ArcGIS Server.
Load data to the database
You can connect from your on-premises ArcGIS for Desktop client to the Azure SQL Database or SQL Server database on Azure to load data, or use data loading methods recommended by Microsoft Azure.
To connect to an Azure SQL Database from an on-premises ArcGIS for Desktop client, configure the firewall on the Azure SQL Database machine to allow your client machine to communicate with the database.
Versioned views are not currently supported in Azure SQL Database.
Another option to get data into the Azure SQL Database or SQL Server database on Azure is to register the database as the GIS server's managed database. When you publish feature services to the GIS server, the data is copied to the managed database and the feature services read the data from there.