As we all know, Database Administrators (DBAs) are hard working professionals who are in charge of executing important queries – often weekly, monthly and/or quarterly. However, many of them don’t get the love they deserve. Instead, they get questions like “Hey John, where’s the report that I forgot to ask you about last week? I need it in 15 minutes for meeting.” Well, now’s your chance to show the hard working and dedicated DBAs in your organization some love by introducing them to RDM! With RDM, DBAs can do much more than run customized queries using specific values, such as start and end dates, etc. They can also get input from specific users, but without the need to give them security privileges to run the query themselves – which can sometimes lead to issues like runaway queries and data loss.
Data Report Session Type
How is all of this possible? It’s all thanks to RDM’s Data Report session type. DBAs can use it to distribute simple reports to any/all users, without having to grant them access to the actual server. Server credentials therefore remain private, and they cannot be changed – they can only be viewed. DBAs retain total control over the query, yet users can run the query when they need, thus freeing up hours of valuable time.
There are 3 steps to run a RDM Data Report Session: 1. Define the connection string by either:
- specifying the connection in the entry itself
- using a credential entry
- inheriting from a parent
- prompting for credentials
- Specify the parameters by setting the name, type and default value of all parameters. 3. Enter the query in the Query tab, which features a SQL syntax-highlighted text box with line numbers. Just make sure that your DBA sets the proper security group, and that each specific user(s) has access to it. There it is, simply double-click on the entry and see the results displayed in an easy to consult grid. As all our grids, you can export in multiple formats if you need to perform further analysis.