OutputODBC Node

Output Nodes ››
Parent Previous Next

This node allows you to write out data to a ODBC data source, it also allows you to set parameters on how to write out the data.

insert into tablename values(123,'Apple',NULL,123.456)

If any DISCRETE data element contains the single quote then the SQL statement will contain double single quotes as shown:

DISCRETE data value: Apple'Banana

insert into tablename values(123,'Apple''Banana',NULL,123.456)

Use this option if the Parameter Insert option fails to work for the selected datasource provider.

insert into tablename values(?,?,?,?)

The ? will be populated with the data values for each row of data been inserted.

NOTE: This option is the fastest method of inserting large amounts of rows into the database.

NOTE: Global Constants can be used within the UserName, Password and Table Name entries.

OutputODBC Functionality

NOTE: To be able to use the OutputODBC Node you require to install the "Microsoft Data Access Components" (MDAC) libraries. The procedure for installing MDAC is as follows:

Both of these libraries can be downloaded from the Microsoft MDAC web site.