Question

A company buys and receives products from suppliers that they will sell on their e-commerce site. Once they receive the products from the suppliers and record it in their Purchasing System; they create a spreadsheet of products and quantities received; and then manually update the quantity available for sale in their ecommerce system. Options for real-time system integration software are:

1) Design and build integration software that automates ETL for weekly data transfers
2) Avoid using a database and instead, rely on integration software for better control
3) Buy real-time system integration software from a software provider and implement it
4) Design and build a new Purchasing System that uses larger relational database software
5) 2 of the above are correct

Answer 1

The company has several options for real-time system integration software, including designing and building custom software, purchasing pre-built software, or combining both approaches.

Step-by-step explanation:

The options for real-time system integration software in this scenario include:

1. Design and build integration software that automates ETL for weekly data transfers: This option involves creating custom software that automates the process of extracting, transforming, and loading data from the purchasing system into the e-commerce system on a weekly basis.
2. Buy real-time system integration software from a software provider and implement it: This option involves purchasing pre-built integration software that can facilitate real-time data transfer between the purchasing system and the e-commerce system.
3. Two of the above options are correct: In this case, both designing and building integration software and buying pre-built software can be valid choices depending on the specific needs and requirements of the company.