I’m wondering if it is possible to update tables in a database using a transformation. My co-workers rely heavily on Excel and I have them copy data into spreadsheets and use various transformations to insert the data in the database and it works great.
Now, I need them to take care of updating data here and there (like the status of an administration or date something closed) and right now they maintain that locally in a spreadsheet which I then manually change in the database. if I could create a project that could accomplish this, that would be perfect. Still really new to this ETL / database stuff so I’m learning as I go Any suggestions would be great.