The relevant client software for each database type must be installed on each machine you want to export to.
The simplest way to create an export object is to use the drag-and-drop functionality of WhereScape RED.
Creating an Export:
- Browse to the Datawarehouse connection (Browse > Source Tables).
- Create a drop target by double-clicking on the Export object group in the left pane. The middle pane should have a column heading of Export Objects for the leftmost column.
- Select a table or view in the right pane and drag it into the middle pane. Drop the table or view anywhere in the middle pane. The following dialog appears:
- If the export object needs to be renamed, rename it and then click ADD.
The Properties window appears.
- Select the Connection that you want to perform the export from the Connection drop-down list. In this example, the Connection is Windows.
- Select the preferred Export type: File export, Script-based export
- Click the File Attributes tab and fill in the fields as described in the next section.
- Finally, run the export by right-clicking it and selecting Export.