python programming
Budget: $30 – $250 CAD
To create a python utility program on Linux automation servers to automatically collect technical hardening data from a remote SQL data source. The program is expected to function as follows:
Using Python database module for SQL server, connect to a remote SQL database with SQL authentication and establish the connectivity.
Through the established connectivity, the program will execute database queries to extract data from number of tables and return the results back to the main caller.
Parse and format the results returned from above query executions and save them in csv file on the automation server.
Using Python database module for SQL server, connect to a remote SQL database with SQL authentication and establish the connectivity.
Through the established connectivity, the program will execute database queries to extract data from number of tables and return the results back to the main caller.
Parse and format the results returned from above query executions and save them in csv file on the automation server.