Data Viewer is the tool provided by ONEWEB to interact with databases directly from the ONEWEB platform. Users do not need another Database tool to connect and view the data from the database. Users can use this tool to browse the database objects, see data from tables, run queries, and do every other thing that you do with a simple database visualizing tool.
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.
Data Viewer provides the below set of controls on the Sidebar
Icon
Control
Action
Back to main menu
To return to the Main menu
To Search Table
Enter a table name to search
Delete Search
Delete the search word
Search icon
Click to search a table
New
To configure a new connection
Edit Connection
To edit existing connection
Delete Connection
To delete an existing connection
Data Viewer provides the following set of tools on Toolbar to work with the records fetched from database.
Icon
Control
Action
Save
When user edits data within a table, save icon will be enabled, making it possible to save the edits.
Cancel
When editing data within a table cancel icon will be enabled, making it possible to cancel the edits.
Script
To open a Script window where SQL statements can be executed by connecting to a database.
SQL
To generate SQL statement from database records. Can be generated as Insert, Update or Delete statement.
Row
New
When open tables to view records, New icon will be enabled. To Create new rows to add data.
Duplicate
When open tables to view records duplicate icon will be enabled. Select the rows you want to duplicate.
Delete
When open tables to view records delete icon will be enabled. Select the rows you want to delete
First
When open tables to view records First icon will be enabled. When click the First icon, the first row is highlighted and screen scrolls to the first row.
Previous
When open tables to view records Previous icon will be enabled. Select a row and click the Previous icon. The previous row will be highlighted.
Next
When open tables to view records Next icon will be enabled. Select a row and click the Next icon. The next row will be highlighted.
Last
When open tables to view records Last icon will be enabled. When click the Last icon, the last row is highlighted and screen scrolls to the last row.
Cell
Edit
To Edit cell data
