Click the Transformation icon and you will see the Transformation dialog box. Specify what data to move and how you want it to be transformed. In the Transformation dialog box, on the ?Source table? column, you can choose a source table by clicking on its check box. You can select all source tables for copy by clicking
?Select all? button. On the ?Destination table? column, you can choose an existing table or create a new table. Press ?Fill all by order? button and rows of ?Destination table? column will are filled by names of existing Oracle database tables.
4. Execute the transformation.
On the Transformation form, click Execute. DTO will automatically convert the source data to tables in the destination. This program will allow you to:
?Create new tables in your Oracle database.
?Recreate an existent table with new data.
?Add new records to existing table in DB.
?Update a table using special interface.
When you create a new table in your
Oracle database you can update column names, data type and data size of new destination table. For this case DTO will offer you special window with convenient interface. Also this tool allows you to edit column expression. In left field for each new table column you can insert name of source table column, combination of these columns or put expression using special SQL functions. About updating a table using special interface see additional information below.
Important: Do not open a Microsoft Excel file that is being used as a source during the DTO tool execution, because a "file in use" error will occur.
Also the DTO is capable of managing databases. This software has database navigation features that provide the ability to view pictorial representations of your entire database. DTO allows users to see, in graphic detail, Source and Target databases that they are opening for converting. You can see also the complex relationships between tables, indexes, constraints, etc.
After opening Source or Target database DTO graphically displays database objects and allows you to analyze the objects. The DTO trees are populated with database objects by selecting source or destination object from an appropriate Data Transformer dialog box. The tree displays a direct view of the database's objects and the relationships among objects.
Each object type in the tree is identified by an icon and name. If there is a '+' or '-' to the left of an object's icon and name, the object is a container that can be expanded to display other objects. You can expand tree nodes to view the objects and relationships in the database. For example, you can expand a node to view the tables and properties on the database.
If you expand a table, you can access nodes such as fields, indexes, constraints, and properties of this table. By clicking right mouse button on the database tree DTO allows you to:
?Open current table in the tree
?Rename the table selected in tree
?Delete the selected table
Important: Before to update database (to rename or drop tables) you must be sure that your actions will not to result in loss of the information. Also you must have special security permission to this database. Otherwise, you can lose current data.
Storing image data
If your destination database table has columns with special data type BLOB the DTO can be used to store image data, display image information, copy digitized images from table field into files. The DTO allows users to quickly and efficiently store, organize, and import or export their images.
On an expanded current table click the mouse button on the BLOB field record and an image-maintenance menu box should appear. This menu will allow you to:
?Display image information stored in your table
?Save image data from table as a binary file
?Copy image information from file into Oracle DB
For displaying image data containing in your database click ?Display? bar on this menu. You can change the window display size by clicking mouse button on the edge of window frame and pulling it.
Save your image as a file select ?Save as file? option. You will see dialog box where you can choose directory and name your new image file.
Also you can fill some image into a database for later show and retrieval. The Data Transformer for Oracle provides for the easy storage of images into Oracle databases. Click ?Write from file? bar on the menu box and you will see the special ?Select file for writing in current record? dialog box. Specify what file to copy and click Open button. Image data from chosen file will be saved in your database.
Data Updating Interface
This Interface will appear when you try to execute the transformation on the ending of a configuration with DTO tool. The Data Updating Interface is used for building two character expressions. Then these expressions will be used to execute data converting between Source and Target.
Using the Data Updating Interface you can interactively specify transformation rules that govern how data will be copied from the source table to the destination Oracle table.
The Data Updating Interface has three sections:
1. In the upper section of the Interface is an expression box where you build the Constraint expression. Use the lower section of the Interface to create elements of the Constraint expression, and then paste these elements into the expression box to form an expression. You can also type parts of the expression directly into the expression box.
2. In the middle section of the Interface is an expression box where you build the Set expression for each column of destination table. Use the lower section of the Interface to create elements of the Set expression, and then paste these elements into the expression box to form an expression. You can also type parts of the expression directly into the expression box.
3. In the lower section of the Interface are the following parts: In the upper-left box are buttons for commonly used operators. If you click one of the operator buttons, the Data Updating Interface inserts the operator at the insertion point in the one of expression boxes. For a complete list of operators and constants you can use in expressions, click the lower-left boxes, which content all operators and constants.
The two right boxes contain lists of the Source table columns and Target table columns, which you can insert into your expressions.
Create an expression using the Data Updating Interface
In the lower section of the Data Updating Interface, double-click the element you want.
When you paste an identifier in your expression, the Data Updating Interface pastes only the parts of the identifier that are required in the current context.
Paste any operators you want in the expression by placing the insertion point in the expression box where you want the operator, and clicking one of the operator buttons that are in the upper-left box of the lower section of the Interface.
When both of your (Constraint and Set) expressions are complete, click OK.
The article describes how to solve the conversion problem. It is not production software?