Hello, I need to consume a web service of an App called RedMine created with Rails, in order to have a sort of "separate" interface (not the same as the app) for one of the departments (that interact with the app) to interact with it and generate some different reports based on the same data. I don't know much about either (ETL and Rest), all I know is that ETL seems to NEED a database connection and Rest uses HTTP petitions to get data and the web service returns XML. What I'm wondering if It's possible to "consume" a web service with ETL? It seems to me that is not the purpose of ETL, but as i'm new to these ETL and Rest stuff i'm not really sure. Could someone please clarify this to me? I'd much appreciate it
on 2013-10-08 15:43
on 2013-10-08 16:21
On 8 October 2013 14:42, Monserrat Foster <firstname.lastname@example.org> wrote: > seems to me that is not the purpose of ETL, but as i'm new to these ETL and > Rest stuff i'm not really sure. Could someone please clarify this to me? I'd > much appreciate it I have not used ETL but the wikipedia definition of it does not suggest it is very appropriate for what you want to do . However it is not clear to me what you are wanting to do. Are you asking about how to add a web service to an existing app, or how to consume an existing web service? If it is the latter then I don't see what the question has to do with Rails as the service is already defined. As a secondary point why don't you just add the new reports to the existing app?  http://en.wikipedia.org/wiki/Extract,_transform,_load Colin
on 2013-10-08 16:25
The existing app is RedMine, I'd like a way to use their API to access certain things to generate the new reports. Bunch of departments use the app, the reports only apply to an specific department, and the administrator of the app doesn't let me "touch" anything related to database or code regarding the app and suggested the only way to do it it's with ETL. In worst case scenario, I'd create a new Rails App to interact with the API and generate the reports from there, but if there's a way I could avoid programming when there's an "easier" way to do it, I'll take that.
on 2013-10-08 16:27
It has do with rails because I'd be using an already existing rails app and probably another app with a few gems to connect to the already defined web service (IMO)
on 2013-10-09 05:47
Monserrat Foster wrote in post #1123885: > It has do with rails because I'd be using an already existing rails app > and > probably another app with a few gems to connect to the already defined > web > service (IMO) http://www.redmine.org/projects/redmine/wiki/Rest_api That explains the Redmine REST API pretty well. Have you read the documentation? What have you tried? Do you have any specific questions that you need answered? No I don't have any code to toss your way for you to "customize." A little preparation before posting to developer forums will get you a long way, and will reduced the chances of the types of responses that you see in this thread.
on 2013-10-09 15:22
I don't want any code. The gem suggested to me to use is Activewarehouse-ETL but as far as I know, this gem only allows to manip databases and the administrator for the redmine app clearly said no databases conections because 'I might damage something' so, my question was when consuming a webservice, like redmine API, but without handling databases, is it better to use REST (httparty) or ETL (ActiveWarehouse) and why
on 2013-10-09 15:46
Monserrat Foster wrote in post #1124014: > I don't want any code. The gem suggested to me to use is > Activewarehouse-ETL but as far as I know, this gem only allows to manip > databases and the administrator for the redmine app clearly said no > databases conections because 'I might damage something' so, my question > was > when consuming a webservice, like redmine API, but without handling > databases, is it better to use REST (httparty) or ETL (ActiveWarehouse) > and > why See, now that's a much more clear and concise question. With the information you have provided I would be confident in suggesting to use the REST services provided by Redmine over anything that would manipulate the database directly. There's no telling what you might break. P.S. I know you didn't ask for code. Apparently, you haven't spent much time on developer forums where many people simply want someone to provide them the solution without doing any research or trying anything themselves. That is probably the most annoying thing to veteran developers who frequent developer forums. There is a right and wrong way to ask questions on a forum like this one. The primary rules are... Research before you post, think before you post, ask a single, concise, but complete, question. Tell us what you've tried, any errors you may be seeing (with stack traces when possible), and any specific code you may be having trouble with. That will get you the answers you seek without annoying the people capable of providing good answers.