[teiid-issues] [JBoss JIRA] (TEIID-5940) How to connect GCP bucket using Teiid

[Steven Hawkins (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14172603#comment-14172603 ] 

Steven Hawkins commented on TEIID-5940:
---------------------------------------

Create a webservice datasource and set the endpoint config property to the GCP service url - http://teiid.github.io/teiid-documents/master/content/admin/Web_Service_Data_Sources.html

Create a vdb that uses the amazon-s3 translator against the datasource you created.  This will look very similar to what is shown on http://teiid.github.io/teiid-documents/master/content/reference/r_amazon-s3-translator.html

Modify the TEXTTABLE parsing from that example to handle the ingest of the csv file: http://teiid.github.io/teiid-documents/master/content/reference/r_texttable.html

> How to connect GCP bucket using Teiid
> -------------------------------------
>
>                 Key: TEIID-5940
>                 URL: https://issues.redhat.com/browse/TEIID-5940
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>            Reporter: nayan Bijagare
>            Assignee: Steven Hawkins
>            Priority: Major
>              Labels: GCP_BUC, jdbc-connector, team-service-2
>   Original Estimate: 3 days
>  Remaining Estimate: 3 days
>
> We need to read flat file or CSV file tabular data using Teiid. 
> We couldn't find any JDBC driver by using it we can establish the connection with the GCP Bucket.
> Could you please suggest us any solution how to connect to GCP bucket using Teiid.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)