June 22, 2011 at 11:58 am
Ok, don't ask why as I've already gone down this path but I've been tasked with using SSIS to import data from CouchDB into our SSAS database for cube updates.
Has anyone used SSIS to import from CouchDB or another noSQL engine? Any recommendations?
Don
June 22, 2011 at 4:34 pm
im not familiar with document based database systems, but from my limited experience, I would imagine that you would need at least to find an ODBC driver for couchDB.
Outside of that, as couchDB seems to use Java and JSON, you would have to come up with a custom solution.
Perhaps an app that makes a http request to the database, which then returns the data which you store as a flat file, and import it via SSIS that way.
June 23, 2011 at 9:38 am
Apparently you can hit a couch database with the http connection manager in SSIS and at the same time hit an xml view from couch in order to import so that's the direction I'll be going in for now.
Are there any SSIS guru's out there that would be willing to answer my fumbling questions on a one on one basis (remote mentoring) as I build this thing? I'd try not to take up too much of your time but it would be nice to have a consistent person to whom I could go with my questions.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply