-
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..
-
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.
-
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?
-