on 10-17-2014 4:25 PM
Does Crystal Reports 2008, 2011, or 2013 support reading data from online JSON feeds as it can with XML feeds? In other words, can I build a report using an online JSON data source?
If the JSON data source is MongoDB, there is a solution from DataDirect (connectivity partner for Crystal Reports): https://www.progress.com/data-sources/mongodb
Regarding XQuery, I have contact the product manager to respond to this thread on XQuery and JSON support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am currently accessing a JSON (BSON) data base called MongoDB with an ODBC connector. Currently there are two that I am evaluating - RSSBus ADO.NET Data Providers, (http://www.rssbus.com/ado) and Simba Technology (www.simba.com).
The Simba ODBC connector can go down 7 levels of nested records for reading and 5 levels for writing. RSSBus ODBC can go down 3 levels, although I have only used the first level.
In any case, using either ODBC connector feeds the data to Crystal as though it is a flat file.
One word of caution. Since JSON (non-SQL data base records) typically have a very high volume of data, try to avoid using formulas and data manipulation at the client end. Get the query to give you what to need, otherwise it might be slow.
Richard Sigrist
Northern Light SinglePoint
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Matthew,
right now, only crystal reports for enterprise via the restful services sdk.
https://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp6_cr_restful_ws_en.pdf
-jamie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
p.s. not sure if datadirect xquery (progress) would allow you to connect crystal (2008 etc.) to json or not...the cr installation does come with a bunch of datadirect drivers but not this one. you would need to contact progress to find out if that would work if you can't get verification on this forum from someone that's tried it.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.