topic Re: Problem to create relationship in Insights for ArcGIS in ArcGIS Insights Questions

Problem to create relationship in Insights for ArcGIS

AsmaNKHILI — Thu, 22 Jun 2017 14:32:50 GMT

Hi,

I want to create a relationship between 2 dataset.

One of my dataset is a feature service coming from ArcGIS Online. I registred the url of service with credentials, i can display it in insights but cannot do any relationship with this feature service.

Please, i need your help

The data is grayscaled.

Thanks

Re: Problem to create relationship in Insights for ArcGIS

HeikoHeijenga — Thu, 06 Jul 2017 22:01:55 GMT

Currently you cannot include a layer from ArcGIS Online in a relationship.

Re: Problem to create relationship in Insights for ArcGIS

SebastiánArdila — Fri, 19 Jan 2018 16:36:33 GMT

Is there a plan to enable this feature in the future?

Re: Problem to create relationship in Insights for ArcGIS

Anonymous User — Tue, 13 Mar 2018 20:50:19 GMT

Has this feature been enabled yet?

Re: Problem to create relationship in Insights for ArcGIS

JimCasey — Wed, 20 Jun 2018 16:22:50 GMT

Does this mean that polygon layers cannot be part of a relationship? Polygons are not stored in csv or excel files which are the only supported non-AGOL data. How can polygons be part of a relationship in Insights?

Re: Problem to create relationship in Insights for ArcGIS

RajkumarSingh — Wed, 04 Jul 2018 18:49:54 GMT

Hmmm, I was able to create a relationship involving a feature layer from ArcGIS Online as well as a hosted table a short time ago.

Re: Problem to create relationship in Insights for ArcGIS

JustinCornell — Fri, 03 Aug 2018 12:14:35 GMT

Is there a matrix of supported joins based upon data types? I've noticed the same when you try to join two different datasets from different sql instances. It seems they must be on the same server to be able to do a join.

Re: Problem to create relationship in Insights for ArcGIS

HeikoHeijenga — Mon, 06 Aug 2018 19:55:18 GMT

Defining relationships between datasets is possible when:

Insights on ArcGIS Enterprise:

Datasets are all originating from Hosted Feature Layers (stored in ArcGIS Relational Data Store) or added to Insights by importing an Excel/CSV file
Datasets are all originating from same database connection

Insights on ArcGIS Online:

Datasets are all originating from Hosted Feature Layers in the same organization or added to Insights by importing an Excel/CSV file

Re: Problem to create relationship in Insights for ArcGIS

JustinCornell — Mon, 06 Aug 2018 21:17:35 GMT

Thanks for the information. Is there a way to register database connections/tables with the ArcGIS Relational Data Store? We'd like to be able to create relationships between live data sources and not snapshots of the data sources an host those snapshots. Any advice would be greatly appreciated!

Re: Problem to create relationship in Insights for ArcGIS

AravindatStoryMaps — Wed, 08 Aug 2018 15:33:43 GMT

Hi Justin,

Think of the relational ArcGIS Data Store as a database connection on ArcGIS Server. It is a type of managed database connection registered on the federated server. Therefore, it's not possible to register database connections with the Data Store. You can add data such as a feature class/table into it and that is done when you publish hosted feature services with relationships to a standalone table.

I believe you're referring to live data sources as services that use data from registered enterprise geodatabases or databases with ArcGIS Server. The limitation of creating relationships at this point is that you can't join registered feature layers stored outside ArcGIS Data Store on the hosting server.

If I am not mistaken and you can correct me, you're looking to use relationships on data sources that will reflect data that are constantly updated on the geodatabase/database. You can do this by publishing a hosted feature service to your ArcGIS Data Store/Portal once and then update it nightly by using ArcGIS API for Python: Updating your hosted feature services with ArcGIS Pro and the ArcGIS API for Python. This blog contains instructions on how to do this for ArcGIS Online hosted feature services, you can update your connection to Portal and perform these steps for ArcGIS Enterprise as well.

So, with the script updating your data every day and if you create a model in Insights for the relationship between the different datasets, you can just update the model every day in the workbook to give you the updated version of the relationship.

Let us know if you have any other questions.

Thanks,

Aravind

Re: Problem to create relationship in Insights for ArcGIS

HaticeKorkulu2 — Tue, 30 Apr 2019 16:27:29 GMT

Hi Aravind Sivasailam‌,

I have a similar problem. My data which is at registered enterprise geodatabase(SQL) had published to ArcGIS Server. Then I add my data to Insights for ArcGIS and I could not create any relationship between my data and tables. I think the problem still continues. Will there be any change soon?

Thanks,

Hati

Re: Problem to create relationship in Insights for ArcGIS

SofiaValentin1 — Tue, 07 May 2019 06:17:48 GMT

I also have this problem!

Re: Problem to create relationship in Insights for ArcGIS

RobDunfey — Fri, 13 Mar 2020 12:06:45 GMT

This is very restrictive and limiting the uptake of Insights across the enterprise. Ideally need to be able to work with feature services published to ArcGIS Server.