DB Data Provider Index Load properties list identifies the connection parameters and other items you must define in the Database Configuration window.
Property |
Description |
---|---|
Interface |
Identify the method or driver you want to use to connect to the data source. |
Host Name |
Identify the data source. The options that appear on the Host Name list depend on the interface you select. |
Query |
Create a query that retrieves information from the data source. Use the predefined variable LoadIndex to qualify the selection criteria in the WHERE clause. Enclose 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. In Microsoft Access databases, use # for datetime values. Use the Query window to create a simple query, or click the Query Designer icon to open the Query Designer. See “Query Designer”. |
Ascending Index |
Select the attribute that contains the ascending index for delta load. |
Property |
Description |
---|---|
User and Password |
Identify an authorized database user, and 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 simulates the project using the specific value provided by the user. For example: 2005-01-19100 |
Read Block Size |
Determine the number of records retrieved by the component in a single step. |
Pre Processing SQL |
Create a script that runs during component initialization. Scripts can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;). |
Post Processing SQL |
Create a script that runs after all components execute. Scripts can include one or more SQL statements. If you use multiple statements, separate them with a semicolon (;). |
Database |
Identify the database to use as data source. If you select this option, you must also select an appropriate interface, and in some cases, specify an appropriate user ID and password. |
Schema |
Identify the schema/owner you want to use as data source. The objects that appear are restricted accordingly and new tables are created in that schema. |
Standardize Data Format |
Convert 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: 2005-12-01 16:40:59.123 Numbers are converted using a period (“ |
Database Options |
Set options that override performance defaults and control the behavior of some transactions. |
Transactional |
All work performed by the DB Data Provider Index Load component, including pre-SQL and post-SQL, is done in a single database transaction that is committed when the project finishes normally. Select this option to roll back the transaction, if this component encounters an error. See “Job components” and “Enabling transactionality for projects and jobs” for information on the “Propagate Rollback” property. |