Table of Contents
File and URL datasource: No
When using a File or a URL datasource connected to a CSV file, it's not possible.
Elements Connect does not provide any way to query children CSV files content.
JNDI datasource: Yes
The benefits brought by this solution are:
use the power of SQL on your datasource file (WHERE, GROUP BY, ORDER BY, ...)
See the structure of your CSV files using the datasource explorer - every file is a distinct table
While this datasource type requires few configuration steps (no need to configure a database), it shall not be used on very large datasets.
We've made some tests on CSV files with 14 columns, with a Jira 8.2 instance running on a 2016 Macbook Pro with a SSD drive.
The query used for our tests was:
|# lines||Average query time|
That's a constant average of 9 μs (10-6 sec) per row (except for small files where file opening / closing seems to generate a significant overload)
Have a look at the JNDI Datasource page to learn how to configure a CSV SQL datasource.