What is a Datasource?
In PersivX, a datasource is any origin of data that can be connected, imported, or managed within the PersivX environment.
PersivX supports two types of datasource, each serving a different purpose depending on how you want to manage your data:
- Live Datasources (with a database connection) — performance is determined by the database's own capabilities.
- Imported Datasources — support out-of-core processing, larger-than-memory data handling, merging multiple datasources into one or more reports, and periodic refresh schedules.
Live Datasource
A Live Datasource connects directly to an external database in real time. PersivX queries data from that database on demand, without importing or saving the data inside the PersivX environment.
Data Handling
PersivX only reads from live datasources and never writes back to the database. Data is fetched in real time, so you are always working with the most up-to-date information from the connected database.
No Data Storage in PersivX
Data is retrieved dynamically through queries whenever it is needed, which suits applications where data changes frequently and live insight is required.
Advantages
- Always up to date — data is fetched directly from the live database every time a query runs.
- No data replication — data is never copied or stored inside PersivX, reducing storage use in the environment.
See How to connect to a live database.
Imported Datasources
An Imported Datasource is data loaded directly into the PersivX environment from external files or APIs. The data is stored within the PersivX workspace, so you can manage, analyze, and visualize it without a live connection to the original source.
Data Handling
Imported datasources are uploaded, processed, and stored within PersivX, allowing efficient use of the data even without access to the original source.
Storage in PersivX
The data is encrypted and saved within the PersivX environment, so you can keep working with it even when disconnected from the source.
Advantages
- Larger-than-memory data processing — work with datasets bigger than available memory, thanks to PersivX's data handling and query processing.
- Merging multiple datasources — combine data from several imported sources into one comprehensive workspace for complex analysis.
- Offline access — data stays available in PersivX even when the original source is unreachable or offline.
Continue with PersivX Workspaces.