Tips & Tricks
Max Trottier

Maxime has extensive experience in product management, communication and advertising, and has spent the last several years helping renowned organizations bring their high-end solutions to customers worldwide. As Director of Marketing, Maxime leads Devolutions’ international market research and development efforts, along with customer relations and overall business development. He’s driven to bring innovative and cutting-edge solutions to Devolutions’ customers around the globe. Maxime earned his Bachelor degree in Business Administration from the University of Québec at Trois-Rivières, and regularly attends sales and marketing workshops to increase his knowledge and expertise.

Create Data Reports using RDM: Tips&Tricks

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.

The Steps

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
  1. 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.
Related Posts

Read more Tips & Tricks posts