4 Replies Latest reply on Sep 12, 2016 9:32 AM by rareddy

File as a datasource in teiid.

kulbhushanc Sep 7, 2016 5:22 AM

Hi,

I am trying to make connection to the file using teiid admin api, to connect to the file I am using HXTT as a jdbc driver so that I am able to fire sql queries on a file; this works well but if I am firing "getSchema" method of teiid admin api its returning schema for all files present of that directory instead of schema of only file for which I made a connection.

My opinion is about the case discussed above is connection implementation totally depends on jdbc driver and not on teiid, that's why getSchema method return schema for all files in that directory.

Thanks,

Kulbhushan Chaskar.

1. Re: File as a datasource in teiid.

rareddy Sep 7, 2016 9:34 AM (in response to kulbhushanc)

Kulbhushan,

You are not required to use HXTT driver with Teiid. Yes, if you use HXTT you will see the metadata wrt to that JDBC driver. To work with Text files in Teiid, take look at one of examples here Hello World Teiid Data Federation Example - Teiid Examples - Project Documentation Editor

See the MarketData model reading the text file in this example.

Ramesh..
Actions
2. Re: File as a datasource in teiid.

kulbhushanc Sep 8, 2016 2:23 AM (in response to rareddy)

Hello,

I have go through the link, one thing I am not able to figure out is can we access remote file by setting some properties in resource-adapter which we created for files? or is there any way to access remote file by using sftp and ftp protocol.

Thanks,
Kulbhushan Chaskar.
Actions
3. Re: File as a datasource in teiid.

m.ardito Sep 8, 2016 3:08 AM (in response to kulbhushanc)

I use this kind of resource through the Teiid server filesystem, eg: mount the remote file path somewhere, and make Teiid access that file as if it was local... (depending on performance, you could try to cache access to this file, in Teiid)

About HXTT driver issue, could you perhaps try to change permissions to make it only reach the file you need it to return the schema for?
Actions
4. Re: File as a datasource in teiid.

rareddy Sep 12, 2016 9:32 AM (in response to kulbhushanc)

Another example With Teiid data vartulization; read file which is located on remote machine
Actions

Go to original post