System and method for data capture and reporting
View Patent ↗A database system includes an intermediary program that provides a variety of functions. Logging on to the intermediary program results in log-in information being transmitted from an encrypted file to the database system via the intermediary program. The database system includes the ability for the user to enter criteria for a query in a variety of different manners, including the ability to directly modify generated SQL statements and the ability to use input lists in creating queries. In addition, the queries entered by the user can be stored in a separate database, such that the efficiency and operation of the database system can be improved. In addition, the delivery of query results and reports allows for delivery of files that are associated with a data period in any format and also allows the user to receive multiple reports in a single, compressed file.
1. A method comprising:
validating, by a computer-based system for accessing a secure system, first authentication credentials associated with a user and available to said user;
obtaining, by said computer-based system for accessing said secure system, second authentication credentials and a second password from a computer-device, wherein said second authentication credentials include said second password and access data, wherein said access data includes information used to locate and access said secure system, and wherein said second authentication credentials are different from said first authentication credentials, and wherein said second password is locally stored on said computer-device of said user, wherein said computer-device of said user is different than said computer-based system for accessing said secure system, wherein the second authentication credentials are obtained in response to validation of said first authentication credentials associated with said user, wherein said second authentication credentials are not available to said user;
validating, by said computer-based system for accessing said secure system, said second authentication credentials;
transmitting by said computer-based system for accessing said secure system, said access data to said secure system;
receiving, by said computer-based system for accessing said secure system, a validation of said access data from said secure system; and
allowing, by the said computer-based system for accessing said secure system, access to said secure system.
2. The method of claim 1 , wherein said first authentication credential and said second authentication credential are received from said user computer-device including at least one of: a terminal, a Personal Digital Assistant (PDA), a telephone, and a cellular phone.
3. The method of claim 1 , further comprising blocking, by said computer-based system, access to predefined at least one of: data and code at said secure system.
4. The method of claim 1 , further comprising receiving, by said computer-based system, a request from a user, wherein said request is to at least one of: access data, modify data, delete data, execute program code, access program code, modify program code, delete program code, modify a database, and delete a database.
5. The method of claim 1 , wherein said providing access to said secure system is based on a type of device of a user.
6. The method of claim 1 further comprising:
facilitating execution of a query on said secure system by:
receiving an input list from said user, wherein said input list includes query criteria relating to a field in said secure system;
storing said input list with a profile corresponding to said user;
receiving a selection of a query type from said user, wherein said query type corresponds to a query template;
receiving a request from said user to retrieve said input list; and
providing said user with said input list.
7. The method of claim 1 , wherein said first authentication credentials include a unique first user id and first password and said second authentication credentials include a second user id and said second password, wherein said second authentication credentials are stored locally on the said computer-device of said user in an encrypted connection file.
8. An article of manufacture including a non-transitory, tangible computer readable storage medium (“CRM”) having instructions stored thereon that, in response to execution by a computer-based system for accessing a secure system, cause said computer-based system to perform operations comprising:
validating, by said computer-based system for accessing said secure system, first authentication credentials associated with a user and available to said user;
obtaining, by said computer-based system for accessing said secure system, second authentication credentials and a second password from a computer-device, wherein said second authentication credentials include said second password and access data, wherein said access data includes information to locate and access said secure system, and wherein said second authentication credentials are different from said first authentication credentials, and wherein said second password is locally stored on said computer-device of said user, wherein said computer-device of said user is different than said computer-based system for accessing said secure system, wherein the second authentication credentials are obtained in response to validation of said first authentication credentials associated with said user, wherein said second authentication credentials are not available to said user;
validating, by said computer-based system for accessing said secure system, said second authentication credentials;
transmitting, by said computer-based system for accessing said secure system, said access data to said secure system;
receiving, by said computer-based system for accessing said secure system, a validation of said access data from said secure system; and
allowing, by said computer-based system for accessing said secure system, access to said secure system.
9. The CRM of claim 8 , wherein said first authentication credential and said second authentication credential are received from said computer-device of said user including at least one of: a terminal, a Personal Digital Assistant (PDA), a telephone, and a cellular phone.
10. The CRM of claim 8 , further comprising blocking, by the computer-based system, access to predefined at least one of: data and code at said secure system.
11. The CRM of claim 8 , wherein said request is to at least one of: access data, modify data, delete data, execute program code, access program code, modify program code, delete program code, modify a database, and delete a database.
12. The CRM of claim 8 , wherein access to said secure system is based on a type of device of said user.
13. The CRM of claim 8 , further comprising:
facilitating execution of a query on said secure system by:
receiving an input list from said user, wherein said input list includes query criteria relating to a field in said secure system;
storing said input list with a profile corresponding to said user;
receiving a selection of a query type from said user, wherein said query type corresponds to a query template;
receiving a request from said user to retrieve said input list; and
providing said user with said input list.
14. The CRM of claim 8 , wherein said first authentication credentials include a unique first user id and first password and said second authentication credentials include a second user id and said second password, wherein said second authentication credentials are stored locally on the said computer-device of said user in an encrypted connection file.
15. A system comprising:
a tangible, non-transitory memory communicating with a processor for accessing a secure system, said tangible, non-transitory memory having instructions stored thereon that, in response to execution by said processor, cause said processor to perform operations comprising:
validating, by said processor for accessing said secure system, first authentication credentials associated with a user and available to said user;
obtaining, by said processor for accessing said secure system, second authentication credentials and a second password from a computer-device, wherein said second authentication credentials include said second password and access data, wherein said access data includes information used to locate and access said secure system, and wherein said second authentication credentials are different from said first authentication credentials, and wherein said second password is locally stored on said computer-device of said user, wherein said computer-device of said user is different than said computer-based system for accessing said secure system, wherein the second authentication credentials are obtained in response to validation of said first authentication credentials associated with said user, wherein said second authentication credentials are not available to said user;
validating, by said processor for accessing said secure system, said second authentication credentials;
transmitting, by said processor for accessing said secure system, said access data to said secure system;
receiving, by said processor for accessing said secure system, a validation of said access data from said secure system; and
allowing, by said processor for accessing said secure system, access to said secure system.
16. The system of claim 15 , further comprising:
facilitating execution of a query on said secure system by:
receiving an input list from said user, wherein said input list includes query criteria relating to a field in said secure system;
storing said input list with a profile corresponding to said user;
receiving a selection of a query type from said user, wherein said query type corresponds to a query template;
receiving a request from said user to retrieve said input list; and
providing said user with said input list.
17. The system of claim 15 , wherein said first authentication credentials include a unique first user id and first password and said second authentication. credentials include a second user id and said second password, wherein said second authentication credentials are stored locally on the said computer-device of said user in an encrypted connection file.