Hi- I used to work for Actuate, a company whose main product was a reporting tool called BIRT. BIRT is an open source, top level Eclipse Foundation project that is used by over 3 million developers around the world. You can download it for free. Many companies from IBM to Workday have written commercial applications with BIRT. I recommend googling Eclipse BIRT to learn more.
One of the strengths of BIRT is the ability to combine result sets from different databases into one report. It sounds like it fits your use case fairly well. BIRT also does document-centric Business Intelligence so you can just create MarkLogic result sets with the REST api. I have also written a MarkLogic BIRT data source that can use documents as result sets. The code is not production ready but I would be happy to share it with you. You can find it in GitHub under the user billjclark. I would be happy to help set up a couple of sample reports for you. Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Joel Wilson Gunasekaran Sent: Wednesday, September 09, 2015 4:56 PM To: MarkLogic Developer Discussion Subject: [MarkLogic Dev General] Recommended ODBC clients for MarkLogic Hi, Currently we are aggregating data from multiple source and storing them into MarkLogic for servicing client requests. The data quality team within the organization would like to perform analysis on the data that ends up at MarkLogic by connecting to the MarkLogic ODBC server and the other input systems like SQL Server, etc. to reconcile. Have anyone used ODBC clients other than Tableau for connecting to multiple data sources(including MarkLogic) to perform validation/analysis? If so, can you please provide suggestions? Thanks Joel _______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
