Page History

...

Precondition:
- Install a MySQL database
Before:
- Create Adapter (Machine Data Simulator / Flow Rate)
- Create Pipeline (Machine Data Simulator → MySQL Sink)
  - Configure Sink (Selector: mysql_database)
    - Type: input Selector: host Value: mysql
    - Type: input Selector: port Value: 3306
    - Type: input Selector: user Value: user1
    - Type: input Selector: password Value: uYaF8c5bxqaHpEEi
    - Type: input Selector: db Value: sp
    - Type: input Selector: table Value: #testname
Test:
- Create Kafka Adapter TBD
  - (Selector: MySQL )
    - Type: input Selector: mysqlHost Value: mysql
    - Type: input Selector: mysqlPort Value: 3306
    - Type: input Selector: mysqlUser Value: user1
    - Type: input Selector: mysqlPassword Value: uYaF8c5bxqaHpEEi
    - Type: input Selector: mysqlDatabase Value: sp
    - Type: input Selector: mySQLTable Value: #testname
    - Type: radio Selector: replaceNullValues Value: Yes
  - Mark as timestamp: timestamp
  - Name: #testname
- Validate in live preview: Contain 7 event properties
Clean Up
- Delete pipeline
- Delete two adapter:
  - MySQL adapter
  - Machine Data Simulator

Connect

...

Schema Rules
- Add fixed property
- Add timestamp
- Rename
- Add nested
- Move
- Delete
Value Rules
- Number transformation
- Unit transformation
- Privacy transformation
- Timestamp transformation
  - UNIX timestamp sec
  - REGEX
Stream Rules
- Aggregation
- Remove Duplicates

...