DB explorer
The Database explorer tool is used for quickly studying and manipulating the structure and data of available databases.
To connect to a database, you need to click the Create connection context menu button and select the driver type.
To open the connection string editor, click the “…” button.
OLE DB Connection
For this type of connection, you need to install the driver for the corresponding DBMS on your local workstation. When creating a connection string, you can use the OLE DB Connection Wizard.
PostgreSQL Connection
The OLE DB driver is not used when connecting to PostgreSQL.
Viewing Database Entity Properties
To view information about an entity:
- Select the entity in the database structure tree.
- Right-click it.
- Choose Properties from the context menu.
Executing a Query to the Database
To execute a query to the database, you need to click the Create Query context menu item in the database structure tree.
In the resulting tab, you can enter the query text and execute it using the Run key. If the query implies receiving data, the data will be displayed in a table at the bottom of the tab.
To export the received data in CSV format, you need to click the Save Results button.