WeDid: Oracle Database and Amazon Web Services (SFTP) Integration
Challenges
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.
Solution:
Purpose | To generate csv files which consist of student and courses information and load it into SFTP server. |
Applications | Oracle database SFTP |
Versions | Oracle database SFTP |
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 |