DataProvider Index Load properties list

DB Data Provider Index Load properties list identifies the connection parameters and other items you define in the Database Configuration window. The properties that are mandatory appear in bold text.

Required properties

Property	Description
Interface	Identifies the method or driver you want to use to connect to the data source.
Host Name	Identifies the data source. Options available on the Host Name list depend on the interface you select. If you use SQLite as a host, type the path and file name to the SQLite database file (For example, c:\mySQLite.db). If a database with the name you specify does not exist, SQLite will create one.
Query	Click the Query icon to open a window where you can create a query that retrieves information from the data source. The selection criteria in the WHERE clause needs to be qualified using the predefined variable LoadIndex. Enclose the LoadIndex with square brackets, because it is evaluated before the query is sent to the database, for example: select * FROM SALES WHERE SA_DELIVERYDATE >'[LoadIndex]' ORDER BY SA_DELIVERYDATE Quote characters differ between database systems. On Microsoft Access databases, use # for datetime values. You can use the Query window to create a simple query, or click the Query Designer icon. See “Query Designer”.
Ascending Index	Opens a window where you can select the attribute that contains the ascending index for delta load.

Optional properties

Property	Description
User and Password	Used in combination to identify an authorized database user, and to protect the database against unauthorized access.
Load Index Value	The maximum value of the ascending index attribute is automatically used and stored when executing a Sybase ETL job or schedule. The Load Index Value is used to simulate the project with the specific value provided by the user. For example: 2005-01-19100
Read Block Size	Determines the number of records retrieved by the component in a single step.
Pre-processing SQL	Click the Pre-processing SQL icon to open a window where you can create a query that runs during component initialization. Queries can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).
Post-processing SQL	Click the Post-processing SQL icon to open a window where you can create a query that runs after all components execute. Queries can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;).
Database	Identifies the database you want to use as data source. If you select this option, you must select an appropriate interface, and in some cases, specify an appropriate user ID and password.
Schema	Identifies the schema/owner you want to use as data source. The objects displayed will be restricted accordingly and new tables will be created in that schema.
Standardize Data Format	Converts incoming date and number information into a standard format that Sybase ETL can move between systems that support different formats. Dates are converted into a format that includes the year, month, day, hour, minute, seconds, and fraction of a second: `YYYY-MM-DD hh:mm:ss.s`. For example, 2005-12-01 16:40:59.123 Numbers are converted with a '`.`' as the decimal separator.
Database Options	Click the Database Options icon to open a window where you can set options that override performance defaults and control the behavior of some transactions. See “Database connection settings”.