Splunk DB connect connection to AWS Athena

[vishaltaneja070]

Splunk DB connect connection to AWS Athena. Does anyone used that yet?

[venkatasri]

Hi @vishaltaneja070 

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!

[vishaltaneja070]

@venkatasri  No its not like that, DB connect can also use with other DB as well like Mongo.

Please find the below statement:

Other databases

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

[venkatasri]

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/