Oracle Data Wizard online help

Table of Contents

What's new

08/22/2007 Oracle Data Wizard 7.8 released

A new version of Oracle Data Wizard, a powerful utility for managing your Oracle data, has been released.

Please consider the list of new features implemented in Oracle Data Wizard 7.8:

•	The main feature of this version is ASP.NET Generator, a powerful tool for producing ASP.NET scripts for the selected tables, views and queries for the further working with these objects through the web. Key features:

•	full customization of the HTML pages appearance with some standard HTML templates provided for your convenience;

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

•	advanced security options allowing you to request user name and password when someone attempts to access your script or to execute some of the specific actions: detailed viewing, adding, editing, or deleting of a table/query row;

•	filtering and sorting abilities of the result scripts;

•	automatic creation of lookup menus for foreign key constraints and custom values;

•	integrated script navigation with customization;

•	ability to create multilingual web apps.

•	New Shell Application with Ribbon toolbars (like Office 2007) and more.

•	PHP Generator: now it is possible to create a lookup menu for a column using a custom value list.

•	Data Pump: now optimized for Microsoft.Jet engine.

•	Data Import: the speed of loading of Excel files was significantly increased.

•	All the wizards: a lot of minor improvements and corrections were made.

11/06/2006 - First public release of Oracle Data Wizard

We are pleased to introduce Oracle Data Wizard 6.11 - a powerful utility for managing your Oracle data.

Oracle Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. It allows you to generate 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.

Product release versions are formalized according to temporal principles: the first figure of the product version stands for the year of release; the second figure of the version is meant to indicate the month of the current version release. Hence the present version is 6.11.

While developing the new software product we tried to implement the usable features available in the existing products and provide it with unique functionality. Please consider the short list of Oracle Data Wizard 6.11 main features below:

•

powerful PHP Generator for creating PHP scripts from 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;

•

Data Pump Wizard implementation: you can convert any local or remote ADO-compatible database with its structure and data to your Oracle database in a few mouse clicks; full customization of the target database and objects: you can create a new database or convert it 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 with the ability of viewing and editing the SQL script generated for the database conversion;

•

easy data export operations: Oracle Data Wizard 6.11 provides a powerful tool for exporting data from Oracle tables and queries 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 to different databases with an ability to select fields to be included into the result files and full customization of the result export files: formats, headers/footers, record count, etc. and powerful options for specific customization: full Excel formatting including notes and hyperlinks, RTF formatting, full HTML and PDF appearance adjustment, and more;

•

efficient tools for importing data: Oracle Data Wizard 6.11 provides a powerful tool for importing data into Oracle tables from different databases with 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 and 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;

•	the Shell Application that provides friendly user interface for working with all the implemented wizards: easy-to-use interface provided by the Oracle Data Wizard will make your work with Oracle data fast and highly efficient;

We hope that you will enjoy working with your Oracle data!

Table of Contents