Good evening, today we will talk about systems integration concepts. Before we go ahead, let's answer some important questions. What is system integration?
It is the process of connecting two or more systems together. Why system integration? We need system integration merely to exchange data between two or more systems.
How system integration is achieved? Actually, system integration is achieved by direct database access or web services or messaging we are going to cover each of these points later in these slides let's say there is a six company works with selling office equipments send us invitation to our java tips team okay next day Zix company asked us to build a profile management system. This profile management system enables their employee to browse their own data like employee id, name, birth date and hire date. Okay, it's pretty simple.
Next day our development team hold a meeting and the business analyst said that the Zix company already has HR systems. and this hr system work on the database and this database contain all the data we need to fulfill our project management system okay on the next day our development team try to contact with hr system team and ask them to give us direct access to the specific table which give us the data we need and hr system team approved one week later the system was ready and the client was happy now let's have a look on the pros or advantages and the cons or disadvantages of using direct database access to establish system integration two months later we received an invitation from this company to hold a meeting on the meeting this company said that the application we already provide is good but now they want their employee to be able to see their salary on the profile management system okay it's also easy next day our development team hold meeting again and the business analyst said that six company also has a payroll system which contains the basic salary which we need to display in the new version of the profile management system next day our development team tried to get access to the payroll system database but they refused but They said that they can give us web services so we can consume the salary we need. This was okay.
One week later, we also was able to modify the profile management system and add the salary data. And the Zix company was happy. Now let's also see again the advantages and disadvantages of using web services when connecting or integrating two systems.
Two months later actually, Zix company also sent a new invitation to the development team. As I said, that the profile management system is okay right now but sales employee inside this company wants to see their monthly commission on their profile for example in January on February and so on okay next day when we hold a meeting business analyst said that this company already has a sales system and this system works with database which contains the commission we need to display in the profile management system business analyst said that this sales system team cannot give access to their database directly but they can give us a web services and in this website we can consume it to get the commission per employee per month but there was a problem with their system that it went down two hours per week for pickup and maintenance and that was unacceptable for the six company what is the solution next day We send our development team to ask the sales team if they can send a message to a queue for each commission they register inside their system. Later, we can pull a message from the queue and keep it inside our local database. They approved.
Okay, this was the overall picture of our... Profile management system as you can see we have three type of integration first one using direct database access with HR system as the second was Using web service code with a payroll system As I said was using messaging with a sales system sales system sent a message to a queue and later on we put this message We insert it to our local database and then all data is displayed inside profile management system this was the data that our final project management system display okay let's see what are the advantages of using messaging and integrating between two systems Thanks for watching.