How To Add A Database Connection In Arcgis

When you connect to a database in ArcGIS Pro, you will be prompted to fill in the connection properties. Through the synchronization process, you can control whether a user can upload their changes, download others' changes, or both. need to link map with record. Some of the databases you access can contain geodatabase tables, functions, and procedures, but they don't have to; you can connect to any supported database and view the data from ArcGIS for Desktop. The databases you access can contain geodatabase tables, functions, and procedures, but they don't have to; you can connect to any supported database and view the data from ArcGIS for Desktop. Hosted feature layers let you visualize, analyze, and share the data through maps. To publish ArcGIS Server web services that reference the data in your SQL Server database, register the database connection file with the ArcGIS Server site. The exploratory regression tools in ArcGIS are well made because the outputs allow users to connect statistics with their data. Add Geodatabase Data E-mail this topic Print this topic When you select Geodatabase Data in the Home tab's Add Content split button's list of content types, you'll be able to browse for a file geodatabase or create and connect to an ArcSDE database to access its contents. Apps and data for your organization. So in our folder called data which is a folder connection to our exercise files, there's a geo database called nemino, and we're going to drag and drop the parcels into our current map. GIS Setup and Configuration (v7. Hi all, I am new in doing ArcGIS10: Add Spatial Database Connection to Microsoft SQL Server 2008 Management Studio (aka SQL Server 2008 Express). arcgisonline. You will now see your worksheet in the Table Of Contents under your shapefile name **Note: When you add a worksheet, the Table of Contents view switches from 'Drawing Order' to 'Source'. 1 or ArcCatalog 10. How to Connect to the SGID via ArcSDE. Connect PostgreSQL to ArcGIS by using ODBC connection Xuebin Wei. permalink embed. To have a Feature Service configured, only a normal. Add this code immediately after adding the trails layer to the operational layers of the scene. You can also follow these same steps to import other data tables into Access, such as dbf files or txt files, with some minor. ArcGIS Marketplace. 1 or ArcCatalog 10. Instructions provided describe how to add a database connection model parameter to display existing database connections in a model. Adding a direct connection to a DB2 or Informix geodatabase. This article explains how to set up a user on your MySQL server to connect remotely. Right-click and select New ToolBox. Once connected, you can view and use the images just as you would if they were on your computer. gov - Creating an ArcGIS Server Connection in ArcCatalog: 1. One common Primary key in the database. 3 Add Excel lat long coordinates table to ArcMap. ArcGIS Online hosts several tile and vector tile basemaps that you can use in your map (2D) or scene (3D), including streets, satellite, streets-vector, and streets-navigation-vector. I have installed Oracle 11g, and I can connect as sysman to the Oracle database, but there is no tnsnames. Even if your WFS extracts data from a large database,. The tool used in ArcGIS to add coordinate values is called "Add XY Coordinates" and can be found in the ArcToolbox. Type the SQL Server instance name in the Instance text box. Click Close on the Customize dialog box. In the Data Connect window, select Add ArcGIS Connection in the Data Connections By Provider list. Re-establish the dbo_egdb database connection (by double-clicking on it). ArcGIS Online | | | ArcGIS Online | | |. In general, it is unwise to use mixed-case in names of database objects, because ArcGIS clients are unlikely to be able to see them. 1 or ArcCatalog. Rename the toolbox with a unique name. Select , and then click. Authentication type. Close out the Oracle installation wizard and follow these steps to copy the TNS connection file. In the Add data dialog box, click on the drop down arrow at the top. This opens the Interoperability Connection dialog box. The following steps describe using the Database Connection dialog box. 1 Web help topic Adding OLE DB connections to. Connecting directly from a client application to a geodatabase means that communication between the database and client takes place by way of a direct-connect driver, not through an ArcSDE service. In the Data Connect window, select Add ArcGIS Connection in the Data Connections By Provider list. display import display for some reason it asks for arcpy when it isnt supposed to need to so i import that aswell mygis = GIS("pro") # Use ArcGIS Pro to connect myaccount = mygis. Database from HWSD. Download Imagery from an Online Database. This opens the Interoperability Connection dialog box. Database = " LocalGovernment ", // Provided that a login called gdb has been created and corresponding schema has been created with the required permissions. We like both QGIS and ArcGIS for all-purpose mapping. Our antivirus check shows that this download is clean. To open a geodatabase using a connection file, create an instance of the geodatabase class and specify the file path in the class constructor. 142 is available as a free download on our software library. At the SQL> prompt, unlock the HR account and reset its password: ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY password; The system responds: User altered. Database connections. How To: Add a database connection model parameter to display existing database connections in a model Summary. # YOU NEED AN EMPTY MXD FILE TO START (empty. Intermediate ArcGIS Pro 1-P20-101 Intermediate ArcGIS Pro Course Length: 3 days ArcGIS Version: Pro 2. Right-click on your dbo_egdb database connection and select Administration > Add User. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. Additionally, be aware that if you create a connection file in ArcGIS 10. Steps: Using either ArcMap or ArcCatalog (v. See the section "Adding a direct connection to a SQL Server geodatabase" in the topic Creating spatial database connections for details on how to do this. Programming in Visual Basic. When you connect to a database in ArcGIS Pro, you will be prompted to fill in the connection properties. Database server connections allow you to administer SQL Server Express geodatabases—for example, to create new instances of SQL Server Express geodatabases, add users, set user properties, and so on. Choose "Microsoft OLE DB Provider for ODBC Drivers", and you should be able to find your DSN under the "Use data source name" dropdown list. Instance = @" testMachine\testInstance ", // Provided that a database called LocalGovernment has been created on the testInstance and geodatabase has been enabled on the database. Our antivirus check shows that this download is clean. In the Add ArcGIS Server dialog box, make sure "Use GIS Services" is selected and choose Next (see below). We are pleased to announce a new release of Trimble Positions Desktop: Trimble Positions Desktop add-in 10. I have installed Oracle 11g, and I can connect as sysman to the Oracle database, but there is no tnsnames. 1 or ArcCatalog 10. Below is an example of connecting to an ArcSDE Personal geodatabase. You have reached the home for the ArcGIS Online Geocoding Service. Database connections in ArcGIS for Desktop. dBASE tables Files with the dBASE tabular data structure can be loaded into ArcGIS projects. These layers are hosted by ArcGIS Online or by other ArcGIS servers. Open up ArcCatalog or the ArcGIS catalog tree. Connect to a MySQL database remotely. Create a new enterprise database connection. The ADO command syntax for this operation is, connection obj. Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection. 1 XML Workspace Document, with a geometric network that was created from ArcSDE, into a geodatabase. Due to case sensitivity in some databases, there may be database, schema, table, or column properties which might prevent ArcGIS connectivity. To have a Feature Service configured, only a normal. ArcGIS Hub is an easy-to-configure cloud platform that organizes people, data, and tools to accomplish Initiatives and goals. Adding a direct connection to a DB2 or Informix geodatabase. Survey123 Connect for ArcGIS 3. # YOU NEED AN EMPTY MXD FILE TO START (empty. Re-establish the dbo_egdb database connection (by double-clicking on it). In the ODBC Data Source Administrator Window, click on the ADD button on the right side of the screen. Add the OLE DB Connection command as a button to a toolbar in ArcCatalog. In the Add ArcGIS Server dialog box, make sure "Use GIS Services" is selected and choose Next (see below). Sync the database connection in Cartegraph GIS Integration. ora file myself?. Join dialog. The default settings are fine. In the case of feature services on ArcGIS Server sites federated with an Enterprise portal, the credentials must be specified by the user when adding the portal connection in ArcGIS Pro. x) MySQL :: Download Connector/ODBC Adding an OLE DB Connection in ArcGIS Desktop. Database server connections allow you to administer SQL Server Express geodatabases—for example, to create new instances of SQL Server Express geodatabases, add users, set user properties, and so on. Database from HWSD. When a coded domain value is associated with a field with its source in a library, the Description is stored in the Cartegraph library. The recommended workflow to use ArcGIS tiled map as a background map in Tableau is simply to add it in Tableau. 1 or a version of ArcGIS Pro lower than 2. If you visit the website, can be seen there are links under Folders and Services (see figure 2). Net How to Connect Access Database to VB. Join the Learn ArcGIS organization to complete lessons and practice ArcGIS Online analysis workflows. You will have to determine the OLE DB Server name, UID and PWD. NIM057586 - Create an ArcCatalog extension Add-in ("Auto-load", "Show in Extension Manager") using the Desktop Add-ins template, the extension is not automatically loaded and the OnStartUp() event is not fired when. I typically just add Access this way (Add Data) but my understanding is that it is not correct. We like both QGIS and ArcGIS for all-purpose mapping. NIM057586 - Create an ArcCatalog extension Add-in ("Auto-load", "Show in Extension Manager") using the Desktop Add-ins template, the extension is not automatically loaded and the OnStartUp() event is not fired when. You can either create a user connection to use GIS services, or an administrative connection to manage GIS What would you like to do? use GIS Services Manage GIS Services < Back Cancel. Download Imagery from an Online Database. 2 which is current standard on UW-Milwaukee for ArcGIS. Do I need to generate the tnsnames. Mine appears like this, with a successful connection. spatial and. Test your ODBC connection using the SDE user from both the Pro and Enterprise instances; Start ArcGIS Pro and create a new project; Right click the Databases group in the Catalog pane on the right and select New Database Connection; The following dialog will appear. This opens the Add Data dialog. 1 for Desktop or using the Create Database Connection tool, previous release ArcGIS clients cannot use the connection file. The Select User(s) grid will be editable. To Begin, you will need to open your control panels as follows: Click on Start, then click on Control Panels. The following steps describe using the Database Connection dialog box. # You'll need to change it up # to work in your environment. When you connect to a database in ArcGIS Pro, you will be prompted to fill in the connection properties. To browse the HR schema: In the Connections frame, to the left of the hr_conn icon, click the plus sign (+). The following steps describe using the Database Connection dialog box. mxd) # As of right now, you can't create a new mxd from # nothing in Arcpy. ora file that I can find. public async Task OpenEnterpriseGeodatabase() { await ArcGIS. In general, it is unwise to use mixed-case in names of database objects, because ArcGIS clients are unlikely to be able to see them. Database from HWSD. Instructions provided describe how to create a direct connection to an Oracle database. If you have a list of Excel lat long coordinates in a spreadsheet, giving them locations can be a daunting task for those starting out in ArcGIS. Attachments and FME Because attachments are handled by a relationship class, FME is capable of easily creating this sort of connection. 4 contains. Additionally, be aware that if you create a connection file in ArcGIS 10. Sync the database connection in Cartegraph GIS Integration. Do I need to generate the tnsnames. The feature ID in this column provides the link between the base table with the associated ArcSDE-managed feature and spatial index tables. Type the SQL Server instance name in the Instance text box. Outlined in this article are the steps to take in order to add X Y coordinates to a field in the attribute table. Check your software manual or help files for specific instructions on how to add a mapping service. About database connections. Connecting to these databases instead of extracting and storing local copies helps to ensure your data is current and complete. In the Add Data dialog box, double-click to view available map services. The Database Connection dialog will open and allow you to select your database platform, enter the instance or data source for your database and provide your authentication information. Open ArcMap 2. 2 which is current standard on UW-Milwaukee for ArcGIS. Is there any way to do this without jumping through all the hoops at TXDOT to add their database connection?. Under the Interoperability Connections node, double-click Add Interoperability Connection. ArcGIS Enterprise. ArcGIS Hub is an easy-to-configure cloud platform that organizes people, data, and tools to accomplish Initiatives and goals. Hosted feature layers let you visualize, analyze, and share the data through maps. the connections used for this database are Read-Only. Navigator indexes and provides access to geospatial data from project, state and national levels, so everything from small scale projects to national data compilations can be shared internally and externally. On the ribbon, on the Catalog tab, in the Create group, click Add and choose Add Folder Connection. This is the default. Open a new ArcMap session and add some data (not through WFS) to show enough geographic context for you to zoom into a small area of particular interest to you. Connecting to a Microsoft Access database in ArcGIS You can use tables from a Microsoft Access database in ArcMap through an OLE DB connection. Double-click the Database Connections folder in the Catalog tree. Database server connections allow you to administer SQL Server Express geodatabases—for example, to create new instances of SQL Server Express geodatabases, add users, set user properties, and so on. ArcGIS for Server Geodatabase Administration - Part 2 4. Below is an example of connecting to an ArcSDE Personal geodatabase. Orange Box Ceo 7,198,339 views. # This is a sample of how to add data # to an mxd file, convert to msd and publish # to ArcGIS Server without using ArcMap. A note about ArcGIS, WFS, and the "Numeric Identifier Attribute" ArcGIS handles WFS in either of two different ways, depending on whether you entered a value in the field "Numeric Identifier Attribute" (see #8 in the screen shot above):. Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. Open ArcToolbox. Under Connection Name, type a name for this connection. If using ArcGIS 10. A number of geographic information systems software packages can connect directly with the service. Introduction. Authentication type. How To: Add a database connection model parameter to display existing database connections in a model Summary. For those users, you can use the Create ArcSDE Connection File tool to preconfigure a connection file. In the ODBC Data Source Administrator Window, click on the ADD button on the right side of the screen. Follow the steps below to add a new Interoperability Connection in ArcCatalog for the MGE dataset found in the Parcels folder. Double click on the new group and add members within the members tab. Go into Arc Administrator and select the type of licence you are using (Concurrent or Single Use). The connection is added to the Server or Database directories in the Catalog pane. This file tells Oracle and ArcGIS where to direct the database connection. ArcGIS Online hosts several tile and vector tile basemaps that you can use in your map (2D) or scene (3D), including streets, satellite, streets-vector, and streets-navigation-vector. Double-click the Database Connections folder in the Catalog tree. the connections used for this database are Read-Only. From the "Look in:" dropdown list Select GIS Servers 4. The section on Database connections gives details on the configuration of database client software. At least one registered relational data store type is required before client applications such as Insights for ArcGIS can create Relational Database Connection portal items. One common Primary key in the database. Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. Connecting to KY Geoportal Image Services - kyraster. 1 no longer supports DCOM connections, and existing applications that use the ArcGIS Server Local connection type will not be able to use services you publish with 10. like Don said four years ago: If they have an ODBC or OLE DB driver that is typically the easiest way to connect. If the connection file you are creating will provide ArcGIS services with access to the database or geodatabase, or if you want to use the Catalog search to locate data accessed through this connection file, you must type a user name and password. Open the catalog view and click Project or Databases in the Contents pane. In ArcMap, click the Add Data button and navigate to the data to be added 3. SQL database queries Using ArcGIS 's SQL connect functionality, SQL-compliant databases can be used to provide tabular data to ArcGIS projects. Also note that since PostgreSQL client libraries are installed with ArcGIS Server , there is no PostgreSQL entry needed in init_user_param. ervlces ReadNÝ To- Use Services Show of type: GIS Servers Datasets, Layers. When you add a database connection under the Database Connections node in the Catalog tree in ArcGIS for Desktop, a file is created on the client computer that contains the connection information to a database that you provide. This file is at \\dcgisshare. from arcgis. Database connections. Survey123 Connect for ArcGIS 3. Database Connection. If you are a developer, detailed documentation for using this service in your application is available in the ArcGIS Online Geocoding Service Help. How To: Add a database connection model parameter to display existing database connections in a model Summary. One of the most useful aspects of the Indiana Spatial Data Service (ISDS) is the ability to load its map services directly as data layers into Esri's desktop GIS software, including ArcGIS for Desktop and ArcGIS Explorer. If the connection file you are creating will provide ArcGIS services with access to the database or geodatabase, or if you want to use the Catalog search to locate data accessed through this connection file, you must type a user name and password. SDE file is an ArcSDE Connection File. You add a database server connection in the Catalog window in ArcMap or ArcCatalog if you need to perform administrative tasks on a Microsoft SQL Server Express instance or the geodatabases it contains. All connections are disconnected when you start ArcCatalog. I typically just add Access this way (Add Data) but my understanding is that it is not correct. Run(() => { // Opening a Non-Versioned SQL Server instance. edu arcgis on imageserver. The Register Database dialog will open. It is used for creating and using maps, compiling geographic data, analyzing mapped information, sharing and discovering geographic information, using maps and geographic information in a range of applications, and managing geographic information in a database. Expand the Database Connections folder and double-click Add Database Connection. Next, you will need to add the link to the web service. 1 supported both DCOM (ArcGIS Server Local) and HTTP (ArcGIS Server Internet) connections. If using ArcGIS 10. Under Server Name, Instance Name, and Data Store, enter the information for your database. ArcGIS Hub is an easy-to-configure cloud platform that organizes people, data, and tools to accomplish Initiatives and goals. Programming in Visual Basic. There are two login options for creating a connection to a database or enterprise geodatabase: database authentication and operating system authentication. That said, the fields created from the SQL Server database are of an external type, and edits made to these fields in SharePoint cannot be passed back to the database. To edit registered feature classes or tables, apply all updates against the ADO recordset. Joining Census Data Tables to Shapefiles in ArcMap. In this section, I am showing the 3 basic steps to connect PostGIS database with a widely used open source desktop based gis, QGIS. spatial and. Connect without a DSN (using a connection string) To create 'examples' database on your MSSQL Server you should run the following script: CREATE DATABASE examples; USE examples; CREATE TABLE cars( id int UNIQUE NOT NULL, name varchar(40), year varchar(50), PRIMARY KEY(id) ); INSERT INTO cars VALUES(1,'Mercedes','2000'); INSERT INTO. The Data Link Properties dialog box appears in which you can Click. Outlined in this article are the steps to take in order to add X Y coordinates to a field in the attribute table. Using SQL*Plus, connect to Oracle Database as a user with the ALTER USER system privilege. Difficulty: Moderate Requirements: ArcGIS 10 or higher This tutorial will demonstrate how to format census data tables from the U. permalink embed. Connect from ArcGIS for Desktop. Under the Interoperability Connections node, double-click Add Interoperability Connection. me myaccount ValueError: Could not use Pro authentication. Add the ODBC driver as a data source on the machine. This release provides support for a TerraFlex workflow with offline data transfer and post-processing when using TerraFlex v4. Test your ODBC connection using the SDE user from both the Pro and Enterprise instances; Start ArcGIS Pro and create a new project; Right click the Databases group in the Catalog pane on the right and select New Database Connection; The following dialog will appear. Database connectionsare either connected or disconnected. - [Narrator] Once you have a folder connection, you could add shape files to your map using ArcGIS Pro. For more information on required ArcGIS license levels, please see Required ArcGIS License Types for FME Geodatabase Formats. Connect PostgreSQL to ArcGIS by using ODBC connection Xuebin Wei. First, though, be sure your SQL Server instance can accept connections from remote computers. Server Connection. When the ArcGIS Maps Connect workflow completes, the result is a regular SharePoint list, not an external list. The default location for the file is \\\Users\ Add to Project. A database server connection is a connection to a SQL Server Express instance that is set up to store geodatabases. If using ArcGIS 10. The recommended workflow to use ArcGIS tiled map as a background map in Tableau is simply to add it in Tableau. The Data Link Properties dialog box appears in which you can Click. Add Database Connection in ArcMap 10. Create a new enterprise database connection. Add DEM data From the course: ArcGIS Pro is a popular geographic information system (GIS) that combines the power of 2D and 3D mapping with cloud-based sharing and collaboration features—and. If you have a list of Excel lat long coordinates in a spreadsheet, giving them locations can be a daunting task for those starting out in ArcGIS. Double-click the Database Connections folder in the Catalog tree. Open the catalog view and click Project or Databases in the Contents pane. Then it will open an Add ArcGIS Map Server window as in figure 3. Expand Database Connections and double-click Add Database Connection. # YOU NEED AN EMPTY MXD FILE TO START (empty. Add the ODBC driver as a data source on the machine. From the "Look in:" dropdown list Select GIS Servers 4. Test connection, and you should be good to go. NIM057577 - The "Add ArcGIS Toolbox Reference" dialog does not add the required reference for Custom Toolbox in ArcGIS 10. Open the Active Directory Users and Computers dialog from your domain controller and add a group by right clicking on users and select new group. In the Geodatabase Adminstration toolset, click Create Database User. Connection Microsoft Access database to ArcGIS 10. The mapping platform for your organization. Set up a database connection. Then, double click on the Data Sources (ODBC) icon. shp Click on the Geoprocessing Menu Choose the Buffer Tool. # This is a sample of how to add data # to an mxd file, convert to msd and publish # to ArcGIS Server without using ArcMap. Database Connection ArcGis 10. the connections used for this database are Read-Only. This article explains how to set up a user on your MySQL server to connect remotely. Note: If the database you register contains a versioned geodatabase, ArcGIS Server will access the version set for the connection file. Expand Database Connections and double-click Add Database Connection. Choose the Users select method. Breaking news from around the world Get the Bing + MSN extension. A database connection allows you to add data from a supported database. Adding a direct connection to a DB2 or Informix geodatabase. Click Close on the Customize dialog box. 1 or a version of ArcGIS Pro lower than 2. Database connections. Close out the Oracle installation wizard and follow these steps to copy the TNS connection file. Press Enter. ArcGIS Desktop users are usually familiar with creating spatial database connections to ArcSDE geodatabases, which can be saved as ArcSDE (. Well, this tells us that you chose to connect to the database via OLE DB. For this tutorial I. Zoom in to this area. Intermediate ArcGIS Pro 1-P20-101 Intermediate ArcGIS Pro Course Length: 3 days ArcGIS Version: Pro 2. Click the Add OLE DB Connection button. When developing an ArcGIS Runtime app, you can use a lightweight client API to work with classes in Local Server. That pretty much answers my question and defines the workflow for adding multiple SDE or Database connections to an ArcGIS Pro project. GIS Setup and Configuration (v7. Type a new name for the spatial database connection. ArcGIS layout view is practical. Joining Census Data Tables to Shapefiles in ArcMap. This will help. You will have to determine the OLE DB Server name, UID and PWD. Due to case sensitivity in some databases, there may be database, schema, table, or column properties which might prevent ArcGIS connectivity. ervlces ReadNÝ To- Use Services Show of type: GIS Servers Datasets, Layers. ArcGIS Desktop software provides direct connections to supported database servers providing view, query and analysis of the DBMS data content. Download Imagery from an Online Database. Sign in to add this video to a playlist. Follow the steps below to add a new Interoperability Connection in ArcCatalog for the MGE dataset found in the Parcels folder. When you add a database connection under the Database Connections node in the Catalog tree in ArcGIS for Desktop, a file is created on the client computer that contains the connection information to a database that you provide. This is a message you get when ArcGIS can not find the concurrent licence for the software. Add DEM data From the course: ArcGIS Pro is a popular geographic information system (GIS) that combines the power of 2D and 3D mapping with cloud-based sharing and collaboration features—and. 4 Display XY Data. An innovative database platform, the Online Cultural and Historical Research Environment (OCHRE®), integrates mapping features using the Esri ArcGIS Runtime SDK for Java to facilitate both data entry and visualization of geospatial data, adding a valuable tool to the field archaeologist's kit. Opening an Enterprise Geodatabase using connection properties. Instance = @" testMachine\testInstance ", // Provided that a database called LocalGovernment has been created on the testInstance and geodatabase has been enabled on the database. Expand Database Connections and double-click Add Database Connection. For those users, you can use the Create ArcSDE Connection File tool to preconfigure a connection file. Double-click. enterprise connection for arcgis using sql server Muhammad Abnan. Right click the table and select display XY data. We are pleased to announce a new release of Trimble Positions Desktop: Trimble Positions Desktop add-in 10. When you add a database connection under the Database Connections node in the Catalog tree in ArcGIS for Desktop, a file is created on the client computer that contains the connection information to a database that you provide. Add or remove the new value in ArcCatalog. Connecting directly from a client application to a geodatabase means that communication between the database and client takes place by way of a direct-connect driver, not through an ArcSDE service. We like both QGIS and ArcGIS for all-purpose mapping. The tool used in ArcGIS to add coordinate values is called “Add XY Coordinates” and can be found in the ArcToolbox. The recommended workflow to use ArcGIS tiled map as a background map in Tableau is simply to add it in Tableau. If the connection file you are creating will provide ArcGIS services with access to the database or geodatabase, or if you want to use the Catalog search to locate data accessed through this connection file, you must type a user name and password. # YOU NEED AN EMPTY MXD FILE TO START (empty. You can connect to databases from ArcGIS to view, query, and analyze the data they contain. Connect PostgreSQL to ArcGIS by using ODBC connection Xuebin Wei. The databases you access can contain geodatabase tables, functions, and procedures, but they don't have to; you can connect to any supported database and view the data from ArcGIS for Desktop. The Data Link Properties dialog box appears in which you can Click. ArcGIS Solutions. When I try to load a shapefile from my postgresSQL database connection in ArcGIS Pro, I can add the file to the map but looking at attributes jump to content. - [Narrator] Once you have a folder connection, you could add shape files to your map using ArcGIS Pro. like Don said four years ago: If they have an ODBC or OLE DB driver that is typically the easiest way to connect. Add or remove the new value in ArcCatalog. Double-click the Database Connections folder in the Catalog tree. Set up ArcMap to connect to the database server. The connection is added to the Server or Database directories in the Catalog pane. See The Notes on FME and Esri Compatibility page for more information on what software is required to support this method.