SQL Maestro Group / Products / Oracle / Oracle Data Wizard / Documentation

Oracle Data Wizard online help

Welcome to Oracle Data Wizard!

Oracle Data Wizard is a powerful tool for managing your Oracle data. It provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. Oracle Data Wizard allows you to generate ASP.NET and PHP scripts for the selected tables and queries, convert any ADO-compatible database to the Oracle database with its structure and data, export data from Oracle tables and queries to most popular formats, and import data into the tables.

Basic Oracle Data Wizard features

ASP.NET Generator

•	Generating ASP.NET scripts for working with Oracle tables, views and queries.

•	Full customization of the result HTML appearance with some standard HTML templates provided for your convenience.

•	Full customization of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and many more.

•	Protection of your ASP.NET scripts with optional security settings.

PHP Generator

•	Generating PHP scripts for working with Oracle tables and queries from different databases.

•	Full customization of the result HTML appearance with some standard HTML templates provided for your convenience.

•	Full customization of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and many more.

•	Protection of your scripts with optional security settings.

Data Pump

•	Converting any local or remote ADO-compatible database with its structure and data.

•	Full customization of the target database and objects: you can create a new database or convert to the existing one, select objects for conversion and adjust their properties for the target database. Adjustable data import from the source tables to the target ones.

•	The ability of viewing and editing the SQL script generated for the database conversion.

Data Export

•	Data export from Oracle tables and queries to different databases.

•	The ability to export data to any of the 14 available formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX and SQL.

•	Selecting fields to be included into the result files.

•	Full customization of the result export files: formats, headers/footers, record count, etc.

•	Powerful options for specific customization: full Excel formatting including notes and hyperlinks, RTF formatting, full HTML and PDF appearance adjustment, and more.

Data Import

•	Data import into Oracle tables from different databases.

•	The ability to import data from the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV.

•	Easy adjustments of the source file columns and the destination table fields.

•	Full customization of the import process for each imported file including data formats for all or selected fields, commit options, number of rows to skip and records to import, etc.

•	The ability to define the key columns for the table and select whether to skip, update or delete the records if their keys value match the imported ones.

Table of Contents