Announcement Announcement Module
No announcement yet.
ETL Designer Help Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • ETL Designer Help

    Hi, I need to create a job that load list of users from database, than load a list of operations for each users from the same database, generate a list of reports for each user based on the operations, and save the operations on another database. (A ETL job).
    Here's my idea:

    public class User {
       private int id;
       private List<Operation> operations;
       private List<Report> reports;
    - A composite ItemReader<User>: with a ItemReader<User> that load the users from the database, and another (ItemReader<Operation>) that load and set the operations for each user;
    - A ItemProcessor<User, User> that process the operations for the user and set the reports.
    - A composite ItemWriter<User>: with a ItemWriter<Report> that save the reports on another database.

    It is a good designer for user Spring Batch?
    I don't found examples that implements a composite ItemReader like this.

    Thanks for any help,
    Leandro Borges

  • #2
    Try using a querying ItemReader to find the Users. Then your ItemProcessor could query for the Operations for each user and prepare the user's report. Then the ItemWriter would write the report. This would simplify things by ensuring that the list of Users is driving the whole step.