Data Manager Module provides you with the following functions:
|
View and Edit Data |
You can open data viewers and editors for database tables, synonyms and views. Data is presented within a scrollable and resizable grid similar to a spreadsheet. You can apply back-end filters and sorts as well as limit number of rows to retrieve for editing. |
|
Data Import Wizard |
Data Import Wizard allows you visually create and execute data import jobs. It provides ability to include multiple import files for a single import job. For each file and database table you can use file preview mode, map file and database table columns and specify a number of other data import options. Data import operation does not block the rest of the application when executing. Data loading process can be monitored and interrupted by the user at any time. Multiple data import jobs can be started simultaneously against the same or different database servers. |
| Data Export Wizard |
Data Export Wizard allows you to visually create and execute data export jobs. Data can be exported based on a single database object, such as table, view or synonym or based on any SQL query. The number of options can be specified, such as ability to log all errors into the file, field delimiter or if to export column headers to a file. Multiple database objects can be exported within a single export job. Multiple export jobs against the same or different database servers can be launched simultaneously. |
| Test Data Generator | Test Data Generator allows you to insert a large amount of test data into database tables. The data can be specified to be random, based on a user-defined text file or come from another database tables. The user can choose the data source for each table column independently from each other. All table referential integrity rules, such as primary and foreign key definitions and NULL constraints, are automatically satisfied. The number of data generation options such as data ranges, sequential data paterns and text and numeric templates can be applied. |
| Cell Editor | Cell Editor window allows you visually edit large text data, which do not fit a grid cell, and import or export binary data and images into a table columns. It also enables editing of complex data, such as ROW TYPES and LISTS using hierarhical tree view. |