Pulling Data from a MS_SQL table into FortiSIEM

[GidonT]

Hi Dear Community, 

I have a need to pull data from a MS_SQL DB from a specific Table with a specific query into FortiSIEM. 
I have read all documentation of "External Systems Configuration Guide"
https://docs.fortinet.com/document/fortisiem/7.0.2/external-systems-configuration-guide/723635/micro...


in the documentation above it doesn't seem like there is an option to pull specific data from a specific table but rather only auditing and monitoring of the DB. 

Does anyone have any suggestion or a guide on how to pull data from an MS_SQL DATABASE
DataBase name : X_DB
Table name: Y_Table

[soltantde2]

I am not sure what you mean by extraction tool? Usually, you would have connectors to data sources which have a driver and usually, the most used one with SQL DBs is the ODBC Driver

[GidonT]

@soltantde2 i never mentioned any "extraction tool".

as mentioned in the question - 
I need to pull data from a specific table in a specific database in MS SQL SB. 
do you have any suggestions ? 

[FSM_FTNT]

Have a look at the documentation herehttps://help.fortinet.com/fsiem/7-2-3/Online-Help/HTML5_Help/Custom-JDBC-Performance-Monitor-for-a-C...