On Thu, 12 Jan 2012 01:44:03 -0800, Jakob Fix <[email protected]> wrote:
> Hi, > > I remember that at last year's user conf a presentation was made by > somebody from MarkLogic using the tableau BI software > (tableausoftware.com). I was wondering if somebody can share more > information about the connectivity that was used to get the data from > MarkLogic. > > Thanks, > Jakob. > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general It was a pilot experiment, which we showed off to see what kind of interest there might be in such an integration. As a technical matter, we created a foreign data wrapper in Postgres (this depended on APIs in the WIP PS 6.1) that mapped the relevant part of the query into an http request to a particular XQuery module on an appserver in MarkLogic. This XQuery then returned the results as CSV or something similar, which the wrapper then parsed into row structures for Postgres. It isn't terribly scalable, and for demo purposes we ended up making the target XQuery fairly stupid. I would be happy to share the code with you, if you like, although you should take it as a sample/demo/ starting point, not ready for prime time in the least. I would be happier to hear more about your use case, because we would like to understand what people really want/expect out of such connectivity so we know we will be meeting those needs when we implement it in the product. Cheers //Mary Mary Holstege Principal Engineer Mark Logic Corporation 999 Skyway Drive Suite 200 San Carlos, California 94070 [email protected] www.marklogic.com This e-mail and any accompanying attachments are confidential. The information is intended solely for the use of the individual to whom it is addressed. Any review, disclosure, copying, distribution, or use of this e-mail communication by others is strictly prohibited. If you are not the intended recipient, please notify us immediately by returning this message to the sender and delete all copies. Thank you for your cooperation. _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
