000028208 - KB-1100 - CSV collector takes a long time to process

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028208
Applies ToAffected Versions: All Versions
ResolutionIt should be much quicker with a dB driver connecting to the CSV file
You can do this using the JDBC-ODBC bridge.
Couple of notes around this -
a) You’ll need to install a remote agent on a windows machine to access the MS Access database
b) Configure a DSN (data source) to get to the MS Access database
http://www.exclamationsoft.com/exclamationsoft/netmailbot/help/examples/HowToDSN.asp
c) Configure the ODBC driver for the database collector which is there in the drop-down. Replace the DSN with the DSN name created in step (b) above

Attachments

    Outcomes