Page History

...

• Kafka (Create Adapter → Pipeline (Source → Kafka Sink) → Create Kafka Adapter (validate event schema)
• MQTT (Create Adapter → Pipeline (Source → MQTT Sink) → Create MQTT Adapter (validate event schema)
• MySQL(Create Adapter → Pipeline (Source → MySQL Sink) → Create MySQL Adapter (validate event schema)
• InfluxDB (Create Adapter → Pipeline (Source → InfluxDB Sink) → Create InfluxDB Adapter (validate event schema)
• How to deal with database set adapters?

Kafka

• Precondition:
  • None
  • Use StreamPipes internal Kafka
• Before:
  • Create Adapter (Machine Data Simulator / Flow Rate)
  • Create Pipeline (Machine Data Simulator → Kafka Sink)
    • Configure Sink (Selector: kafka_publisher ) 
      • Type: input Selector: topic Value: #testname
      • Type: input Selector: host Value: kafka
      • Type: input Selector: port Value: 9092
      • Type: radio Selector: access-mode Value: Unauthenticated
• Test:
  • Create Kafka Adapter
    • (Selector: Apache_Kafka ) 
      
      • Type: input Selector: host Value: kafka
      • Type: input Selector: port Value: 9092
      • Type: radio Selector: access-mode Value: Unauthenticated
      • Type: radio Selector: topic Value: #testname
    • Format: json
    • Mark as timestamp: timestamp
    • Name: #testname
  • Validate in live preview: Contain 7 event properties
• Clean Up
  • Delete pipeline
  • Delete two adapter:
    • Kafka
    • Machine Data Simulator

...

• 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: host mysqlHost Value: mysql
      • Type: input Selector: port mysqlPort Value: 3306
      • Type: input Selector: usermysqlUser Value: user1
      • Type: input Selector: password mysqlPassword Value: uYaF8c5bxqaHpEEi
      • Type: input Selector: db mysqlDatabase Value: sp
      • Type: input Selector: table 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:
    • InfluxDBMySQL adapter
    • Machine Data Simulator

Connect

...