I've seen some discussion in the forum here and haven't seen a lot recently but hoping some may have made discoveries in the last year.
We're about to go live on CS Industrial Enterprise. Using Birst in areas where we need analytics. Using Excel dumps where a single-domain data dump is appropriate.
When we need simple fast-turnaround multi-table tabular data dumps or have urgent, complex ad hoc needs, we're feeling the squeeze.
We've configured the latest JDBC driver and ZappySys JDBC-ODBC Bridge and that seems to work, however - two questions:
1) Any fairly long string seems to map as a string with a length of -1, which MS Office products do not like. (See metadata passed along by the driver below.) This can be resolved by casting the column to another datatype but this is awkward. Has anyone else experienced this?
2) It would be wonderful if there was a cloud platform (ideally) or a desktop product which natively supports JDBC connections and would allow us to create, save, possibly format, possibly schedule and email - queries against the data fabric.
We're not trying to eliminate native LN reporting tools. We're not trying to replace Birst - we're trying to satisfy the use case of short-lead time ad-hoc or detailed utility data extract from LN for use on a limited basis by knowledge workers who know what they're doing.
Any suggestions welcome!!
Thanks,
David
String Length Issue: Metadata shown by Zappysys Driver
[
{
"Name": "dsca",
"Type": "String",
"Length": -1
}
]
