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.|
|Information||Student table (Database) > Students file (CSV)
Course table (Database) > Courses file (CSV)
|Data Formats||Flat File|
|Process||Extract student and course information daily and convert the information to CSV format file.|