topic Re: Insights for ArcGIS SQL server database limitation in ArcGIS Enterprise Questions

Insights for ArcGIS SQL server database limitation

LaszloCsunderlik1 — Tue, 21 Feb 2017 15:56:43 GMT

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.

Re: Insights for ArcGIS SQL server database limitation

ManviLather1 — Tue, 21 Feb 2017 18:21:57 GMT

No there is no such limitation from ArcGIS side.

Its completely depends on the version of SQL server (Express, Standard, Advance) you are using. Say for example : In SQL server express, the size of the database is limited to 10 GB.

Re: Insights for ArcGIS SQL server database limitation

LaszloCsunderlik1 — Tue, 21 Feb 2017 18:42:37 GMT

And what about the Insights for ArcGIS application? Can it handle easily for example a massive 10 GB SQL database? If yes how?

Or everything is depend on the versin of the SQL server?

Re: Insights for ArcGIS SQL server database limitation

Asrujit_SenGupta — Tue, 21 Feb 2017 18:53:56 GMT

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.

Re: Insights for ArcGIS SQL server database limitation

LaszloCsunderlik1 — Mon, 27 Feb 2017 11:36:35 GMT

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?

Re: Insights for ArcGIS SQL server database limitation

Asrujit_SenGupta — Mon, 27 Feb 2017 13:03:26 GMT

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.