In this section, we'll look closer at getting the data from the legacy system. If you're not interested in trying out this example, you can skip this section.
The data can come from various sources – database, XML, CSV, and so on. Our application will pull data from a database, however it shouldn't be a problem to work with any other data source. The table structure looks as follows:
CREATE TABLE 'droolsBook'.'customer' ( 'customer_id' bigint(20) NOT NULL, 'first_name' varchar(255) NOT NULL, 'last_name' varchar(255) NOT NULL, email' varchar(255) NOT NULL, PRIMARY KEY ('customer_id') )
Code listing 25: Table structure for legacy customers in a MySQL Database.
CREATE TABLE 'droolsBook'.'address' ( 'address_id' ...