Skip to main content
Solved

Connecting to Amazon Timestream Database

  • April 12, 2023
  • 5 replies
  • 222 views

Forum|alt.badge.img+2

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

Best answer by rory.smith

@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.

5 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1161 replies
  • April 13, 2023

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.


Forum|alt.badge.img+2
  • Author
  • Contributor
  • 64 replies
  • April 14, 2023

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


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • 736 replies
  • Answer
  • April 14, 2023

@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.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1161 replies
  • April 17, 2023

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.

 


Forum|alt.badge.img+2
  • Author
  • Contributor
  • 64 replies
  • April 17, 2023

Hi,

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