Datastores¶
Because SpectX does not ingest data it must have a gateway through which to access data. These gateways are called datastores. Datastores have the location of the data to be queried, and credentials required to access the data. Numerous data access protocols are supported, and multiple data sources may be accessed simultaneously and their data joined for analysis.
Datastore access is regulated by access control lists, and user role management.
Adding a New Datastore¶
To create a new datastore click New in the top menu bar then Datastore.
Select where the datastore is to be located, multiple datastores with the same name can be created but only 1 data store with the same name can be in each folder. When running scripts SpectX searches for datastores in the following order:
- /user/datastores/
- /shared/datastores/
- /system/datastores/
After selecting the location, the create datastore dialogue box appears, select the appropriate access protocols,
enter any additional configuration parameters then click Browse to ensure that the desired data is accessible.
Once the configuration is complete and the data is accessible, click Create and close the datastore dialogue box.
The newly created datastore is then displayed in the resource tree, its parameters can be edited by double-clicking the datastore.
Data in Relational Databases¶
SpectX supports querying data directly from tables of relational databases (such as Oracle, PostgreSQL, SQLite, etc) using DB_TABLE command.