openmolecules.org Forum: Functionality

Home » DataWarrior » Functionality » Embedding credentials

Show: Today's Messages :: Polls :: Message Navigator

Embedding credentials [message #2243]

Mon, 22 July 2024 14:53

slprakash
Messages: 4
Registered: July 2024

Junior Member

Is there a way to embed SQL Database credentials in Data warrior template so that the users need not enter credentials every time they open the dashboard ?

Report message to a moderator

Re: Embedding credentials [message #2247 is a reply to message #2243]

Mon, 22 July 2024 17:03

thomas
Messages: 728
Registered: June 2014

Senior Member

Currently, the macro task 'Run SQL Query' does not store any credentials. With a template this cannot be done, either. Maybe, some database systems allow passing credentials with the connects string?

I have added 'user' and 'password' as optional parameters to the task 'Run SQL Query'. There is no user interface to use that, but from version 6.2.2 (due possibly in early August) you could edit a macro and add these two parameters to 'Run SQL Query' tasks using a text editor.

Report message to a moderator

Previous Topic:	Generating evolutionary library
Next Topic:	copy values down a column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Apr 02 03:32:47 CEST 2025

Total time taken to generate the page: 0.00604 seconds