Query output in "spreadsheet" format?
m.ardito Feb 23, 2017 7:44 AMTeiid motto is "The data you want from the data you have.": well, what if the data I have is SQL and data I want is Spreadsheet?
(I know I'm stretching Teiid scope a bit lot but I'll try anyway, maybe you have suggestions, experiences, etc)
Atm, I'm generating xls files in my php web app getting data from Teiid VDB, and then filling (with phpexcel) a spreadsheet, served by the web server.
Getting data is very fast, filling the spreadsheet is easy, and I can set pretty much any xls feature, but tbh it's kinda slow when exporting thousands of rows, and dozens of columns.
Like, I can generate a 300k cells .csv in 4 seconds, but the .xls takes more than 55. I have some bigger dataset that could make timings worse...
Could Teiid be faster, helper by some library? What if I could have (maybe even materialized!) spreadsheet files served by Teid itself, somehow: there's jdbc, odbc, webservices, odata... could "spreadsheet" be added?
A basic spreadsheet "table" could be more than enough, in most cases, nothing fancy and complicated to define.
I could retrieve the raw "xls" file from teiid, generated form a query on VDB, and then consume it as it is or, in some cases, add bells and whistles (although I admit it would require spreadsheet libraries in my app to read/edit/save it anyway...): background colors, filters, freeze panes, etc.
Is it impossible, out of scope, unuseful, or too complicated to manage specific settings... ?
I thought of alternatives, like a java service, maybe installed aside Teiid in wildfly or on it own app server, to feed VDB data and get XLS, XLSX, ODS, through a web link, or something like that.
Like a Jasper server, querying Teiid, to fill a report which can be exported in many formats... including spreadhseet, pdf... (I know I'm stretching Teiid scope a bit but I'll try anyway, maybe you have suggestions, experiences, etc)
Do you have any other suggestion/experience? What you think?
Thanks for any comment.