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
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?
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.
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)
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.
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)
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.
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
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.