To homepage To homepage
Solved

Connecting to Amazon Timestream Database

  • 12 April 2023
  • 5 replies
  • 135 views
P
Rank
Userlevel 3
Badge +1

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

icon

Best answer by rory.smith 14 April 2023, 14:28

View original

5 replies

Thomas Lind
Rank
Userlevel 6
Badge +5

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.

P
Rank
Userlevel 3
Badge +1

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

rory.smith
Rank
Userlevel 6
Badge +7

@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
Rank
Userlevel 6
Badge +5

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.

 

P
Rank
Userlevel 3
Badge +1

Hi,

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

Reply


Terms and ConditionsCookie settings