Open the application and choose the Database menu. Click on the Data Viewer menu under Tools.
System will open the Data Viewer screen for you.
The Data Viewer screen has two types of menu - the Toolbar and the Sidebar. The sidebar has the search and filter option and is used to browse the connections and tables. The toolbar menu has the controls to interact with the data.
Enter the database details.
Choose the Database Driver details. The user has an option to upload a new driver version on this screen.
Once the configuration is completed, the user can test the connection using the Test button. If a test is successful then the user can click Save & Done.
The user can also access this connection from the list of existing connections.
Expand the connections to view the schema and table details in the sidebar. The user can double click on a table to fetch the data from that table.
Users can also add search and filter conditions in the search field to filter the records.
Each column name also has the sort by ascending or descending options as well.
The Data Viewer also shows the total number of records fetched and the count of fetches at the bottom of the records panel.
How to generate SQL from the tables Data Viewer also provides an option to generate basic SQL Statements from the records. Users can choose Insert statement, Update or Delete Statement.
How to Create New Connection There is the New Connection icon on the Sidebar to open the Create Connection Wizard. The User needs to follow the steps to create the database connection just like in the Designer Tools.
The key icon allows user to set the Identity key columns for saving edits.
How to run custom queries against a database using Data Viewer Data Viewer also provides a Script window to write and execute custom SQL queries against the database. Click on the Script icon on the toolbar to open the Script window. Users can write custom SQL queries in this window. First, click on the connection icon to choose a connection. Users can choose from the available connections in this app. Once the connection is valid the connection icon will turn green. Now user can click on the Run icon to execute the query against the database connection.
