Member-only story

Dossier ETL Application

Ramesh Ponnusamy
5 min readApr 27, 2020

I have been working as a Software Engineer for the last four years, focusing on the back-end operations.

I have hands-on experience in ETL tools like SAP BODS, SAP WEBI, DELL BOOMI.

Without Knowledge action is useless, and Knowledge without action is futile.!

So, I Questioned myself, what I learned for past years? What contribution did I make to the Engineering world?

So, I landed with an idea — why can’t I build an Application with all I learnt in my favourite area and address the challenges in the Database.

These questions filled my mind, and I answered it with “DOSSIER” — which helps to migrate tons of data with ease!

Dossier gives the solution for:

Transferring the data between the server (SQL Operations)

MS SQL to MySQL.

MySQL to MS SQL.

Within one server (SQL operations).

CSV to DB (MS SQL or MySQL server).

Call API and get the response.

Create n number of process as in flow.

Assign global variable.

Schedule the task.

Manage the running tasks.

Audit for every process.

User Management.

The steps to do the basic ETL.

--

--

Ramesh Ponnusamy
Ramesh Ponnusamy

Written by Ramesh Ponnusamy

Data-Architect, SQL Master,Python ,Django, Flask dev, AI prompting, Linked-in: https://www.linkedin.com/in/ramesh-ponnusamy/ mail : ramramesh1374@gmail.com

Responses (1)