-
1. Re: File as a datasource in teiid.
Ramesh Reddy Sep 7, 2016 9:34 AM (in response to Kulbhushan Chaskar)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.
Kulbhushan Chaskar Sep 8, 2016 2:23 AM (in response to Ramesh Reddy)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.
Marco Ardito Sep 8, 2016 3:08 AM (in response to Kulbhushan Chaskar)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?
-
4. Re: File as a datasource in teiid.
Ramesh Reddy Sep 12, 2016 9:32 AM (in response to Kulbhushan Chaskar)