[teiid-users] Question on text connector connecting to files remotely located on linux server directory

[Hong Yi]

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 at redhat.com] 
Sent: Thursday, June 03, 2010 8:39 AM
To: Hong Yi
Cc: teiid-users at 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..