For a old friend i "manage" his api connections and the necessary json transformations for repeating database imports.
I played a lot with different tools and solutions (SSIS, Powershell, ETL Talend...).
Since arround one year i use JQ for the necessary json transformations (removing, reorganisation etc). The tool is amazing and get the job done.
So far so good. My problem is the necessary development effort (i am no coder) to "develop" the necessary jq commands to get the data correct transformed.
Since three month the amount of new connection request exceed my free time. So may be it is time to rethink Thea pproach to transform the data and take a real etl solution.
So i looking for a ETL solution:
- open source
- works with heavy nested json documents
- Windows compatible