Database connections are supported in Insights Enterprise and Insights Local.
The following table lists the supported databases you can connect to when using Insights. Database connections allow you to add data from these databases to Insights.
Insights Enterprise and Insights Local allow you to create a connection to a supported Microsoft SQL Server, Oracle, SAP HANA, or PostgreSQL database that has a non-versioned enterprise geodatabase defined. If the geodatabase is versioned, the data must be unregistered as versioned to work in Insights. Currently, only geodatabase user tables not created under the sde user schema can be viewed and accessed from Insights. Insights does not work directly with file and personal geodatabases.
Microsoft SQL Server
Cloud database as a service:
Standard/Standard One/Enterprise Editions:
Oracle 11g supports read-only functionality. Other Oracle database versions support read/write functionality.
Postgres PostGIS Support:
PostgreSQL Geodatabase support:
SAP HANA Modeling Views are not supported.
* Not supported for Insights 3.2 or later.
For more information about databases, see the following:
- Required vendor files (Insights Enterprise only)
- Configure ArcGIS Enterprise to support Insights
- Create a database connection
- Supported data types from database datasets
- Geodatabases in Oracle
- Geodatabases in Microsoft SQL Server
- Geodatabases in PostgreSQL