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.