Striim 3.9.7 documentation

Using Advanced Setup to map tables to streams

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).

The following example assumes a MySQL table created as follows:

CREATE DATABASE mydb;
USE mydb;
CREATE TABLE mydb.testtable (merchantId char(36), dateTime datetime, amount decimal(10,2), zip char(5));
GRANT INSERT ON `mydb`.`testtable` TO 'striim'@'%'

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

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

my01.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.

my02.png

4. Select one or more tables to map.

my03.png

5. Click Advanced Setup, then click Add Stream.

my05.png

6. Click Auto Column Map to have Striim automatically pick up field names from the source table(s). Alternatively, click Manual Column Map to specify your own names.

my06.png

7. Select the table.

my07.png

8. Repeat steps 5-7 for each additional table.

9. If you choose Manual Column Map, rename the fields of each stream as you wish.

10. Click Save > 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:

my09.png

In the Flow Designer, you can see that the tables have been mapped. The TQL for this is:

CREATE SOURCE ...
OUTPUT TO MySQL2FileWithMaps_ChangeDataStream,
OUTPUT TO MySQL2FileWithMaps_testtable_Stream1 MAP ( table:'mydb.testtable'),
OUTPUT TO MySQL2FileWithMaps_testtable2_Stream2 MAP ( table:'mydb.testtable2');

See Using the MAP function for more details about this syntax.