Tools to ingest data to database in periods
Solution

Your solution contains two parts


Schedule a Job
Extract, Transform, and Load (ETL) the data


Job Schedulers


OSes have them (cron / task scheduler)
some databases have schedulers (oracle DBMS_SCHEDULER)
and there are enterprise COTS (Common Of The Shelf) software for inter-job scheduling and resource control


ETL

The simplest form would be a combination of shell scripts and stored procedures.  


The shell script first copies (Extract) the data ( ftp,scp, REST call via curl ).
Then, it Loads the data into the database.  All RDBMS have tools to load CSV data.
After that, a stored procedures and/or SQL script is called to Transform the data into its final state.


These would most likely use INSERT...SELECT or MERGE statements.

Finally, the shell script archives the data file.


On the high end, COTS Software is available.

Build or Buy?

That's up to you.  You will need to do much more research.