With Teiid data vartulization; how to connect to google cloud bucket?

[pranitag]

I am new to teiid, In our project we are using teiid to connect to different databases.

we have new requirement to connect to google cloud bucket Is there any driver or translator provided by teiid which we can use to connect to google cloud bucket?

Thank in advance

Pranita Gurav

[rareddy]

Pranita,

Welcome to Teiid community.

Unfortunately, there is no translator currently available for the Google Cloud Bucket. Looks like it is rest based api, so you could either use the REST translator or write one yourself, probably by extending web services translator.

Can you enter JIRA into Teiid JIRA, but I doubt it will be picked up anytime soon.

Ramesh..

[pranitag]

Thanks Ramesh,

I will try to connect to bucket using suggestion given by you.

Actually requirement is to connect to file kept at Google cloud Bucket and query on file  data and get the result..

Currently we have added hxtt driver in teiid to connect to file using (ftp and sftp connections) kept at remote location and file translator query on file data .

On the same line we need to connect to file kept at Google cloud bucket and apply sql queries to get the result.

Can you suggest me on the same.

Thanks in advance.

[rareddy]

Pranita,

You can take look at AWS S3 translator, as that is the closest one, where we use a customized translator with use web services resource-adapter. Take look at teiid/connectors/amazon/translator-amazon-s3 at master · teiid/teiid · GitHub

I would love to see this contributed back to the Teiid community when you have it developed, that way we can keep it updated, version to version.

Ramesh..