The complexity and amount of the data that Dell Technologies uses is not representative of anything that is encountered in an enterprise setting. The purpose of presenting this flow as a use case is to show the different types of problems that can be solved using only the Boomi DCP toolset.
This use case follows a fictitious consumer loan department that uses a combination of business systems. Each system requires a separate data source. Information that is related to customers (borrowers) and the loan details are stored in a PostgreSQL database with a simple one-table-per-object schema. Dell Technologies represents customer communications with a call center as a flat file extract stored on a file on a server.
The use case shows how the data discovery, data cataloging, and data transformation capabilities of Boomi DCP can be combined into an integrated business solution. The resulting workflow combines information from these source systems. It uses data query to join, filter, and transform that data into a result that can be used to generate a finished report. The final tabular result is written onto an output HDFS data store.
This example uses two structured data sources hosting multiple tables together with a file to create an output. The output lists how many customer communications there were for every approved and funded loan application. This use case demonstrates only a small set of the complete functionality available in Boomi DCP.This pattern is difficult to produce without the right toolset.