Query Wizard system
Budget: $30 – $250 USD
I need a website to run queries or stored procedures at a specific time on any defined systems that I choose with a maker checker approval before running
1- Login page connected with LDAP + Domain
2- Admin panel
A. Define users by choosing them from LDAP, we need to determine the authority type (Maker, Maker Checker, Maker Checker authorizer)
incremental authority (if the user has a maker checker authority that's mean he can request a new query and approve or decline in others, expect the query that the user made it)
and determined what system is allowed to see (multi system) + in which country
(if I didn't choose any country that's mean the user have the authority to request a query in any country)
And I can determine what he should see from queries list for this system (if I didn't choose any query that's mean the user have an authority to see all of them)
B. define systems (in this screen I should write the system name and I should choose in any country and what is the server name + IP + what is the port + database type (Oracle, My SQL, DB2, MS SQL, ETC...) + scheme name, DB name, DB username, DB password (encrypted in the database), and same this info for DR server.
C. define queries for each system whether a normal query or stored procedure (write the query and determine the variables should be filled with validation (INT, decimal, string, ETC…) + minimum length and maximum length when the maker request to run it (these queries shown on a home page for each maker user according to the system choose when we defined him)
D. define countries
E. dashboard to monitor all the system movement (al logged is users, all success and failed queries)
3- Home page for each user Ex. Maker screen (small dashboard in the top of the screen to see the pending approval query and success failed queries. Finally, the queries that will run in the future according to the system that he can see) + the list of the queries group according to the system available to user + notifications for all system functionality that the user should know it
4- STMP integration to send emails for all steps
5- Detailed Logs for all system
6- Service to run the queries at determining time
1- Login page connected with LDAP + Domain
2- Admin panel
A. Define users by choosing them from LDAP, we need to determine the authority type (Maker, Maker Checker, Maker Checker authorizer)
incremental authority (if the user has a maker checker authority that's mean he can request a new query and approve or decline in others, expect the query that the user made it)
and determined what system is allowed to see (multi system) + in which country
(if I didn't choose any country that's mean the user have the authority to request a query in any country)
And I can determine what he should see from queries list for this system (if I didn't choose any query that's mean the user have an authority to see all of them)
B. define systems (in this screen I should write the system name and I should choose in any country and what is the server name + IP + what is the port + database type (Oracle, My SQL, DB2, MS SQL, ETC...) + scheme name, DB name, DB username, DB password (encrypted in the database), and same this info for DR server.
C. define queries for each system whether a normal query or stored procedure (write the query and determine the variables should be filled with validation (INT, decimal, string, ETC…) + minimum length and maximum length when the maker request to run it (these queries shown on a home page for each maker user according to the system choose when we defined him)
D. define countries
E. dashboard to monitor all the system movement (al logged is users, all success and failed queries)
3- Home page for each user Ex. Maker screen (small dashboard in the top of the screen to see the pending approval query and success failed queries. Finally, the queries that will run in the future according to the system that he can see) + the list of the queries group according to the system available to user + notifications for all system functionality that the user should know it
4- STMP integration to send emails for all steps
5- Detailed Logs for all system
6- Service to run the queries at determining time