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 |