While trying to Intergrate the Security Analytics ECAT feed, it asks to enter the URL of the machines.csv file, as mentioned in the Security Analytics 10.5 User Guide, but the verification of the file fails.
The issue is that the entered username and password in the ECAT UI console that is enabled with ECAT feed is not a SQL user account generated from the ECAT Console.
Add this user to the SQL user accounts in the ECAT deployment
To resolve the issue, follow the steps below.
From the ECAT UI Console press Configure.
Click on Manage users and roles.
Right-click on Users and select Create SQL user.
Enter the username and password.
The machines.csv file can then be downloaded using the URL below when providing the username and password of the SQL user.