Striim 3.9.7 documentation

Using Advanced Setup to filter data based on table values

The following is a general overview of the process. The details will vary depending on which source and target you use and the columns in the selected table(s).

1. In the App Wizard, click the application type you want to create. For the following, we will use Oracle to File.

2. Enter the properties for the database and click Next.

Screen_Shot_2016-06-24_at_8.39.23_AM.png

3. After all checks pass, click Next. If the Striim user has access to many tables, the Read Table Metadata step may take a minute or more.

Screen_Shot_2016-06-24_at_8.40.30_AM.png

4. Select one or more tables, then click Next..

Screen_Shot_2016-06-24_at_8.41.08_AM.png

5. Click Advanced Setup, then click Add Stream.

2016-06-24_08-42-24.png

6. Click Auto Column Map.

my06.png

7. Select the table.

2016-06-24_08-43-16.png

8. Click Add Filter, then select the field you want to filter by from the drop-down menu.

Screen_Shot_2016-06-24_at_8.46.43_AM.png

9. Set the Operator and Value, then click Save.

filters.png

10. Add additional filters if desired, then click Next.

If your template's target is not to Striim, continue with Configuring an app template target.

If your template's target is to Striim, your new application will open in the Flow Designer. See Filtering events using OUTPUT TO and WHERE for a discussion of the underlying TQL.