trying to connect kairosdb with webservice addapter and odata translater

[anantha_gottipati]

Hi,

         I am trying to connect kairosdb with webservice addapter and odata translater.

In this process i added rosurce addapter with endpoint(http:/host:8080) and created xxx-vdb.xml like this

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<vdb name="kairosvdb1" version="1">

<property name="importer.schemaNamespace" value="System.Data.Objects"/>

<property name="importer.schemaPattern" value="NetflixCatalog"/>

    <model name="kairosdb">

        <property name="importer.importKeys" value="true"/>

        <property name="importer.importProcedures" value="true">

         <source connection-jndi-name="java:/wsDS" name="kairos-connector" translator-name="odata"/>

    </model>

    <translator name="odata-override" type="odata">

<property name="SupportsOdataFilter" value="false"/>

</translator>

</vdb>

It is deployed successfully.

can any one help me on this questions:

1.This odata translater will support kairosdb or not?

2.How to check vdb created successfully or not?

3.How to execute querry on this, because kairosdb will take the query in json format and the result in json. How to do this now?

Thanks in advance .

[rareddy]

Anantha,

1) Why you choose "odata" as translator for your "kairosdb" source in the Teiid's VDB? Did you read any where that "Kairoddb" supports OData interface on top? If yes, please provide any such links. Otherwise I have no knowledge of OData support on "KairosDB", a quick google search did not reveal any thing either. In order for you to use "odata" as translator for the store you are reading, that source must support "odata" protocol.

2) Check the log, check the console messages, there is a web-console application to check the health. There are various avenues to figure out if the VDB deployed and active or not.

3) Once the sources are configured correctly and the VDB is deployed in the active state, you can use Teiid's JDBC driver and connect to the VDB just as you can do to any other database like Oracle, DB2 etc. Then you can issue queries using that. Or if you want ODBC there is also driver for that.

>because kairosdb will take the query in json format and the result in json. How to do this now

Most probably you need to develop a custom translator for KairosDB in Teiid. During the implementation of this translator, you will have to write code that can take SQL language object, and convert to a JSON based query that KairosDB can understand. Once you have that, then you can issue SQL queries on top, then those will be converted to JSON using this translator before sending the request to KairosDB.

HTH

Ramesh..

[anantha_gottipati]

Hi Ramesh,

         Thanks for reply.

In this doc i found like

The Open Data Protocol (OData) is a data access protocol built on core protocols like HTTP and commonly accepted methodologies like REST for the web.

http://blogs.msdn.com/b/leohu/archive/2013/10/05/odata-and-json-payload-examples.aspx

In kairosdb will query from REST clients. I thought it may help for kairosdb.

I am new to teiid, just i am checking it will suit this case or not. can you please help me on this.

[rareddy]

Anantha,

If "KairosDB" has REST interface you can use "webservice" translator, with which you can issue HTTP calls. However, you can *NOT* use OData. OData is built upon REST API, but the call semantics are defined by a OASIS standard, so you can not use as generic REST client.  I suggest, you go through example like Web Services as a Data Source Example - Teiid Examples - Project Documentation Editor that shows how to use a web-service translator aginst some source and how to convert XML returned data. You can do similar with JSON data using JSONTOXML function JSON Functions - Teiid 8.7 (draft) - Project Documentation Editor with KairosDB.

The difference between above method and custom translators is, the above using web-service translator you need to create a virtual view or virtual procedure for each query and write transformation like above example to define it. Where as translator would know to handle much more than single query, and it can expose source metadata to build on top of. Depending upon your usecase, the above method may suffice. I suggest, you learn some basic examples of how Teiid works, then decide which is more suitable for your usecase.

Some other examples on web-service traslator

https://access.redhat.com/site/sites/default/files/attachments/consumerest-ws-datasource_version2.pdf

http://teiid.blogspot.com/2010/08/convert-xml-data-into-relational-table.html

Ramesh..

[anantha_gottipati]

Thanks Ramesh,

[anantha_gottipati]

Hi Ramesh,

            Webservice translater is not working for me, we need to develop custom translater and adapter.

we are using kairosdb with Cassandra data store. will insert and retrieve data into db in json format. For insert and query we can use different ways like chrome advance rest client, chrome postman apps and also with telnet api.

http://code.google.com/p/kairosdb/wiki/GettingStarteda

we need to develop custom adapter and translater. can you please help me in writing those.

[rareddy]

Anantha,

Let's continue the discussion here Re: Teiid Connector Example there is another request for KairosDB

Ramesh..