This section will refer to the Reference Data Management dashboard found on the Desktop and all relevant materials and functions associated with the dashboard. The Reference Data Management dashboard will allow you to do the following:
Query the results from a table based on the Reference Data Management profiles in the system
Filter certain results by using expressions in your query
Insert new rows in your table
Edit existing fields in your query results (For unsupported data types, please refer to <TODO>)
Import existing data from a CSV file
Export the entire table or queried result into a CSV file
You can access the dashboard from the Manage View. Go to Manage → Data Management and then select Reference Data Management.
Temporary files are created on the Platform host when the user executes queries via Reference Data Management. These temporary files, stored in $MZ_HOME/tmp/rowset, are removed automatically when the user session expires. Users sessions expire automatically after six (6) hours.
For Oracle Database Users!
For Oracle database, the CLOB datatype is not supported by the Reference Data Management. You will be unable to view the contents of a CLOB datatype.
When you click on the Reference Data Management button a page will appear that looks like this.
Click on Get Started to begin querying. You can refer to the Steps to query a result for more information.
Furthermore, you can use these links to navigate to the information you need when working with the dashboard:
Query Result View
One you have gotten a query result, a table toolbar is available at the top of the query result view. This bar allows you to select from the operations that you will want to use Reference Data Management for, such as Query, searching for specific data in the columns, Insert Row, Refresh, Export, Import and Delete.
At the bottom of the view, you get the a status bar that show the total of rows for the entire query result.
Table Toolbar Options
Options | Description |
---|---|
Query | Opens the Query dialog, allowing you to tweak with the expressions or query configurations. Refer to Querying A Table In Reference Data Management for more information. |
Insert Row | Opens the Insert Row dialog for you to add insert more rows of data into your table. Refer to Inserting rows for more information. |
Refresh | Refreshes the query result view, especially after you have added new rows using the Import function. |
Export | Exports the query result view or the entire table into a file. Refer to Exporting data for more information. |
Import | Imports bulk data from a file into the table. Refer to Importing data for more information. |
Delete | Marks all rows in the query result for deletion. Refer to Removing rows for more information. |
Add Comment