We have downloaded the Amazon Timestream ODBC driver and created an ODBC data source configuration that includes the access key and secret access key.
We tried to create a table connection using Microsoft OLE DB Provider for ODBC Drivers and this DSN file, but we are asked for a username and password. We are not sure which credentials to provide as the access and secret access keys are already specified in the ODBC data source. Reusing these access keys as the username/password within PI AF did not work.
Does anyone have any insight into the problem? Can someone confirm that we selected the right provider for starters (Microsoft OLE DB Provider for ODBC Sources)?
Appreciate any assistance you can provide.
