We have a report that generates ~100 rows daily and our customers have to enter the data into third-party software. We hoped that the software allows some kind of data upload so that our customers don't have to do the tedious data-entry, but it's not happening. So, we are thinking to provide a solution to our customer by implementing an automated data entry system utilizing Selenium (I'm very new to Selenium). To achieve this, we have to use a real user's credential for login and a SQL connection credential and we came up with these two ideas:
- Use Python/Selenium, credentials hardcoded in a separate file, schedule a SQL Server Agent to automatically run this script daily.
- Implement a web user interface with C# in Visual Studio, credentials hardcoded in an encrypted web.config file, let user click a button to run the Python/Selenium script. (this will be a semi-automatic option but it gives users flexibility in choosing what to enter)
(We could take user's credential as a parameter to run the tool in order to avoid hard-coding a user's credential.)
I know it can be done but should Selenium be used to automate data entry in the security standpoint?