Connect to a database

In ArcGIS Pro, you can work with the following database resources:

These resources have different software architectures and properties. File geodatabases, mobile geodatabases, SQLite databases, and GeoPackage files are stored on the file system. Enterprise geodatabases, databases, and cloud data warehouses are remotely located and are accessed through connection files stored on the file system.

Note:

The term database is often reserved for database management systems (DBMS) such as IBM Db2 or Oracle. However, in an ArcGIS Pro project, all the resources listed above may appear in the Databases container Databases of the Catalog pane or catalog view and are called databases in this context.

One way to access a database is to browse to it from a folder connection. (If the database is remote, you browse to its database connection file.) For convenience, you can also add a database to the catalog's Databases container Databases. This does not copy or move any files; rather, it creates a connection—essentially, a reference or shortcut—that allows you to use the resource without browsing to its folder location.

It may be useful to make a database connection to a resource while maintaining access to it from a catalog folder. For example, some geoprocessing operations on input data create text or XML files that can't be stored in an output database. By default, these output items are stored in the folder that contains the database and must be accessed from a folder connection.

Database and folder connections expanded in the Catalog pane
In this example, a file geodatabase can be accessed from a database connection or a folder.

Note:

You may need to refresh a connection if the contents of an item are changed outside your current ArcGIS Pro session. You may need to repair a connection if it becomes invalid.

Access a database in a folder

You can access and use a database by browsing to the folder that contains it. If the database is remotely located, you browse to its connection file, which is stored on the file system.

  1. Connect to a folder that contains the database you want to use.
  2. In the Catalog pane or a catalog view, browse to the database from the folder connection.

Add a database to a project

You can add an existing database or database connection file to the catalog's Databases container Databases. This allows you to use the database without browsing to a folder.

  1. Open a browse dialog box using one of the following methods:

    On the ribbon

    Click the Insert tab. In the Project group, click Connections Add Connection, point to Database, and click Add Database Add Database.

    In the Contents pane of a catalog view

    Click Databases Databases. On the ribbon, click the Catalog tab. In the Create group, click Add Add and click Add Database Add Database.

    In the Catalog pane

    On the Project tab, right-click Databases Databases and click Add Database Add Database.

  2. Browse to and select one or more geodatabases, SQLite databases, GeoPackage files, or database connection files on your local computer or a network computer.
  3. Click OK.

    The database appears in the Databases container Databases in the Catalog pane and the Contents pane of a catalog view.

    You can also add a database to a project using the following methods:

    In the Catalog pane, a catalog view, or the Contents pane of a catalog view

    • Browse to a database, right-click it, and click Add To Project Add To Project.
    • Browse to a database, select it, and drag it to the Databases container Databases in the Catalog pane or the Contents pane of a catalog view.

    In File Explorer

    Browse to a database, select it, and drag it to the Catalog pane or the Contents pane of a catalog view. It appears in the Databases container Databases.

Create a file or mobile geodatabase

There are many ways to create a file or mobile geodatabase from the user interface and add it automatically to the project. You can also use the Create File Geodatabase geoprocessing tool to set a File Geodatabase Version parameter or the Create Mobile Geodatabase geoprocessing tool.

Create a file or mobile geodatabase in the current folder

In this workflow, you first browse to a folder and then specify the item you want to create.

  1. Create a file or mobile geodatabase using one of the following methods:

    In a catalog view

    Browse into a folder. On the ribbon, click the Catalog tab. In the Create group, click New New and click File Geodatabase New File Geodatabase or Mobile Geodatabase New Mobile Geodatabase.

    In the Catalog pane

    Browse to a folder and select it. Right-click the folder, point to New New, and click File Geodatabase New File Geodatabase or Mobile Geodatabase New Mobile Geodatabase.

    On a browse dialog box

    Browse into a folder. Click the New Item drop-down arrow and click File Geodatabase New File Geodatabase or Mobile Geodatabase New Mobile Geodatabase.

    A file or mobile geodatabase is created with a default name. The name is immediately editable.

  2. Type a new name for the geodatabase and press the Enter key.

    The geodatabase is updated with the new name. It appears in its folder location in the catalog and under the Databases container Databases.

Create a file or mobile geodatabase and browse to a folder

In this workflow, you first specify the item you want to create and then browse to a folder.

  1. Create a file or mobile geodatabase using one of the following methods:

    On the ribbon

    Click the Insert tab. In the Project group, click Connections Add Connection, point to Database Database, and click New File Geodatabase New File Geodatabase or New Mobile Geodatabase New Mobile Geodatabase.

    In the Contents pane of a catalog view

    Click Databases Databases. On the ribbon, click the Catalog tab. In the Create group, click New New and click New File Geodatabase New File Geodatabase or New Mobile Geodatabase New Mobile Geodatabase.

    In the Catalog pane

    On the Project tab, right-click Databases Databases and click New File Geodatabase New File Geodatabase or New Mobile Geodatabase New Mobile Geodatabase.

  2. Browse to a folder on your computer or a network computer.

    The default location is the project home folder.

  3. In the Name box, type a name for the file geodatabase.
  4. Click Save.

    A file geodatabase is created and added to the project. It appears in its folder in the catalog and in the project's Databases container Databases.

Create a GeoPackage

There are many ways to create a GeoPackage from the user interface and add it automatically to the project. You can also use the Create SQLite Database geoprocessing tool to set a Spatial Type parameter.

Create a GeoPackage in the current folder

In this workflow, you first browse to a folder and then specify the item you want to create.

  1. Create a GeoPackage using one of the following methods:

    In a catalog view

    Browse into a folder. On the ribbon, click the Catalog tab. In the Create group, click New New and click GeoPackage New GeoPackage.

    In the Catalog pane

    Browse to a folder and select it. Right-click the folder, point to New New, and click GeoPackage New GeoPackage.

  2. Type a new name for the GeoPackage and press the Enter key.

    The GeoPackage is updated with the new name. It appears in its folder location in the catalog and under the Databases container Databases.

Create a GeoPackage and browse to a folder

In this workflow, you first specify the item you want to create and then browse to a folder.

  1. Create a GeoPackage using one of the following methods:

    On the ribbon

    Click the Insert tab. In the Project group, click Connections Add Connection, point to Database Database, and click New GeoPackage New GeoPackage.

    In the Contents pane of a catalog view

    Click Databases Databases. On the ribbon, click the Catalog tab. In the Create group, click New New and click New GeoPackage New GeoPackage.

    In the Catalog pane

    On the Project tab, right-click Databases Databases and click New GeoPackage New GeoPackage.

  2. Browse to a folder on your computer or a network computer.

    The default location is the project home folder.

  3. In the Name box, type a name for the GeoPackage.
  4. Click Save.

    A GeoPackage is created and added to the project. It appears in its folder in the catalog and in the project's Databases container Databases.

Connect to a supported database

To connect to a supported database, you must fill in connection properties that identify the database and authenticate your credentials. Typically, this information is provided by a database or GIS administrator. A successful connection creates a database connection file (.sde) that is stored by default in your project home folder.

Note:

You may need to install client software on your computer before you can create the connection file.

The database to which you connect may or may not contain an enterprise geodatabase. If it does not, you can still view data in the database.

For details on connecting to supported databases, see the following topics:

Connect to a cloud warehouse

Connecting to a supported cloud warehouse is similar to connecting to a database, although some connection properties may be different. See Connections to cloud data warehouses in ArcGIS Pro.

Add a database to your project favorites

If you use the same database in many projects, you can make it a favorite. A favorite can be added to any project from the Favorites tab of the Catalog pane or the Favorites container Favorites in the Contents pane of a catalog view. When you make a database connection a favorite, its connection properties are stored and don't need to be provided again when you add the favorite to a new project. A copy of the database connection file is saved to the Favorites folder in your roaming profile.

You can create database resources that are automatically made favorites. These resources—such as a new file geodatabase or a new database connection file—are stored by default in the Favorites folder in your roaming profile and are potentially available on every computer you use.

Tip:

You can make a database resource a favorite by dragging it from its catalog folder location, the catalog Databases container Databases, or File Explorer to the Favorites tab of the Catalog pane or the Favorites container Favorites in the Contents pane of a catalog view.

Remove a connection

You can remove an item connection in the Catalog pane or catalog view if you no longer need to work with the item or if its contents become unavailable. When you remove an item connection, the item and its contents are no longer directly accessible from the project. However, they are not deleted from their computer, network, or cloud location.

You cannot remove item connections to items required by the project, such as the home folder, default toolbox, and default geodatabase.

To remove a connection, complete the following steps:

  1. In the Catalog pane, browse to the item connection.

    Alternatively, with the catalog view active, browse to the item connection in the Contents pane or the catalog view.

  2. Click the item connection to select it.
  3. Right-click the item and click Remove From Project Remove From Project.

    When the catalog view is active, you can also use the ribbon to remove an item connection. On the ribbon, click the Catalog tab. In the Organize group, click Remove Remove From Project.

Related topics