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
