CSV/Excel Querying
CrossCompass will
allow users the ability to query on
various data sources, CSV and EXCEL
being just another data source.
CrossCompass will enable
data extraction via automatic generation of SQL via a simple to
use, user friendly interface. The data once extracted can
be saved into various formats such as CSV,
Excel or PDF.
You
can even extract data from
a database table and a CSV or Excel file
(or both) simultaneously if the data is linked
in some way.
CSV/Excel Administration
If the EXCEL spreadsheet is a simple grid and the columns
are defined as discreet data types then querying is
easy and simple.
If you know the layout of the CSV file
i.e. can describe the columns and their data types e.g. Date
or Text, then as an administrator you can catalogue this
file for access by end-users as you would for a database
table.
From here, CrossCompass will handle
the SQL generation, the security and the data extraction. The
end-user has only to select the fields required, enter some criteria and
the data will be extracted.
|
