tSybaseIQOutputBulkExec
Gains in performance during Insert operations to a Sybase IQ database.
tSybaseIQOutputBulkExec executes the
Insert action on the data provided.
tSybaseIQOutputBulkExec Standard properties
These properties are used to configure tSybaseIQOutputBulkExec
running in the Standard Job framework.
The Standard
tSybaseIQOutputBulkExec component belongs to the
Databases family.
The component in this framework is available in all Talend
products.
Basic settings
Property Type |
Select the way the connection details
|
Use an existing connection |
Select this check box and in the Component List click the relevant connection component to When reusing an existing Sybase 16 (SQL Note: When a Job contains the parent Job and the child Job, if you
need to share an existing connection between the two levels, for example, to share the connection created by the parent Job with the child Job, you have to:
For an example about how to share a database connection This property is not available when |
DB Version |
Select the version of the Sybase database to be used from the
|
Host |
The IP address or hostname of the database. This property is not available when |
Port |
The listening port number of the database. This property is not available when |
Data Source |
Select the type of the data source to be used and complete the corresponding DSN When FILEDSN is selected, a […] button This property is available when Sybase IQ 15 is selected from |
Database |
The name of the database. |
Sybase Schema |
The schema of the database. |
Username and Password |
The database user authentication data. To enter the password, click the […] button next to the |
Table |
The name of the table to be written. |
Action on table |
On the table defined, you can perform one of the
|
Filename |
Enter the name of the file to be generated and loaded. |
Is client file |
Select this check box if you need to load data from the client side. This property is available when |
Append the file |
Select this check box to add the new rows at the end of |
Schema and Edit schema |
A schema is a row description. It defines the number of fields
When the schema to be reused has default values that are You can find more details about how to Click Edit
schema to make changes to the schema. Note: If you
make changes, the schema automatically becomes built-in.
|
Advanced settings
Additional JDBC Parameters |
Specify additional connection properties in the existing |
Fields terminated by |
Enter the character, string or regular expression used to Warning:
As a combination of tSybaseOutputBulk and tSybaseIQBulkExec, this component does not allow |
Lines terminated by |
Enter the character or sequence of characters used to |
Use enclosed quotes |
Select this check box to use data enclosure |
Include Head |
Select this heck box to include the column header. |
Blank as null |
Select this check box to store the input zero-length |
On file error |
Select the action Sybase performs when an error occurs:
This property is available when |
Message log file |
The path to the MESSAGE LOG file that saves the log information about This property is available when |
Row log file |
The path to the ROW LOG file that saves the log information about reject data, the This property is available when |
Encoding |
Select the encoding type from the list or select |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job level |
Usage
Dynamic settings |
Click the [+] button to add a row in the table The Dynamic settings table is 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 |
Usage rule |
This component is mainly used when no particular |
Bulk-loading data to a Sybase IQ 12 database
This scenario describes a Job that writes data generated by a tRowGenerator component into a file and then bulk-loads the data
from the file to a Sybase IQ 12 database.
Adding and linking the components
-
Create a new Job and add a tRowGenerator
component and a tSybaseIQOutputBulkExec
component by typing their names in the design workspace or dropping them from
the Palette. -
Link the tRowGenerator component to the
tSybaseIQOutputBulkExec component using a
Row > Main connection.
Configuring the components
-
Double-click the tRowGenerator component to
open its RowGenerator Editor. -
Click the [+] button to add two columns and
set their properties:-
id, Integer type, using Numeric.sequence(String,int,int) from the
Functions list to generate sequence
numbers. -
name, String type, using TalendDataGenerator.getFirstName() from the
Functions list to generate random
first names.
-
-
In the Number of Rows for RowGenerator field,
enter the number of rows to be generated. In this example, keep the default
value 100. -
Click OK to close the editor and in the
pop-up dialog box click Yes to propagate the
schema to the next component. -
Double-click the tSybaseIQOutputBulkExec
component to open its Basic settings
view. -
In the Host, Port, Database, Username and Password fields, enter the information required to access the
Sybase IQ 12 database. -
In the Table field, enter the name of the
table into which the data will be writen. In this example, it is staff. - In the Action on table list, select Create table if not exists.
-
In the Filename field, enter the full path of
the file to hold the data.
Saving and executing the Job
- Press Ctrl+S to save the Job.
-
Press F6 to run the Job.
-
In the Sybase Central console, open the table staff to check the data:
As shown above, the table is created with data inserted.
Related scenarios
For use cases in relation with tSybaseIQOutputBulkExec, see the following scenarios: