NetFlow2SQL Collectorcan be used to receive NetFlow packets from up to 10 NetFlow routers and to store their contents into up to 10 databases on Microsoft SQL Servers or/and MySQL servers. The program consists of NetFlow2SQL Collector Manager and NetFlow2SQL Collector itself which is a Windows service application.
PROGRAM DESCRIPTION
NetFlow2SQL Collector is able to receive NetFlow packets from up to 10 NetFlow routers and to store their contents into up to 10 databases on Microsoft SQL Servers and MySQL servers. The program consists of NetFlow2SQL Collector Manager and NetFlow2SQL Collector itself which is a Windows service application.
The configuration settings are:
- NetFlow UDP port number,
- NetFlow Router IP Address,
- SQL (MSSQL or MySQL) server host name,
- SQL server TCP port number,
- SQL database name,
- SQL server user name,
- SQL server password.
NetFlow2SQL Collector automatically creates each month a new table in the given database.
The table fields are:
Num - record number,
FlowSeq - NetFlow sequence counter,
DateTime - current count of seconds since 0000 UTC 1970 (Unix time),
SrcAddr - source IP address,
SrcPort - TCP/UDP source port number,
DstAddr - destination IP address,
DstPort - TCP/UDP destination port number,
NextAddr - IP address of next Hop router,
Protocol - IP protocol type (TCP, UDP or other),
Packets - number of packets in the flow,
Bytes - number of bytes in the flow
Input - SNMP index of input interface,
Output - SNMP index of output interface.
