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.
Solved! Go to Solution.
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?
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.
Defining relationships between datasets is possible when:
Insights on ArcGIS Enterprise:
Insights on ArcGIS Online:
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!
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.