ETL as a service at koveh.com
If you are a small business, you probably use one or more systems: CRM, restaurant software, hotel software, marketing or metrics tools. At some point, you want to collect all this data in one place. This can be for analytics, reporting, or simple tracking. With more experience, you may also build forecasts, regressions, or other models.
The main problem is data collection. The data must be up to date. You need to fetch it every day or every hour. Usually this means manually downloading data, writing scripts, or maintaining servers. This takes time and breaks easily.
I decided to solve this problem by creating an ETL tool. You add an API key and credentials. The system automatically extracts the data on a schedule that you define: every hour, every day, or another interval. The data is then loaded either into a managed PostgreSQL database on the kovac.com server or into your own server.
The main task was to make data collection simple and reliable. The user should be able to collect data, store it, and use it freely. You can download all tables as files, or you can query the database directly and receive the data you need.
You can try the service without an API key. There are example APIs available for testing. You can select which tables will be created and which fields will be stored. For example, if you work with currency data, you can choose to collect all currencies or only specific ones, such as the Australian dollar.
Next, you choose where the data will be stored. I recommend using your own server, but a managed option is also available. Then you select how often the data should be collected. Finally, you click save, and the pipeline starts working automatically.
