...
Option | Description | |
---|---|---|
Step Name | Enter the name of this step as it appears in the transformation workspace. This name must be unique within a single transformation. | |
Connection | Select the drop-down menu to select the 'SAP HANA' database connection type. Note that this list is populated only once a database connection has already been established. If no database connection has been established, this list will be blank. Click the Edit, New, and Wizard icons to create or select a connection with the type 'SAP HANA'. | |
Target Schema | Enter the name of the schema for the table in to write data to. This field is important for data sources which allow for table names containing periods ('.') in them. | |
Target Table | Enter the name of the target table. Click the Browse button to view options. | |
File Configuration |
| |
Data File | When the Local Files option is selected, use this field to specify the variable which will name the file created by in the step, according to the mapping. This file will contain the data to be loaded into the database. Optionally, you can select the Browse button to search your system's local files. | |
VFS URL | When the Remote Files option is selected, enter the complete file path needed for accessing the files containing the data you want to import. that the
| |
Remote Data File | When the Remote Files option is selected, use this field to specify the variable which will name the file created by the step, according to the mapping. This file will contain the data to be loaded into the database. Optionally, you can select the Browse button to search file locations. | |
Enable Logging | Select this check box to turn on error logging. When this check box is selected, the following fields are available for editing:
|
...