System Integration LEPL FinancialAnalytical Service Ministry of Finance

System Integration LEPL Financial-Analytical Service, Ministry of Finance October, 2015 Dimitri Rakviashvili, Head of Software Department Giorgi Gurashvili, Chief System Analyst

System Integration - Agenda System Integration – Global Topics: Integration Protocols System Integration – Look inside: Integration Diagrams Discussion (Questions And Answers) 2

Integration Protocols: Integration Preparation Request WSDL Partner System Core System Return Data and Service Contracts in WSDL format One-time partnership establishment between partner and core system › Core system publishes functional API to Web-Server using service data contracts › SOAP standard is used at data-tier › Client builds proxy library using Web Service Description Language (WSDL) › Subsequent calls between partner and core system are made using contracted interface protocols › Partner is provided with accompanying 3

Integration Protocols: Online Request (Response) Request Information Partner System Core System Return Information › Partner system requests information using agreed method signatures, passes filter and other input data › Core system reacts with immediately response to partner’s call, providing requested information 4

Integration Protocols: Distributed Transaction Start Transaction Partner System Performs Action 1 (Process Result) Performs Action N (Process Result) Core System Commit or Rollback Transaction › Partner system starts distributed transaction- same logical transaction is started at Partner’s and at Core system’s side › Partner performs actions in Core System, processing results. › Depending on action results, partner commits or rollbacks distributed transaction › All communications are service level. Distributed transaction is organized programmatically, using special remote calls and local database transaction. 5

Integration Protocols: Event based communications Event notification Event Response (submission) Core System Partner System Asynchronous data request Data Response › Core system notifies partner about some event, passing event id. Partner responses immediately with notification submission result and stores event data › Partner system then asynchronously requests data from Core system (using internal schedule), passing stored event id. Core system immediately responses with full data profile 6

Integration Protocols: Polling Data Availability Request Data Availability Response Core System Partner System Synchronous Data Request Synchronous data Response › Partner system periodically checks if data is available for download or not (polls). Partner uses special service method for this operation. Periodical action is organized programmatically at partner’s side. › When data is available at Core system, Partner gets data using synchronous data request. Core system immediately responses with requested data. 7

Integration Diagrams: PFMS Component Integration Plan Next Year Budget Approves Budget e. Budget administrator Government Entities Sends payment information Make Payment Sends contract data Sends approved data of organizations resources and changes to budget Sends contract data e. Treasury Sends order data Confirms Payment Registers Target Grant e. DMS Registers order e. DMS administrator 8

Integration Diagrams: e. Treasury - NBG Commercial Banks Register Payment Send Payment e. Treasury GPSS Import Payment Confirms Payment Spending Units Re qu Se n es d. E Send Payment xc t. E xc ha ng e. R ate s e. Treasury Administrator RTGS Make Payment Confirms Payment ha ng Approve Payment Send Payment Import Payment s Confirm Payment Send Exchange Rates FAS Services NBG Request Exchange Rates 9

Integration Diagrams: Procurement Register a contract Make payment at otific dd N e. Treasury Confirm Payment ion A Request Data Insert Return Result Request Data Not ifica tion Procure ment System GPSS/RTG S Paym en t Info FAS Services Notification Plug-In Sen d Send Payment Warehouse Return Result R Da ta ay t. P es equ nt me n tur t en aym ta Da P Re 10

Integration Diagrams: Civil & Pubic Registry Send Request information about organization / person PFMS FAS Services Return Result Tra st Spending Units ue Req smit Tran etu R es rn R ult Re tur n nsm it R equ est Re sul t Public Registry Civil Registry Reque st Data Return Result Third Party System Return Result Request Data Third Party System 11

Integration Diagrams: e. Treasury Public API Perform an operation Third Party System Send Request Return Result Public API Send Request Return Result e. Treasury Government Entities 12

Integration Diagrams: e. Treasury Warehouse Request Information Return Information Warehous e Update Data e. Treasury Government Entities 13

Integration Diagrams: e. Treasury - Revenue Service Check if day has been closed Revenue Service Request Information e. Treasury Return Information 14

Thanks for your attention! Please feel free to ask questions.