Define the source

You can use the following data sources in the ModuleAttribute Source:

Load data from a file

If you want to load your data from a file, use the following File ModuleAttributes:

ModuleAttribute	Description	Optional
Filename	Full file path and file name
Options - Column Separator	Specifies the column separator if you use one in the file you want to load.
Options - Row Separator	Specifies the row delimiter. The default value is \r\n.	X
Options - Skip Lines Starting With	Specifies which rows to exclude. Rows which start with the specified value are excluded. You can enter more than one value, separated by semicolon.	X
Options - Encoding	Specifies the file encoding format. Allowed values are Default, ASCII, Unicode, UTF32 and UTF8. The Default format uses the encoding of your operating system.	X

If you want to load your data from an ODBC data source, use the following ODBC ModuleAttributes:

ModuleAttribute	Description	Optional
Connection	Use this ModuleAttribute if you want to use one of the connections you have defined in the Connection Manager. The Connection ModuleAttribute replaces the ModuleAttributes DSN, UserID, Password, and ConnectionString. To specify which connection you want to use in your test, right-click into the Value field and select Select database connection from the context menu. In the subsequent dialog, select the connection from the dropdown menu.	X
DSN	Enter the Data Source Name specified in the Windows ODBC Data Source Administrator.
UserID	User of the database which you want to use
Password	Password of the user
Connection String	Specify a connection string instead of DSN, UserID and Password	X
SQL Statement	Any SQL statement
Options - Connection Timeout	Time in seconds after which Tosca aborts an active connection	X
Options - Command Timeout	Time in seconds after which Tosca aborts an active command	X
Options - Byte Array Handling	Defines which encoding Tosca should use if the data type is a byte array.	X

If the columns in your source ODBC database contain NULL values, Tosca BI converts them into empty strings in the target database.