CODEWITHSUNDEEP
virtualizationmarklogic
user3615683
user3615683

Reputation: 11

Data virtualization with SQL Server DB using Marklogic

I would like to use data from a SQL Server database in Marklogic without moving it physically. I have read about data virtualization in Marklogic but cannot get any example or documentation explaining how to go about it. Please point me to any reference that may help me.

I have already tried reading data using MLSAM. Is this the only way and is this virtualization?

Upvotes: 1

Views: 402

Answers (1)

grtjn
grtjn

Reputation: 20414

MarkLogic introduced the concept of Views to allow data visualization tools to connect to MarkLogic through ODBC, executing SQL against MarkLogic. These views are fed from XML content within MarkLogic through range indexes. So, I think that is the other way around for what you are looking for. In general, MarkLogic will need data inside its own databases, to allow indexing it.

MLSAM can be a way to pull such data in, executing SQL statements from within XQuery against external sources (contrary to xdmp:sql, which runs against the Views inside MarkLogic). Tools like RecordLoader, XQsync, and XMLSh might be worth looking at as well. See

http://developer.marklogic.com/code

HTH!

Upvotes: 1

Related Questions