Using a secure REST endpoint (Cookie based auth) for restservice-as-a-datasource from Teiid-embedded (9.0.0CR2)

[jrod2016]

Based on your very informative example: https://github.com/teiid/teiid-embedded-examples/tree/master/restservice-as-a-datasource

I wanted to know if you have an example of accessing a secure REST endpoint where you call a logon method for authentication,

get a Cookie and then use that cookie for calling the REST endpoint.

I have included sample code below on how this is done using Apache HttpClient in Java.

// Logon and Setup the Cookie store

    private CookieStore establishAdfSession() throws IOException {

        if (cookieStore == null) {

            cookieStore = new BasicCookieStore();

            HttpClient httpClient = HttpClientBuilder.create().setDefaultCookieStore(cookieStore).build();

            HttpPost httpPost = new HttpPost(String.format("%s/login", appConfig.getAdfcoreServer()));

            httpPost.addHeader("j_username", username);

            httpPost.addHeader("j_password", password);

            httpClient.execute(httpPost);

        }

        return cookieStore;

    }

// This method accesses secure endpoint : http://localhost:9080/adfcore/artifacts/53

// The cookie has been set in httpClient built by establishAdfSession

    public Map<String, Object> fetchArtifact(Integer artifactId) throws IOException {

        final CookieStore cookieStore = establishAdfSession();

        HttpClient httpClient =  HttpClientBuilder.create().setDefaultCookieStore(cookieStore).build();

        HttpGet httpGet = new HttpGet(String.format("%s/artifacts/%d", appConfig.getAdfcoreServer(), artifactId));

        HttpResponse httpResponse = httpClient.execute(httpGet);

        HttpEntity entity = httpResponse.getEntity();

        return extractResponse(entity, Map.class);

    }

How does this translate to

  FROM

  (EXEC CustomerSource.invokeHttp('GET', null, 'http://localhost:8080/customer/customerList', 'TRUE')) AS f

in your example? Could you please point me to documentation/examples of this?

[rareddy]

Look at invokeHTTP method here Web Services Translator · Teiid Documentation

Yo need to use Header parameter to set up your cookie information.

[jrod2016]

Thanks Ramesh. Will try this out.

[jrod2016]

We went on to write our own custom translator/data-source. But looking at the source code of the rest-translator definitely helped.

[shawkins]

John,

Is there anything that you would be able to share or contribute back from this?

Thanks,

Steve

[jrod2016]

Our initial data sources for teiid were the REST endpoints in the same webapp, where Teiid is embedded. That's when it seemed like the provided webservices-translator was the solution, but on further thought, we decided it would be more flexible to implement a custom translator. So, instead of calling the REST endpoint, we decided to call the service layer stuff, the REST controller was calling. This also frees us from the overhead of REST. Also, we can now define our own parameters for the exec command.

[shawkins]

Sounds good John.