[
https://issues.redhat.com/browse/TEIID-6015?page=com.atlassian.jira.plugi...
]
Nayan Bija updated TEIID-6015:
------------------------------
Description:
We need to read GCP storage CSV file data using SQL query.
we are following the steps maitined in - TEIID-5940 ticket.
As suggest by [~shawkins] we have updated or Teiid to 15.x version.
As suggested in the ticket, we have configured oauth2 in GCP and configured 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</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 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 above configuration.
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 GCP storage CSV file data using SQL query.
we are following the steps maitined in - TEIID-5940 ticket.
As suggest by [~shawkins] we have updated or Teiid to 15.x version.
As suggested in the ticket, we have configured oauth2 in GCP and configured 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</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 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 above configuration.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)