Data connections
See which data sources eode can read today, find the models that sync from a connected source, and refresh a model from an updated workbook.
Where: Datasets→Import data
Data comes into eode through the Import data window. Today the only source you can pick there is Microsoft Excel. Every other source is listed with COMING SOON and can't be opened.
See which sources are available
Click Import data on the Datasets screen. The window opens on a card for every source, with its logo, name and description, grouped by kind.
| On the card | Meaning |
|---|---|
| No pill | Available. Only Microsoft Excel (.xlsx workbooks). |
| COMING SOON | Not available yet. The card is dimmed and does nothing. |
The COMING SOON sources are Google Sheets, CSV / TSV, Power BI, PostgreSQL, MySQL, SQL Server, Airtable, Microsoft Fabric, Snowflake, Amazon Redshift, Databricks, Salesforce, HubSpot, Strapi, Contentful, USITC HTS, WITS, EIA, FRED Freight, Frankfurter FX, GDELT and Eurostat Labour Costs. The same cards show when you add tables to a dataset.
To use data from one of them today, export it to an Excel workbook and import that.
Find models that sync from a source
A model with a sync schedule rebuilds from its connected sources on that schedule. On Models, its row carries a Scheduled sync mark while the schedule is on, and Show → Scheduled lists those models. Scheduled is offered only while at least one model is in it.
To run or pause a sync, click … on the row, then Model settings. The Scheduled sync row says where the model syncs from, when it last synced and when it runs next, or Paused. Sync now rebuilds it straight away; the switch pauses or resumes the schedule. See Change a model's settings.
A model that syncs from connected sources also has Sync now ("Re-pull data from this model's connected sources now.") at the top of its Scenarios screen.
Refresh a model from an updated workbook
When your workbook changes, a model built from Excel workbooks alone can re-read the updated copy. On
the model's Scenarios screen, click REFRESH FROM WORKBOOK ("Re-apply the saved
data mapping to an updated workbook") and pick the updated .xlsx.
- If the workbook has the same shape, the line beside it reads "Refresh in progress. The model rebuilds with the new data."
- If sheets or columns changed, it reads
2 structural changes detected. Opening reconciliationand takes you to review the changes.
Related
- Import data: the window, step by step
- Datasets: import a workbook once and pick it for any model
- Models: the Show filter, the Scheduled sync mark and Model settings
- Start from a workbook: build a model straight from your spreadsheet