Replicating data to MS SQL Server
I was looking for an off the shelf solution to replicate data to an MS SQL server as a dataware house to run our reports (SSRS etc). Finally, i was thinking of writing a new plugin in the lines of elastic search transport plugin and configure it in the XDCR section. Is there any better way to do it ? TAP?
i want to use the sql server as a datawarehouse so that i keep only the latest versions of the documents in the cache and leave all others in the SQL DB and then load them to cache if there is a need. is there any MORE documentation on this project ?
Hello,
Today we do not have more documentation about using XDCR and CAPI to integrate Couchbase with other systems.
We are planning to write a technical article for developer about it once we release Couchbase 2.0
Regards
Tug
Hello,
Do you really have to move the data out ouf Couchbase for this requirement?
But if you want to do it, I think that the XDCR approach is quite nice to do, that uses this project:
https://github.com/couchbaselabs/couchbase-capi-server
It is probably easier than TAP and does not impact the running system.
Tug
@tgrall