WeDid: Oracle Database and Amazon Web Services (SFTP) Integration


Student and courses information from a student management system (via database connection) needs to be extracted into *.csv format and to be loaded into an SFTP server hosted on Amazon Web Services (AWS) which then produces report on student wellness and their engagement.





Purpose To generate csv files which consist of student and courses information and load it into SFTP server.
Applications Oracle database
Versions Oracle database
Tool Boomi
Information Student table (Database) > Students file (CSV)
Course table (Database) > Courses file (CSV)
Data Formats Flat File
Volumes ~10000/day
Process Extract student and course information daily and convert the information to CSV format file.
Schedule Daily
Complexity Low