Hank, to get you started here's a set of mappings<http://developer.marklogic.com/learn/sql-marklogic-mapping> from the SQL ideas you're familiar with to the analogous item in MarkLogic. (I should note that this is due for an update.) I can also point you to MLSAM<http://developer.marklogic.com/code/mlsam>, a library used to execute SQL queries and generate XML suitable for storing in MarkLogic.
Here's a talk from 2013 about moving from Relational Modeling to XML<http://www.marklogic.com/resources/slides-moving-from-relational-modeling-to-xml-and-marklogic-data-models/>. Here's one from this year about Multi-Model Data Integration in the Real World<http://www.marklogic.com/resources/multi-model-data-integration-in-the-real-world/>. I'm sure others will chime in with additional resources. -- Dave Cassel<http://davidcassel.net>, @dmcassel<https://twitter.com/dmcassel> Developer Community Manager MarkLogic Corporation<http://www.marklogic.com/> MarkLogic World Tour: Houston, New York<http://world.marklogic.com/locations/> From: Hank Ratzesberger <[email protected]<mailto:[email protected]>> Reply-To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> Date: Thursday, June 11, 2015 at 5:47 PM To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> Subject: [MarkLogic Dev General] Transitioning from SQL Hello, We have several Oracle databases that we access through different users/schemas and even Database Links. Altogether a fairly complex data set. Our applications are mostly J2EE, so we have a lot of entities or we could create others, that are complete objects representing the "things" that the application is built on, for example, an Invoice with all its Line Item and Funding documentation. We might be able to use the Java API to iterate through these and serialize them to ML. Any white papers or case studies or your general feedback on how to reap data from an SQL database into MarkLogic would be appreciated. I've just begun to think about this, hopefully my question is not too vague and with some feedback I can narrow my questions to something more specific. Thank you, Hank --Hank Ratzesberger _______________________________________________ General mailing list [email protected]<mailto:[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
