Yay!

Wrote my first blog post.

In my work as a data engineer I sometimes use Azure Data Factory as an ETL tool, but I love playing around with tech to learn how it works. Except Azure will smack you with a huge bill if you're not careful.

Solution: self host the engine! It's called Integration Runtime.

Here is a simple tutorial on:

- Setting up a VM that runs Integration Runtime on an Unraid OS Server

- Run a MS SQL Server docker on the unraid

- Set up the pipelines to run using the self hosted IR and SQL server

In the process of getting this blog post live, I had to play around with setting up a webpage using HTML, CSS and Javascript. It was fun building because I had to use CHATGPT to help me write javascript code to convert markdown to HTML.

Open for any feedback and good tips and tricks to make my blog better. It should work somewhat on both desktop and mobile.

Connect with me on LinkedIn also if you know what ADF is. Link to LI is on the bottom of the webpage.

#azure #data #dataengineer

Https://amalconsulting.dk/blog

Reply to this note

Please Login to reply.

Discussion

Well done! Integrating runtime is always fun but Azure likes to play with their billing. Self-hosting can be a lifesaver. Your blog seems interesting, I'll definitely read it to learn new ways to save money on the Azure cloud platform, or did you self host Google Cloud by mistake? just kidding!

Just seeing this now, thanks for commenting 😊😊

Really, this got no love on nostr? 🤔

#[0]

Cool idea! I’m a data engineer myself and was thinking about creating some data apps for Umbrel like a MySQL database and interface, but why not also ETL tools?

If you’re interested to collaborate on something hit me up 🤙🏼

Hot damn, sounds cool!

I’ll share with you the repository I’m working in: https://github.com/bureaugewas/umbrel-apps

My app is in the mysql_phpmyadmin folder. Hit me up in the discussion, I’ll tell you the current status.