How to extract data from Athena (AWS) to make dashboards or reports with that data in ServiceNow?.

[Alessa]

Hello dear community, I need help:

I have data in the Athena database (AWS). I need to know how I can extract that data, so I can make dashboards in ServiceNow using JDBC connection and AWS credentials.

Does anyone have experience that can tell me how I can do this?

Thanks in advance

[Abhay Kumar1]

Hi Alessa, Please check below article if that helps. https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-sets/task/create-jdbc-type-data-source.html

[bammar]

Hi Alessa, in addition to the other option which may be more relevant- if you have any type of excel spreadsheet you can import the data into servicenow- by virtue of its existence you can then report on it and set up reports.... 

So my answer is if its a one time deal- extract all data import it into servicenow and report on it- however if more data is going to be sent over time an integration to populate the new records in the destination table is necessary.... 

this is such an abreviation and short version of the work necessary to set this up but everything is possible.