The Insights team has been kicking the tires on an ambitious project to enable Insights to connect to any data source. That’s right, I said any data source.
- NoSQL data stores
- Web services
- Cloud drives
With several patterns under consideration, we want your feedback and encourage you to try the data provider pattern. Since Insights for ArcGIS already works natively with Excel files, I’ve included step-by-step instructions showing how to connect to Google Sheets using the provider pattern. As you might expect, data continues to live in Google Sheets, so you can continue taking advantage of Google’s capabilities, while gaining the ability to analyze and examine spatial and non-spatial data within Insights.
Getting a load of new forms of data in interactive charts, maps, and models is truly a great experience. All data provider developers need to know are how to:
- Fetch data from an API
- Format data as GeoJSON
The rest of the heavy lifting is taken care of by the provider framework. While this pattern and project is still evolving, please feel free to use it with Insights for ArcGIS and give us your feedback.
Create a provider that connects to Google Sheets
All of the step-by-step instructions with code and notes can be found in this GitHub project. Additional information about creating a provider can be found here. Once you’ve completed, you’ll see a complete transformation.
You’ll have started with this:
The final product will be something like this:
Now that you’ve seen one provider in action, with Google Sheets, let us know what other connections you’d like to see e.g. Microsoft Office 365, Salesforce etc. We’d like to hear from you.