Skip to main content

Is it possible to connect to an Amazon Timestream database (https://aws.amazon.com/timestream/) with the ODX?

Hi Pontus

There is no specific timestream data source. I could not work out what it actually was, but we can connect to some AWS RDS types with an MsSQL provider and similar.


Hi Thomas, thank you, we will try around with different SQL providers. I will post here if we find any that work. 


@pontus.berglund as far as I am aware there is a REST api which may be rate limited and JDBC drivers to connect and fire SQL at it. The JDBC driver would probably mean using an ODBC-JDBC bridge to use ODBC as a way to connect it to TimeXtender. I don't think there are any free ODBC-JDBC bridges, only the other way around.


Hi @pontus.berglund 

The bridge option are not available in TX, at least not through normal CData.

If there is a REST API, it would be possible to use the REST provider as long as it can connect to an URI of some sort. The authentication will be possible then.
I found this on their webpage

https://docs.aws.amazon.com/timestream/latest/developerguide/API_query_Query.html

It seems like you need to do a post call to get the response back, but there is no info besides that. To me it seems unlikely that it will work with a REST data source.

 


Hi,

Thanks for the additional info. I will try the suggestions once we have been given access to the timestream db. 


Reply