Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Timur Markunin
(649●5●166●146) 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

0 votes

1 answer
1,975 views
0 votes

Accepted answer

Permanent link
Steve Mulligan
(176●13●21) 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

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,020

Question asked: May 27 '16, 4:19 a.m.

Question was seen: 1,975 times

Last updated: May 27 '16, 10:56 a.m.

Confirmation Cancel Confirm