Rails - Oct 2013 - Consuming a web service created with Rails, ETL vs Rest?

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

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/a06eae06-bf47-4125-a994-ec060aa2bed3%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

On 8 October 2013 14:42, Monserrat Foster
<monsefoster-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> 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
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

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLsAjwNEivjq8G5_2Yw3wb2FArthu7LrJJEi_DDTq1zJ3g%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

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 Tuesday, October 8, 2013 9:48:34 AM UTC-4:30, Colin Law
wrote:
>
> On 8 October 2013 14:42, Monserrat Foster
<monse...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:>>
> wrote: 
> > 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 
>
> 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 
>
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/75c067f5-a695-4a53-ac75-f5a5c3b285bb%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

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 Tuesday, October 8, 2013 9:54:29 AM UTC-4:30, Monserrat Foster
wrote:
>
> 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 Tuesday, October 8, 2013 9:48:34 AM UTC-4:30, Colin Law wrote:
>>
>> On 8 October 2013 14:42, Monserrat Foster
<monse...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>> > 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 
>>
>> 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 
>>
>
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/6ee885c6-9b25-447a-914d-c1aada2e3633%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

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.

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/6cf7215bdf680ed5ca33612c4cb6dd31%40ruby-forum.com.
For more options, visit https://groups.google.com/groups/opt_out.

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 Tuesday, October 8, 2013 11:17:20 PM UTC-4:30, Ruby-Forum.com User
wrote:
>
> 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. 
>
> -- 
> Posted via http://www.ruby-forum.com/. 
>
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/5614b684-0e32-4dcd-abce-ba51e37251c7%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

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.

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/ed3e4de964b4d47d20b13c045f17582a%40ruby-forum.com.
For more options, visit https://groups.google.com/groups/opt_out.