Splunk DB connect connection to AWS Athena. Does anyone used that yet?
Splunk DB Connect supports DB2/Linux, Informix, MemSQL, MySQL, AWS Aurora, Microsoft SQL Server, Oracle, PostgreSQL, AWS RedShift, SAP SQL Anywhere, Sybase ASE, Sybase IQ, and Teradata
---
An upvote would be appreciated if this reply helps!
@venkatasri No its not like that, DB connect can also use with other DB as well like Mongo.
Please find the below statement:
In addition to the supported databases that Splunk has tested and certified for use with DB Connect, you may also be able to use unsupported JDBC-compatible databases with Splunk DB Connect. You will need to provide the necessary JDBC drivers to add your own database types. For more information, see Install drivers for other databases.
https://docs.splunk.com/Documentation/DBX/3.7.0/DeployDBX/Installdatabasedrivers
Thanks @vishaltaneja070 that's interesting to know! You should definitely able to connect to Athena using dbconnect. There is a jdbc driver available which you can download here - https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html
you will find jdbc connection string here - https://aws.amazon.com/premiumsupport/knowledge-center/athena-iam-jdbc-driver/