It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×11,992
×1,235

question asked: May 27 '16, 4:19 a.m.
question was seen: 1,875 times
last updated: May 27 '16, 10:56 a.m.

Related questions

Rational Insight: How to query data from REST API (JSON)?

0
Timur Markunin (649●5●166●146) | asked May 27 '16, 4:19 a.m.
 Hello,

I'm going to create my own ETL job for UrbanCode Deploy data. UCD has REST API that returns data in JSON format. Is it possible to connect DataManager with JSON based REST API data source?

-Thanks in advance

Accepted answer

0
permanent link
Steve Mulligan (176●13●21) | answered May 27 '16, 10:56 a.m.
I have not seen any way to do this with DataManager.   However, you could use another ETL tool to bring the UCD data into the same warehouse.

I have used Pentaho Data Integration (Kettle) to bring other data sources into my warehouse.  It is open source and supports many data sources, including a JSON based REST API data source.

The following are links to documentation on it:
http://wiki.pentaho.com/display/EAI/Latest+Pentaho+Data+Integration+%28aka+Kettle%29+Documentation
http://community.pentaho.com/projects/data-integration/

The following is a link on accessing CouchDB data as a JSON REST API data source:
http://www.nathanhoeft.com/2012/03/24/couchdb-and-pentaho-data-integration/


Timur Markunin selected this answer as the correct answer

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.