Re: [teiid-users] Question on text connector connecting to files remotely located on linux server directory
Did you use the same iRod server when you used it in the Designer? If
you did, how did you supply the userid and password?
Going to a browser and typing in the URL, do you see that you are
challenged with the authentication? If "yes", then your source file is
definitely requires secure access. You can not login first and expect
the next call to work with previous call's security credentials.
Text connector does not support any security negotiation with its URL
protocol. Or you have to find another way (may be an external script) to
fetch the file from your iRod server and place it in location that can
be reached by Teiid server.
In 7.0, this may be possible using the "connector-ws" connector for
access, this is connector is designed for XML files. Is your data file a
XML file?
Hope this helps.
You can use Teiid's user forums
( http://community.jboss.org/en/teiid?view=discussions ) for your next
questions as it is easier to search and navigate than mailing lists.
Thanks
Ramesh..
On Thu, 2010-06-03 at 21:42 +0000, Hong Yi wrote:
Thank you very much for your reply, Ramesh. It is very helpful. I am
able to connect to date exposed through a web server via "http:" in teiid
designer, but fails to connect to data exposed in iRODS web client server via http. There
are two possible issues: one is http url needs password authentication before getting to
data; the other is data replication exposed by iRODS server (i.e., each data is replicated
multiple times in different resources so the same data was exposed as multiple entities
with the same data file name). I worked around the first issue by logging in to URL first,
then connect to the url that will bypass the password authentication part, but it still
fails, so the second issue might be a problem also for teiid to connect to iRODS data via
http. Any suggestions on whether there is a way for teiid to handle this scenario will be
much appreciated.
I have a general architectural type of question to ask related to this question, but
I'll start another thread for the purpose of clarity.
Thanks again for your help - I really hope I can have positive results to report after my
investigation on teiid so that we can bring teiid in as a middle data layer to interface
with web applications in our project.
Hong
-----Original Message-----
From: Ramesh Reddy [mailto:rareddy@redhat.com]
Sent: Thursday, June 03, 2010 8:39 AM
To: Hong Yi
Cc: teiid-users(a)lists.jboss.org
Subject: Re: [teiid-users] Question on text connector connecting to files remotely
located on linux server directory
On Tue, 2010-06-01 at 15:07 +0000, Hong Yi wrote:
> From the connector dropdown list, I see I can use JDBC and ldap
> connectors, but do not see connectors using ssh or http protocol.
> Could you let me know whether there is a way to connect to source data
> files remotely located in a linux server?
If you provide a *valid* URL that can reach your remote file it will
work. Teiid does not care about what protocol you are using.
- Is the file on a remote server can be reached by "file://" protocol?
- is it on shared drive and you have the path?
- To use "http:" is the file have to be exposed though a web server
any of above will work, you would need that valid URL to the file.
Thanks very much you for your interest in Teiid. Let us know how we can
help.
Ramesh..