Tips and Tricks

In this section:

This section describes some tips and tricks that can be used.


Top of page

x
Omitting Destination Records

Records for the destination table can be filtered by including an iFL test. If the test is present, it is evaluated on each row. If the test evaluates as true, then the record is not written to the destination.

Some methods to indicate that a specific record should be omitted, might be to include an attribute in the root of the XML that is returned to the iterator, which would normally become the next destination record. For example, the test might be:

_iwxpath(/root/@omit)=true

A special register (SREG) can also be set with a predetermined name, such as omit, and the test would then be:

_sreg('omit', 'false')='true'

Top of page

x
Using the Generic JDBC Driver Definition

The Data Tools Project (DTP) does not provide a predefined JDBC driver template for SQL Server Version 2008. However, the generic JDBC driver definition can be used.



x
Procedure: How to Use the Generic JDBC Driver Definition

To use the generic JDBC driver definition:

  1. Using the New Driver Definition wizard, select the Generic JDBC Driver, as shown in the following image.

  2. Add the sqljdbc4.jar file, as shown in the following image.

  3. In the Properties tab, set the Driver Class property to:
    com.microsoft.sqlserver.jdbc.SQLServerDriver

    For example:

  4. To use the definition, select Generic JDBC in the New Connection Profile wizard, as shown in the following image.

  5. Enter the connection information for the database, as shown in the following image.

  6. If any properties are required, such as the instance name, enter them using the Optional tab in the Properties section, as shown in the following image.

  7. Click the Test Connection button to verify that your connection is working.

iWay Software