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

File as a datasource in teiid.

Kulbhushan Chaskar 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.

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..
Like (0)

Actions
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.
Like (0)

Actions
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?
Like (0)

Actions
4. Re: File as a datasource in teiid.

Ramesh Reddy Sep 12, 2016 9:32 AM (in response to Kulbhushan Chaskar)

Another example With Teiid data vartulization; read file which is located on remote machine
Like (0)

Actions

Go to original post

JBossDeveloper

File as a datasource in teiid.

1. Re: File as a datasource in teiid.

2. Re: File as a datasource in teiid.

3. Re: File as a datasource in teiid.

4. Re: File as a datasource in teiid.

Actions

Related Issues

More Like This

Legend