Hi Mark, reading through the tutorial, it seems that it's possible to emit SQL statements from MarkLogic using MLSQL, but not the other way around, i.e. MarkLogic receiving SQL statements from a third party application and returning results (in XML or any other format).
Please correct me if I misunderstood. I'd love to avoid reinventing any existing wheels. cheers, Jakob. On Tue, Apr 27, 2010 at 17:20, Mark Helmstetter <[email protected]> wrote: > Another option might be to use MLSQL: > http://developer.marklogic.com/howto/tutorials/2006-04-mlsql.xqy. > > MLSQL uses JDBC. There is a JDBC-ODBC bridge driver that ships with the JDK > that you could use. > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Jakob Fix > Sent: Tuesday, April 27, 2010 3:06 AM > To: General Mark Logic Developer Discussion > Subject: [MarkLogic Dev General] MarkLogic and MS Access database > communication > > Hi everybody, > > how would one go about connecting an Access database to a MarkLogic > database for the purpose of retrieving information (read-only, no > insertion nor updates)? Is this feasible, a crazy idea, or actually > trivial? > > The background behind this question is this: We currently plan the > move of an MS SQL Server database to MarkLogic. (Of course, this means > that the data model will change considerably, from row-based data to a > hierarchical structure.) The SQL database of today has a large number > of Access databases accessing it via ODBC to retrieve data for > specialized purposes. We need to continue to provide some kind of > access to these MS Access databases. > > Thanks in advance for your help! > > cheers, > Jakob. > _______________________________________________ > General mailing list > [email protected] > http://xqzone.com/mailman/listinfo/general > _______________________________________________ > General mailing list > [email protected] > http://xqzone.com/mailman/listinfo/general > _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
