InputODBC Node

Input Nodes ››
Parent Previous Next



This node allows you to read in data from a ODBC source, it also allows you to set parameters on how to read in the data.

NOTE: If the data retrieved from the Data Source returns NULL values they are converted into missing values and designated the value '?'.

NOTE: Global Constants can be used within the UserName, Password and SQL Query entries.


C0,C1,C2
1,2,3
4,5,6
7,8,9

select * from Table1.txt

C0,C1,C2
1,2,3
4,5,6
7,8,9

select * from "Table1$"

C0,C1,C2
1,2,3
4,5,6
7,8,9

select * from Table1

select * from Employees

Where "Employees" is a table defined in the Oracle Database


NOTE: To be able to use the InputODBC 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.