> For the complete documentation index, see [llms.txt](https://help.auxalia.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.auxalia.com/plant-tools/planttools/external-data-sources.md).

# External Data Sources

{% hint style="danger" %}
**Not released yet.** This page describes a function of an upcoming release.
{% endhint %}

External data sources bring tables from outside the Plant 3D project into PlantTools - a SQLite, Microsoft Access, Excel or CSV file, or a table of a SQL Server database. They are set up once per project in Plant Project Setup; PlantDataManager shows and edits them, and PlantReporter reports on them.

| Where               | What you can do                                                                                                                                  |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ |
| Plant Project Setup | **PlantTools Settings → External Data Sources**: one configuration per source - the file or connection, one table or all of them, and the access |
| PlantDataManager    | The views under **External Data Sources**: see a table, change values, add and delete rows                                                       |
| PlantReporter       | The query source **External Data Source** of a report configuration: report on a table                                                           |

Good to know:

* The configurations are saved with the project and are the same for every user and every tool.
* A file inside the project folder travels with the project; in Collaboration and Vault projects it comes from the server. A file outside the project is used where it is.
* A change in PlantDataManager is written to the source at once - there is no separate save.
* The access of a configuration decides what can be changed: **Full access** (change values, add and delete rows), **Editing values only** or **Read-Only**. Views and tables without a primary key always open read-only.
* While you edit a file, nobody else can: a lock file next to it - or, in Collaboration and Vault projects, the check-out - shows who has it.
* PlantReporter only reads a source; it neither locks nor checks out anything.

Table of Content:

* [How to use Videos](https://help.auxalia.com/plant-tools/planttools/external-data-sources/how-to-use-videos.md)
* [Settings](https://help.auxalia.com/plant-tools/planttools/external-data-sources/settings.md)
* [Reference](https://help.auxalia.com/plant-tools/planttools/external-data-sources/reference.md)
* [Workflows](https://help.auxalia.com/plant-tools/planttools/external-data-sources/workflows.md)
