Data transfer - Data source / Target "OpenOffice Calc Spreadsheet"

Here you will find the instructions for configuring a data transfer if you selected "OpenOffice Calc spreadsheet" as the type of the data source or the type of the data destination in the first step when creating the connection.

Source / Target - OpenOffice spreadsheet file

Select the file and the time zone here. The file must be stored in a directory that the server has access to.

Click on "Next".

OpenOffice spreadsheet settings

Select the table here.

File contains headers

With this option, the first line is not imported but is used as the column title for the field assignment.

Ignore blank lines

Prevents blank lines from being imported.

Cell area

No range

Uses the entire table.

Range specified by coordinates

Enter the number of the first and last column and row, respectively.

More information

Data transfer

Creating a connection

Target options

Transformation field assignment

Schedule

Subsequent jobs

"Data transfer" application