These properties are used to configure tSAPHanaUnload running in the Standard framework.
The Standard tSAPHanaUnload component belongs to the Databases family.
Select either Built-In or Repository:
|Use an existing connection
Select this check box and in the Component List drop-down list, select the desired connection component to reuse the connection details you already defined.
|Enter the IP address or hostname of the database server.
|Enter the listening port number of the database server.
|Enter the name of the database schema.
|Username and Password
|Enter the database user authentication data.
To enter the password, click the [...] button next to the password field, enter the password in double quotes in the pop-up dialog box, and click OK to save the settings.
|Enter the name of the table from which the data will be read.
|Export Location on the SAP HANA host
|Enter the path where you want to store the exported data on the SAP HANA server.
|Additional JDBC Parameters
Specify additional JDBC properties for the connection you are creating. The properties are separated by ampersand & and each property is a key-value pair. For example, ssl=true & sslfactory=com.amazon.redshift.ssl.NonValidatingFactory, which means the connection will be created using SSL.
|Replace the previous exported data
|Select the check box if you want to replace previously exported data with a new version.
|Export database catalog only
|Select the check box if you only want to export the database catalog.
|Do not export underlying dependencies of an export object
|Select the check box if you want to ensure that underlying dependencies of an export object are excluded from exporting.
|Export no statistics
|Select the check box if you wish to exclude exporting any data statistics objects.
|Data & metadata for data statistics objects are exported
|Select the check box to export all data and metadata for data statistics objects.
|Strips attributes that can be reconstructed at input time from the export data
|Select the check box to strip attributes, which may reduce the size of the export file.
|Obfuscate CSV exported data
|Select this option to make the string data of the structure of your database export unrecognizable or difficult to interpret.
|Optional seed (at least 8 to 10 characters)
|Specify the character to be scrambled in your data.
|Specify the number of process threads to be used for concurrent exporting.
|Select this check box to gather the Job processing metadata at the Job level as well as at each component level.
This component is currently in Technical Preview and hidden. To retrieve it, go to.
tSAPHanaUnload exports data to the SAP HANA server.
Click the [+] button to add a row in the table and fill the Code field with a context variable to choose your database connection dynamically from multiple connections planned in your Job. This feature is useful when you need to access database tables having the same data structure but in different databases, especially when you are working in an environment where you cannot change your Job settings, for example, when your Job has to be deployed and executed independent of Talend Studio.
The Dynamic settings table is available only when the Use an existing connection check box is selected in the Basic settings view. Once a dynamic parameter is defined, the Component List box in the Basic settings view becomes unusable.
For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic settings and context variables, see Dynamic schema and Creating a context group and define context variables in it.