topic How to export logs from API to SQL Database in General Topics

How to export logs from API to SQL Database

bhakti1213 — Thu, 26 Jul 2018 20:02:43 GMT

So we are looking for a way of exporting log data directly to a SQL data db? Does anyone know a way of doing this?

Re: How to export logs from API to SQL Database

BPry — Fri, 27 Jul 2018 14:31:19 GMT

That isn't going to work without a host modifying the data in the middle of the connection to the best of my knowledge. Your SQL DB doesn't know how to parse the XML, so you'll need something to actually get the information via the API, parse the response, and then feed the information into the proper SQL table.

Re: How to export logs from API to SQL Database

RobinClayton — Tue, 31 Jul 2018 15:48:38 GMT

I am working on this but not using the API.

I backup all my traffic logs to a Linux box, and have a script that imports the logs into MYSQL.

Work in progress though.

Re: How to export logs from API to SQL Database

BPry — Tue, 31 Jul 2018 17:19:41 GMT

@RobinClayton,

Either the API or exporting the logs to a different Syslog server would be great answers for something like this. If you're more comfortable with XML then I would recommend using the API. If you are more comfortable with Syslog (as many likely are) then that side of things makes more sense. Either solution essentially gives you the result you're looking for @bhakti1213.