1 / 22

A Sample System

n Tegrator. by nBoundary Software Inc. A Sample System. Fictitious Company: NewTech Services Inc. Cleaning services company Formed from merger of three businesses Divisions: Residential Services (“house cleaners”) Disaster Clean-up Commercial Maintenance. The Need.

kesia
Download Presentation

A Sample System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. nTegrator by nBoundary Software Inc. A Sample System

  2. Fictitious Company:NewTech Services Inc. • Cleaning services company • Formed from merger of three businesses • Divisions: • Residential Services (“house cleaners”) • Disaster Clean-up • Commercial Maintenance

  3. The Need NewTech Services Revenue Breakdown vs D&B Industry Standards Month/Year DivisionRevenue% of TotalIndustry % Residential Services $$ % % Disaster Clean-Up $$ % % Commercial Maintenance $$ % % ________ _______ Total $$$ 100%

  4. The System

  5. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download Dis Com Res D&B D&B D&B

  6. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download Collection name is “Report” Four Collections… Data Transport name is object name. …therefore four collection objects Three database structures Six Interface Objects Six paths Object name is “COM” Collection name is “Residentl” Dis Com Res D&B D&B D&B Custom COM SQL DB

  7. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download Desired result for “Report”: Dis Com Res D&B D&B D&B

  8. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download • <COMBINATION> • <RESIDENTIAL_SERVICES> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </RESIDENTIAL_SERVICES> • <DISASTER_CLEANUP> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </DISASTER_CLEANUP> • <COMMERCIAL_MAINTENANCE> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </COMMERCIAL_MAINTENANCE> • <TOTAL> NNNN.NN </TOTAL> • </COMBINATION> Agent formats data from the XML message for presentation as HTML. Dis Com Res D&B D&B D&B

  9. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download • <COMBINATION> • <RESIDENTIAL_SERVICES> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </RESIDENTIAL_SERVICES> • <DISASTER_CLEANUP> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </DISASTER_CLEANUP> • <COMMERCIAL_MAINTENANCE> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </COMMERCIAL_MAINTENANCE> • <TOTAL> NNNN.NN </TOTAL> • </COMBINATION> Agent calculates total revenues and percentages of the total Dis Com Res D&B D&B D&B

  10. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download Agent combines three XML messages(Standard Agent) Data Transport sets path, manages flow of messages • <COMBINATION> • <RESIDENTIAL_SERVICES> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </RESIDENTIAL_SERVICES> • <DISASTER_CLEANUP> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </DISASTER_CLEANUP> • <COMMERCIAL_MAINTENANCE> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </COMMERCIAL_MAINTENANCE> • <TOTAL> NNNN.NN </TOTAL> • </COMBINATION> Dis Com Res D&B D&B D&B

  11. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download Data Transport manages flow of messages Agent combines two XML messages(Standard Agent) • <COMBINATION> • <RESIDENTIAL_SERVICES> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </RESIDENTIAL_SERVICES> • <DISASTER_CLEANUP> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </DISASTER_CLEANUP> • <COMMERCIAL_MAINTENANCE> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </COMMERCIAL_MAINTENANCE> • <TOTAL> NNNN.NN </TOTAL> • </COMBINATION> Dis Com Res D&B D&B D&B

  12. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download • <COMBINATION> • <RESIDENTIAL_SERVICES> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </RESIDENTIAL_SERVICES> • <DISASTER_CLEANUP> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </DISASTER_CLEANUP> • <COMMERCIAL_MAINTENANCE> • <AMOUNT> NNNN.NN </AMOUNT> • <PERCENT> NN.N </PERCENT> • <DBPERCENT> NN.N </DBPERCENT> • </COMMERCIAL_MAINTENANCE> • <TOTAL> NNNN.NN </TOTAL> • </COMBINATION> Agent reformats retrieved data into desired form Data Transport reads from external SQL database, converts to XML(Standard DT) <RESIDENTIAL_SERVICES> <MONTH_TOTAL> $$$$$.CC </MONTH_TOTAL> </RESIDENTIAL_SERVICES> Dis Com Res D&B D&B D&B

  13. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download Dis Com Res D&B D&B D&B

  14. Construction

  15. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Scraper Commercl Download Download Scraper Scraper Download Download Format Format Format Scraper Scraper ODBC COM Custom Download Download N President’s computer N N N Disaster Clean-up computer Commercial Maintenance computer Residential Services computer N Internet access computer

  16. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download N N President’s computer: • Prepare Agents: • XSLT script to produce HTML • VBScript to calculate totals and % • “Combine” program is a standard ‘parallel’ Agent N N N N

  17. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download N N • Residential Services computer: • Standard ODBC Data Transport to access Residential Services data. • XSLT Agent to change data name President’s computer: • Prepare Agents: • XSLT script to produce HTML • VBScript to calculate totals and % • “Combine” program is a standard ‘parallel’ Agent N N N N N

  18. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download N • Commercial Maintenance computer: • VBScript Data Transport to access Commercial Maintenance data using COM • XSLT Agent to change data name • Residential Services computer: • Standard ODBC Data Transport to access Residential Services data. • XSLT Agent to change data name N N N N N N

  19. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download N • Commercial Maintenance computer: • VBScript Data Transport to access Commercial Maintenance data using COM • XSLT Agent to change data name • Disaster Clean-up computer: • Custom VBScript Data Transport to access Disaster Clean-up data • XSLT Agent to change data name N N N N N N

  20. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download N • Disaster Clean-up computer: • Custom VBScript Data Transport to access Disaster Clean-up data • XSLT Agent to change data name • Internet access computer: • Custom web access Data Transport to access D&B web site (reused twice) • Three VBScript Agents to ‘scrape’ data N N N N N N

  21. Combine Residentl Combine HTML Disaster Calc Combine Report Combine Scraper Commercl Download Scraper Download Format Format Format Scraper ODBC COM Custom Download N • Internet access computer: • Custom web access Data Transport to access D&B web site (reused twice) • Three VBScript Agents to ‘scrape’ data N N N N N

More Related