07-26-2018 01:02 PM
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?
07-27-2018 07:31 AM
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.
07-31-2018 08:48 AM
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.
07-31-2018 10:19 AM
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.
Click Accept as Solution to acknowledge that the answer to your question has been provided.
The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!
These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!
The LIVEcommunity thanks you for your participation!
