[teiid-issues] [JBoss JIRA] (TEIID-6015) GCP Storage(bucket) connection with Teiid.

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-6015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-6015.
-----------------------------------
    Resolution: Explained


> GCP Storage(bucket) connection with Teiid.
> ------------------------------------------
>
>                 Key: TEIID-6015
>                 URL: https://issues.redhat.com/browse/TEIID-6015
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Nayan Bija
>            Assignee: Steven Hawkins
>            Priority: Major
>
> We need to read CSV file from the GCP storage file using SQL query.
> we are following the steps mentioned in - TEIID-5940  ticket.
> As suggested by [~shawkins] we have updated or Teiid to 15.x version.
> and we are using Amazon-s3 translator to read the csv file from the GCP bucket.
> As suggested in the ticket,  we have configured oauth2 in GCP and configured the secret key and refresh token in security deomain. .
>  
> <security-domain name="oauth2-security">
>  <authentication>
>  <login-module code="org.teiid.jboss.oauth.OAuth20LoginModule" flag="required" module="org.jboss.teiid.web.cxf">
>  <module-option name="client-id" value="xxx.apps.googleusercontent.com"/>
>  <module-option name="client-secret" value="xxx"/>
>  <module-option name="refresh-token" value="xx"/>
>  <module-option name="access-token-uri" value="https://www.googleapis.com/oauth2/v3/token"/>
>  </login-module>
>  </authentication>
>  </security-domain>
>  </security-domains>
>  
> we have also created resource adaptor.
> <resource-adapter id="amazon-s3-custom">
>  <resource-adapter id="amazon-s3-custom">
>  <module slot="main" id="org.jboss.teiid.resource-adapter.s3"/> 
>  <transaction-support>NoTransaction</transaction-support>
>  <connection-definitions> 
>  <connection-definition class-name="org.teiid.resource.adapter.s3.S3ManagedConnectionFactory"  jndi-name="java:/s3DS"  enabled="true"  use-java-context="true"  pool-name="teiid-s3-ds"> 
>     <config-property name="endpoint">[https://storage.googleapis.com|https://storage.googleapis.com/]</config-property>
>     <config-property name="bucket">abc</config-property>
>     <config-property name="accessKey">xxxx.apps.googleusercontent.com</config-property> 
>     <config-property name="secretKey">xxxx</config-property>
> </connection-definition> </connection-definitions>
>  </resource-adapter>
>  
> Could you please review the changes and suggest to us if we are missing anything.
> and also let us inform
> 1. how to test the above configuration from the Teiid console whether it is connected to GCP bucket or not
> 2. how to create VDB and datasource from the above configuration.
>  
>  
>  
>  
>  
>  
>  
>  
>  



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