Skip To Content

Create a data store

You can use the Data Store Configuration wizard to create relational, tile cache, and spatiotemporal big data stores and join them to a GIS Server site.

If you do not have access to a web browser, run the configuredatastore utility on the machine where you installed ArcGIS Data Store.

Considerations before creating a data store

Disk space and memory

You should consider the amount of disk space and memory needed on the machine where you will create a data store. For example, relational data stores can store data for thousands of hosted feature layers, which can take up several gigabytes of disk space. Tile cache data stores can also grow to be quite large after publishing several hosted scene layers. If you archive data that is continually coming in from a stream layer, the spatiotemporal big data store can fill up very quickly.

You also need to ensure that machines have plenty of memory available. For example, spatiotemporal big data stores consume approximately 40 percent of available memory on the machine when initially configured. Relational data stores also pre-allocate memory to ensure there is enough to process data. High volume traffic on hosted feature and scene layers can also consume a considerable amount of memory.

For these reasons, Esri recommends you configure your spatiotemporal big data store on machines separate from the relational and tile cache data stores and, whenever possible, configure the relational data store and tile cache data store on machines separate from one another. If you do configure more than one type of data store on the same machine, use robust machines with plenty of memory and disk space.

In all cases, monitor the data store logs for messages about disk space and memory. If your machine runs out of either resource, your data store will stop functioning.

See ArcGIS Data Store system requirements for information on the minimum disk space and memory needed to create each type of data store, and add to that the estimated size of the data you intend to store in each.

Multiple network interface controller cards

If you installed ArcGIS Data Store on a machine that contains more than one network interface controller (NIC) card, you must identify which IP address the data store should use for network communication. Before you create a data store on the multi-NIC machine, determine which IP address can be used by other machines on your network to communicate with the ArcGIS Data Store machine, open the ArcGIS Data Store hostidentifier.properties file, and add the IP address to the file.

  1. First, you must determine which IP address to use. Open a command prompt on different machines on the same network and ping the ArcGIS Data Store multi-NIC machine.
  2. Log in to the multi-NIC machine where ArcGIS Data Store is installed and open hostidentifier.properties in a text editor. Log in using the ArcGIS Data Store account.

    The file is installed in framework\etc of the ArcGIS Data Store installation directory. By default, that location is C:\Program Files\ArcGIS\DataStore\framework\etc.

  3. Remove the comment mark (#) from the hostidentifier property, and set the property to the IP address needed to communicate with the ArcGIS Data Store machine.

    In this example, the IP address used to communicate with the machine is 12.34.56.789.

    hostidentifier=12.34.56.789

  4. Save and close the hostidentifier.properties file.

The hosting server

An ArcGIS Enterprise deployment includes one GIS Server site to act as its hosting server. The hosting server must be configured with, at minimum, a relational data store created through ArcGIS Data Store. This relational data store holds the data used by hosted feature layers created when you add files such as CSV, zipped shapefiles, Microsoft Excel files, or zipped file geodatabases to your portal and publish. It also allows portal users to drag CSV files directly to Map Viewer.

If the GIS Server site you intend to use as the hosting server already has an enterprise geodatabase registered as its managed database, follow instructions in Migrate to ArcGIS Data Store relational data store to reconfigure the hosting server with a relational data store.

Use the Data Store Configuration wizard to create a data store

If you run the installation wizard, the Data Store Configuration wizard automatically opens in your default web browser. Alternatively, you can open the wizard from the computer's shortcut menu or type the URL in a browser. The Data Store Configuration wizard URL is in the format https://datastoremachine.domain.com:2443/arcgis/datastore.

  1. Specify the URL of the GIS Server site for which you want to create and register a data store.

    The GIS Server site URL is in the format https://gisserver.domain.com:6443. Note that even if your GIS Server site uses a web adaptor, provide the URL in the aforementioned format.

  2. Type the user name and password of an ArcGIS Server administrator and click Next.

    The user must be a built-in user (not an enterprise user).

  3. Choose the type of data store to create on this machine and click Next.

    You can create more than one type of data store on the same machine, but Esri does not recommend this as the data stores will compete for memory resources, which can lead to poor performance.

  4. Type a location for the ArcGIS Data Store directory.

    This directory contains the data store files, plus the relational data store backup directory (if you created a relational data store).

    Note:

    You cannot use a UNC path when specifying the data store file directory.

    Keep data store files on the same machine where you install ArcGIS Data Store.

    You should move the backup directory to another machine, however, as it contains the relational data store backup files necessary to recover hosted feature layer data. After you finish configuring your data store, move the backup directory to a mapped network drive on a machine separate from the one you specified for the installation and data store directories. You can use a UNC path when you change backup directories. See Manage data store backups for more information.

  5. Click Next.
  6. Review the information on the Configuration Summary dialog box. If it is correct, click Finish. If changes are needed, click Back to make corrections.

    Note that the first relational or tile cache data store you register with a GIS Server site is the primary machine. If you install ArcGIS Data Store on a second machine, and create another relational or tile cache data store registered to the same GIS Server site, it will be a standby machine.

    When the setup completes successfully, you have a data store machine.

    If there were errors with the setup, click Next on the Configuration Summary dialog box to reopen the Data Store Configuration wizard so you can provide different information. See Troubleshoot ArcGIS Data Store for causes and resolutions for setup errors.

Use the configuredatastore utility to create a data store

You can use the configuredatastore command utility to create a relational, tile cache, or spatiotemporal big data store and register it with your GIS Server site. The utility is installed in <ArcGIS Data Store installation directory>/tools.

Note that if you script the creation of multiple spatiotemporal big data store machines, one spatiotemporal big data store machine must be manually configured with the GIS Server before you can script creation of additional spatiotemporal big data store machines.

  1. Open a Command Prompt using the Run As Administrator option.
  2. Run the configuredatastore.bat file and specify the GIS Server URL with which you want to register the data store, the user name and password of an ArcGIS Server administrator, the path to use for the ArcGIS Data Store data directory, and the type of data store you want to create.

    In this example, the GIS Server URL is https://myserver.domain.com:6443/arcgis/admin, the administrator user name and password are siteadmin and T1n@sp, the data directory is C:\data\, and a relational data store will be created:

    configuredatastore https://myserver.domain.com:6443/arcgis/admin siteadmin T1n@sp c:\data\ --stores relational

    If you want to create more than one type of data store on the same machine using the same data directory, you can specify the values separated by a comma. For example, you can create a relational and tile cache data store on the same machine by specifying relational,tileCache with the --stores operation. However, Esri does not recommend you put more than one data store on the same machine because the data stores compete with one another for resources such as memory, which can negatively affect performance.

    The primary data store machine is created and registered with your GIS Server site.

Next steps

Be sure the GIS Server site you registered your data store with has been configured as your portal's hosting server.

If you created a spatiotemporal data store to archive observation data, be sure your portal has a federated ArcGIS GeoEvent Server.

If you created a spatiotemporal data store to store output from GeoAnalytics Tools, be sure you have a federated ArcGIS GeoAnalytics Server.

Also, configure a secure location for data store backups.