if I use a SQL server data source it allows me to use the logged in user's login credentials. With the RDMS data source this doens't seem to be allowed. Am I missing something or is that correct?
I like being able to use the AD groups with RDMS, but this is a slight annoyance.
Thats why we created the "My personal credentials" feature, to have a single entry with your private credentials.
SQL server does not use the credentials themselves, but in fact the security token that is resolved from your credentials, this is not built in for RDMS because it's in fact a web application.
We have that request on our board though, we will probably add support for that in the future.