

Provide the required connection information.Click Next or click the Connection tab.Click the OLE DB provider you want to use to access data.Double-click Database Connections in the ArcCatalog tree.
#ADD OLE DB CONNECTION ARCGIS 10.3 HOW TO#
The following section explains how to make OLE DB connections using some of the more common OLE DB providers. You can create and manage your OLE DB connections in ArcCatalog using the Data Link Properties dialog box ( learn how to access the Data Link Properties dialog box). However, it is possible to edit the data programmatically. Data accessed through an OLE DB database connection is read-only in ArcGIS.
#ADD OLE DB CONNECTION ARCGIS 10.3 INSTALL#
Be sure to install the driver that matches the release of PostgreSQL to which you want to connect. These can be accessed through the PostgreSQL site at. For OLE DB connections to PostgreSQL, you need to download and install the drivers for PostgreSQL. These include Microsoft's OLE DB providers for Jet, SQL Server, Oracle, and an OLE DB provider for ODBC drivers to access ODBC data sources. You have access to all the OLE DB providers that are installed as part of the MDAC package on your computer. OLE DB providers handle the exchange of information between the data provider (data source) and the data consumer (any system or application code-for example, ArcCatalog or ArcMap) that requires access to data. OLE DB is a database access application programming interface (API) that builds on ODBC technology it is based on Microsoft's Component Object Model (COM) development strategy. These components provide easy access to information maintained in a variety of external data sources, both relational and nonrelational. ArcGIS incorporates Microsoft Data Access Components (MDAC), which include OLE DB providers and ODBC drivers. Each provider should have a Help topic with specific information on how to create a connection.

The Connection tab is different for each provider, although they all require similar information (your user name, password, and the database to which you want to connect). Additional OLE DB providers may be available from other sources. Another provider communicates with Open Database Communication (ODBC) drivers.

They let you access Jet (Microsoft Access), SQL Server, and Oracle databases. Microsoft's OLE DB providers come with ArcCatalog. Looking in an OLE DB connection in the Catalog, you'll see a list of tables in the database. This standard lets you work with data from any database in the Catalog in the same way. ArcCatalog communicates with all OLE DB providers in the same way, with each provider, in turn, communicating with a different database. In ArcCatalog, you can use OLE DB providers to retrieve data from a database.
