Insights for ArcGIS SQL server database limitation

Question

Hello all,

I have a question about the Insights for ArcGIS. Is there any restriction about the the size of the connected SQL database? Is there a record number limit where the Insights for ArcGIS can't handle the size of the database? And the data handling is working on the SQL server side or on the ArcGIS GIS Server side?

I need help on this topics, beacuse of implementation.

Asrujit_SenGupta · Answer

Insights will not see the tables\views of the Linked DB.

Yes, you can create a View in the SQL Server db, which will pull the data from the Linked Server db and then use that in Insights.

LaszloCsunderlik1 · Answer

Thank you for the quick answers.

I have another question. If I linking a server to another in SQL Server (for example PostgreSQL) the Insights will see it? Do I need to create View on Linked Server db?

Asrujit_SenGupta · Answer

The ArcGIS resources mention no such limitation related to the size of the Tables or the Database size itself, so there should not be any limitations as such.

Supported databases—Insights web help Use tab | ArcGIS Enterprise

It doesn't actually depend on the version of SQL Server, rather the edition of SQL Server matters, as SQL Server Express itself has a size limitation of 10 GB (Esri or Insights has nothing to do with this size limitation).

I have connected to Databases larger than 10GB and it worked fine.

Do remember, that Insights cannot connect to an Enterprise SQL Server geodatabase. It supports simple databases only.

I would suggest that you test on a Testing Environment first and then get back here if you face any roadblocks or performance issues.