![]() ![]() sde) is created in the ArcGIS Pro project directory. Click OK to create the connection file.Ī database connection appears under Databases in the Catalog pane, and a connection file (.You must type the database name when you connect to Microsoft Azure Cosmos DB for PostgreSQL no database list is available, and accessing the Database drop-down menu when connecting to Azure Cosmos DB for PostgreSQL returns an error. However, if you do this, you will be prompted to provide a username and password every time you connect. Uncheck Save user name and password if you prefer not to save your login information as part of the connection doing this can help maintain the security of the database. If you choose Database authentication, you must provide a valid username and password in the User name and Password text boxes, respectively. If the login used for the operating system is not mapped to a valid database login, the connection fails. If you choose Operating system authentication, you do not need to type a username and password-the connection is made using the Security Support Provider Interface (SSPI) or Lightweight Directory Access Protocol (LDAP) login name and password used to sign in to the operating system.Choose the type of authentication to use when connecting to the database: Database authentication or Operating system authentication.For example, if PostgreSQL is installed on server mamabear and is listening on port 49200, type mamabear,49200 in the Instance text box. If your PostgreSQL database cluster is listening on a port other than the default (5432), include the port number in the instance. If you choose to use operating system authentication, be sure PostgreSQL can authenticate the ArcGIS Server account. To use the database connection file with ArcGIS Server, you must save the user information with the connection file. You can use the Database Connection dialog box in ArcGIS Pro to connect to the database, as described below.Īlternatively, you can run the Create Database Connection tool in ArcGIS Pro or use Python to run the Create Database Connection command from an ArcGIS Server machine to create a database connection file (. PostgreSQL client files are installed with ArcGIS Pro and ArcGIS Server you do not need to install a PostgreSQL client or set environment variables to access the client. To publish ArcGIS Server web services that reference the data in the PostgreSQL database, register the database connection file with your ArcGIS Server sites.Ensure PostgreSQL accepts connections from the ArcGIS client machines that need access.Confirm that the database name meets ArcGIS requirements.The following list summarizes the steps required to connect from ArcGIS to a PostgreSQL database, including a database that contains an enterprise geodatabase: Register the connection with ArcGIS Enterprise. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |