Mini Lesson: Understanding ArcSight Flex Database IDs for Enhanced SQL Reporting
- Pavan Raja

- Apr 8, 2025
- 3 min read
Summary:
The document serves as an instructional guide for using ArcSight Flex Database ID to process Honeywell badge reader data stored in SQL Server 2012. It outlines the steps required to install necessary software, configure tools like DB Visualizer Free and Logger, and navigate through the processing of logs from the Honeywell device. The lesson does not cover creating complete solutions but rather provides a practical guide for handling specific log data with detailed instructions on installation, setup, debugging, and final report preparation or data export. It emphasizes compatibility between software versions such as ArcSight, Java, and others to ensure successful log processing.
Details:
This document provides a mini lesson on how to use ArcSight Flex Database ID for processing Honeywell badge reader data stored in SQL Server 2012. It is important to note that it does not constitute a complete flex connector but serves as an example of the steps needed to acquire, prepare, install, debug and process logs provided by customers. The lesson was created using SQL Server 2012, Java 8 update 5, Flex Connector 7.0.2.7019.0, DB Visualizer Free 9.1.9, Logger 5.5SP1, Honeywell 3.81, and a document named SQL Server Flex_Config Notes_SamH.docx with the size of 253.3 KB.
The lesson is focused on Honeywell badge reader tables which are stored in SQL Server 2012. It does not mention any specific version or update details for ArcSight, Java, or other software mentioned, but it suggests that compatibility might be necessary to ensure smooth processing of the logs from the customer. The document also provides a general outline and steps that users should follow when dealing with such data:
1. Installation of required software and tools (Java 8 upate 5, Flex Connector 7.0.2.7019.0, etc.).
2. Using DB Visualizer Free to view the SQL Server database structure.
3. Configuring and setting up the Logger for debugging purposes.
4. Processing the logs from the Honeywell badge reader through the ArcSight Flex Database ID process.
5. Troubleshooting any issues that may arise during this process.
6. Finally, preparing a report or exporting data as required by the customer.
The document is marked as final and does not provide any space for comments or feedback from users. It's worth mentioning that while it provides useful information about processing specific logs, its scope does not extend to creating complete solutions or connectors but rather focuses on guiding through a particular use case with detailed steps.
The provided information includes a URL to a website and discusses connecting a plugin successfully. The URL is "https://irock.jiveon.com". Below the URL, it mentions copyright information, links for navigation (Home, Top of page, Help), and software version details from Jive Software which are version 8.0.0.0 with revision number 8.0.0.0_8c4_328_d191c49. The website appears to be related to a platform or service named "Jive" as indicated by the URL and mentions Jive Software, suggesting it might be part of a product or service provided by this company.
The navigation links at the bottom include:
Home: This could imply that you're returning to the main page of the website.
Top of page: This would direct users back to the top section of the current web page they are on, which is typical for accessibility purposes in multi-page websites.
Help: This might link to a support or FAQ section where users can find assistance if needed.

Comments