Forum: Ruby on Rails Consuming a web service created with Rails, ETL vs Rest?

5a41028798f4e263c2d0692f5b1847ec?d=identicon&s=25 Monserrat Foster (Guest)
on 2013-10-08 15:43
(Received via mailing list)
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
5f94b9b346c2aa648a80bc259978e5bc?d=identicon&s=25 Colin Law (Guest)
on 2013-10-08 16:21
(Received via mailing list)
On 8 October 2013 14:42, Monserrat Foster <monsefoster@gmail.com> 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 [1].
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?

[1] http://en.wikipedia.org/wiki/Extract,_transform,_load

Colin
5a41028798f4e263c2d0692f5b1847ec?d=identicon&s=25 Monserrat Foster (Guest)
on 2013-10-08 16:25
(Received via mailing list)
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.
5a41028798f4e263c2d0692f5b1847ec?d=identicon&s=25 Monserrat Foster (Guest)
on 2013-10-08 16:27
(Received via mailing list)
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)
280b78a61a968391b7e07e912be102a8?d=identicon&s=25 Robert Walker (robert4723)
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.
5a41028798f4e263c2d0692f5b1847ec?d=identicon&s=25 Monserrat Foster (Guest)
on 2013-10-09 15:22
(Received via mailing list)
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
280b78a61a968391b7e07e912be102a8?d=identicon&s=25 Robert Walker (robert4723)
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.
Please log in before posting. Registration is free and takes only a minute.
Existing account

NEW: Do you have a Google/GoogleMail, Yahoo or Facebook account? No registration required!
Log in with Google account | Log in with Yahoo account | Log in with Facebook account
No account? Register here.