Our need is to extract data from relational databases and load it into MarkLogic.
One way is to extend XQuery so it can query relational databases and pull their data directly into MarkLogic. This would be great for MarkLogic developers. It would also be natural for XQuery to take the tabular data returned from relational databases and transform it into XML. One way is to use an external application, such as an ETL tool, to push relational data into MarkLogic. Such a tool would connect to relational databases, extract relational data, and then push it into MarkLogic. Since most external applications are good at using ODBC, it would be convenient for them to leverage MarkLogic's ODBC driver to do inserts, updates, and deletes into MarkLogic. This would be the preferred way for BI engineers who want to use MarkLogic as a data warehouse. They would see MarkLogic as simply another type of "relational" database they could work with. This is a big win for organizations like ours who have dozens of BI engineers who are expert at using ETL tools to extract, transform, and load data. Either of these approaches would work for us. ------------------------------ Date: Thu, 18 Apr 2013 21:47:06 +0000 From: David Lee <[email protected]<mailto:[email protected]>> Subject: Re: [MarkLogic Dev General] RFE: Allowing the ODBC connector for MarkLogic to insert/update/delete records. To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> Could you clarify this for me ? In the first sentence you are asking for ODBC to do insert/update/delete but the rest of the use case describes XQuery, which suggests you want SQL access from within XQuery (without the server requirement of mlsam) ... So I am a little confused where you would like the feature. Thanks. David Lee Lead Engineer MarkLogic Corporation [email protected]<mailto:[email protected]> Phone: +1 812-482-5224 Cell: +1 812-630-7622 www.marklogic.com<http://www.marklogic.com/<http://www.marklogic.com%3chttp:/www.marklogic.com/>> ------------------------------------ Mike Bowers Sent: Thursday, April 18, 2013 5:41 PM To: [email protected]<mailto:[email protected]> Subject: [MarkLogic Dev General] RFE: Allowing the ODBC connector for MarkLogic to insert/update/delete records. We would like to submit a Request For Enhancement to MarkLogic. We would like the MarkLogic ODBC connector to be able to insert/update/delete records. We have several teams at LDS that are asking for this feature. The primary use case is for applications to be able to use XQuery to query documents along with relational and dimensional data, such as user profiles, geo-political data, custom data from other relational databases, etc. Only when the data is in MarkLogic can we leverage MarkLogic's indexes to quickly answer questions. For example, most of our applications store documents in MarkLogic and we build custom XQuery applications to deliver this content to the web. Often, these applications need data from relational databases. Since there is no easy way in an XQuery application to pull or push relational data into MarkLogic, we typically do without the data or we write the application in Java or .NET. When we use Java or .NET to build an application, we tend not to use MarkLogic and live with Oracle Context indexes for our text needs. In a few cases we have gone to the effort to build web services on top of our relational data so MarkLogic can consume this data, but this is enough work that most developers prefer to build the app without including MarkLogic. In other cases we have used MLsam, but that requires another server, which increases our support cost and decreases our availability. NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
