Extracting data from a table in mySQL | Log collection solutions

#1 DC_475094 3 years ago

Hope someone can provide some pointers.

I have an application that uses mySQL database and it is installed on Windows Server 2019. I just downloaded NXLog CE on the same Windows Server 2019. I am new to this but the goal is to extract a table from mySQL and output it as JSON format so that I can ingest it to another platform. Appreciate if someone can point me to the right direction to make this work.

Thanks !

Permalink

#2 rafDeactivated Nxlog ✓ 3 years ago

#1 DC_475094

Hope someone can provide some pointers. I have an application that uses mySQL database and it is installed on Windows Server 2019. I just downloaded NXLog CE on the same Windows Server 2019. I am new to this but the goal is to extract a table from mySQL and output it as JSON format so that I can ingest it to another platform. Appreciate if someone can point me to the right direction to make this work. Thanks !

Hello,

For this purpose, I'd rather suggest trying out the EE version.

The modules you're looking for are im_dbi - if you can switch to Linux, or if you're stuck with Windows, you might go with im_odbc.

So, two pointers with direction, hope it helps :)

Best,

Rafal