[
https://issues.redhat.com/browse/TEIID-6017?page=com.atlassian.jira.plugi...
]
Steven Hawkins resolved TEIID-6017.
-----------------------------------
Resolution: Explained
From this and other issues it's clear that you are trying to do a
lot all at once with a low familiarity with Teiid. It would help if you could start from
either a smaller working example or build up incrementally - so that you can isolate what
exactly isn't working for you.
For example you can start with a dummy vdb to verify you can connect and query. Then you
can add a source model to your vdb and verify that it error out when looking for the
datasource, then you can add your datasource.
Example dummy vdb in ddl:
{code:java}
CREATE DATABASE DUMMY;
USE DATABASE DUMMY;
CREATE VIRTUAL SCHEMA S1;
SET SCHEMA S1;
CREATE VIEW V as SELECT 'HELLO WORLD';
{code}
*_"_*_org.teiid.jdbc.TeiidSQLException: TEIID20018 Unable to
find a component used authenticate on to Teiid_*_"_*
That is not related to anything about sources or translators. It probably indicates
something is wrong with the Teiid install - did you use a full kit including wildflyor an
overlay? If an overlay, which teiid version and wildfly version - as they are not
independent.
Not able to connect GCP bucket using S3 translator
--------------------------------------------------
Key: TEIID-6017
URL:
https://issues.redhat.com/browse/TEIID-6017
Project: Teiid
Issue Type: Feature Request
Reporter: Nayan Bija
Assignee: Steven Hawkins
Priority: Major
As suggested in the ticket TEIID-6015
We have tried to connect the GCP bucket using the S3 translator(not amazon-s3).
As mentioned, S3 doesn't support google authentication,
so we have created access key and secret key of Google bucket by logging into the GCP
accoudnt.
We have followed below steps to create access key and secret key.
_*Storage->Setting->INTEROPERABILITY-> Service account HMAC->Create a key for
service account"*_
We have also created below adapter file and VDB but still, we are not able to connect to
GCP.
<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="bucket">abc</config-property>
<config-property
name="endpoint">[https://storage.googleapis.com|https://stor...
<config-property name="secretKey">xxx</config-property>
<config-property name="accessKey">xxx</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
VDB
----
<?xml version="1.0"?>
<vdb name="gcp" version="1">
<connection-type>BY_VERSION</connection-type>
<model name="s3">
<source name="web-connector" translator-name="amazon-s3-custom"
connection-jndi-name="java:/s3DS"/>
</model>
<translator name="amazon-s3-custom" type="amazon-s3">
<property name="accesskey" value="xxx"/>
<property name="secretkey" value="xxx"/>
<property name="bucket" value="abc"/>
</translator>
</vdb
as we tried to connect we are getting below error.
*_"_*_org.teiid.jdbc.TeiidSQLException: TEIID20018 Unable to find a component used
authenticate on to Teiid_*_"_*
In the above configuration, where should we mention the File name?
As I have read the properties in the documentation, I could see bucket property, where we
can add a bucket name. but where should we add the file name which is present in the
bucket?
Could you please help us with it?
--
This message was sent by Atlassian Jira
(v7.13.8#713008)