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:

oracle2csv

 

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

 

Get in touch today to see how WDCi can help your business.