Optimizing data warehousing/ ETL

Hi everyone, I'm looking for advice on how to solve my data workflow. The IT lords prefer that I do not have access to the MySQL database, and they only provide seperate excels that I've structu...

Dataflow

Need Help

TomMartens
5 years ago
Hey ruesaint_denis ,

basically there are 2 issues, you are facing

MFA

No direct access to the underlying database

Until you can't use any authentication that does not require human intervention, you can't automate anything. For this reason I would ask the lorde if they can provide some kind of placement of the files, that does not use MFA. Then you might consider creating some kind of Power Automate that automatically moves the files to onedrive.

The other aspect is that you can access the database directly, this often happens to avoid overload on the database by large analytical queries. This can be a complex path, as you have to convince the lords that your requirement is important and that they will also benefit if they are more supportive.

Hopefully, this provides some ideas on how to tackle your challenge.

Regards,

Tom

ruesaint_denis

Helper I

5 years ago

Hi TomMartens ,

Thank you for your help and reply. Would you have any "secruity safe" suggestions on where/how the IT dept can transfer the files in order for me to automate the workflow? In my previous company they were looking to do an FTP site, but I'm not too familiar with the requirements there.

Thank you,

Denisse