Využití SQL při automatizaci grey box aplikací podnikových informačních systémů

The diploma thesis deals with the issue of automation in grey box applications of enterprise information systems supplied by external entities. The research question was asked: Can SQL be a tool for process automation in grey box applications of enterprise information systems? To obtain a positive or negative answer to the research question, the goal was set: To design illustrative SQL solutions that will automate selected processes in the ERP application I6. The application I6 was chosen as a typical representative of the gray box of EIS applications on the Czech market. After introducing the issues of these applications, the author conducted a search in the field of automation. From this research came a methodology for selecting suitable processes for automation using RPA (Robotic process automation). Furthermore, the SQL language with a focus on the T-SQL dialect was briefly introduced. For this implementation of SQL, a list of language elements usable for automation was created. Subsequently, the author conducted interviews with business users of I6 (n = 10, employees of e-shop Mironet.cz a.s.), from which a set of processes implemented through I6 was obtained and for which users would like to implement automation. The author applied the previously introduced methodology to the processes, thanks to which the 3 most suitable processes for the illustrative design of automation through SQL were chosen. For each of these processes, an SQL automat was designed according to the UP methodology, which enables automated execution of the given process with partial or no user intervention. The design includes an annotated UML Diagram of activities with the concept of the machine, a description of T-SQL elements for possible procedural flow and table of connections to user requirements. The implementation of this proposal met the goal of the work. This also implies the answer to the research question, namely that the SQL language can be used as a tool for process automation in gray box applications of enterprise information systems.