Converting data with Optim Designer

Use a convert request in an Optim™ interoperability service that will convert data.

Use the convert process to transform data in an extract file. When you convert data in an extract file, you can save the converted data to the same file or as a different extract file. Depending upon circumstances, it may be useful to retain the original file to maintain a consistent starting point. For example, you can create a set of extract files that contain the same data, aged to different dates, by saving the output of each conversion as a separate extract file. Conversely, you can overwrite the original extract file in order to mask sensitive data. .

Comma Separated Values File

Additionally, you can convert an extract (or an archive) file into a comma separated values (*.csv) file, which you can then import into a spreadsheet program or a database. The convert request allows you to select the columns from each joined table that are to be included in the file.

Note: Rows in the comma separated values file are not grouped by table name. Instead, the rows are presented as a joined view with all selected columns listed as a single ‘table'. Thus, a parent row is repeated for each child row.

Table Maps

Specify a table map in a convert request to match tables in the source file to tables in the destination file or to exclude tables from the process. For detailed information on using table maps, see the Common Elements Manual.

Column Maps

Use column maps in the table map to specify which data to convert and how it is to be converted. For complete details on using column maps, see the Common Elements Manual.