I am attempting to integrate on-premises software with our Salesforce Org. Our timekeeping system uses a PostgreSQL database to store time entries committed by staff. Salesforce's role is relegated to CRM and Project Management functionality. Unfortunately, these two systems do not communicate.
I wanted to move timekeeping to Salesforce, but consensus on the web is that Salesforce is not fit to be a "data warehouse." I'm lead to believe that simple but record-intensive information such as timekeeping would likely lead to data bloat. Is this a correct statement?
That said, if I were to integrate the two systems, is my only option to use the existing APIs or an integration service? My understanding was that all of these services (Boomi, Jitterbit, etc.) use the APIs under the hood. And, would doing so not cause me to hit API limits rather quick for near real-time integration?