Database Credential Change Issue

[CMCCOY92]

I created a spreadsheet that extracts data from an Oracle database to display a variety of information on a dashboard. This requires logging in to the Oracle Database from Excel. However, I usually run into a snag whenver my password expires- it can be difficult to efficiently change the password and get Excel to accept it.

When my password changes and I try to update it, I have to edit the query, go to the Data Source Settings, edit permissions, edit the database credentials, update it, and then cross my fingers and hope it works. It usually feels like a coinflip whether it works or not, and this isn't a process I can easily explain to a less tech-saavy person either.

Is there a better way to update data source credentials without going through that much of a hassle? I feel like I'm missing something.

[Anonymous · Accepted solution]

Hi @CMCCOY92 ,

Data source credentials are designed to be secure for data sources, and you can't avoid updating data source credentials.

One possible way to make the process of updating data source credentials more efficient is to store the password in Azure Key Vault. This way, you can update the password in the Key Vault, and your connection string will automatically use the updated password without having to manually edit the query and data source settings in Excel.

For more details on storing credentials in Azure Key Vault, refer to the official documentation.

Another possible way is to authenticate using OAuth 2.0. Authenticate using OAuth 2.0 (oracle.com)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[foodd]

Have you had a conversation with both the Oracle DBA and your InfoSec folks to see if they can set you up with a Service Account for reporting?  This would appear to be a typical business case.