Tools to ingest data to database in periods We have an application that can work with Oracle or MySql or SQLServer databases. Also, there is a 3rd party data source that we need to have it's latest data records in our database every 15 minutes. We can call some API or raw data endpoint to pull data from 3rd party source.

If we write an application to do this job, it should do the following operations:


Call the 3rd party endpoint every 15 minutes (Calling the endpoint)
Convert the data to our database format (Data integration)
Insert data in our tables (Oracle or MySql or SQLServer)


So, is there any predefined tool to do this job for us or we should develop this application in-house? This is some kind of database sync job but it should be able to work with different databases and also it should be able to do the data integration.
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.