Querying an SQL database

To query an SQL database, do the following:

1. Go to System Center > Tools > query executer.

   Note

   The query executer feature can only be used to query SQL databases. It is not compatible with Cassandra or other NoSQL databases. As such, this page is not available on DaaS systems from DataMiner 10.3.0 [CU15]/10.4.0 [CU3]/10.4.6 onwards.

2. In the Execute query on box, select the database you want to query.

3. In the text box below this, enter the SQL query.

4. Click the Execute button on the right.

Note

• To select a previously entered query, click the Recent button.
• To access a number of preset SQL commands, click >.
• To export the result of the query as a CSV file, click the Export button.

Tip

See also: Cassandra – Querying a Cassandra database on DataMiner Dojo