MySQL Bulk Load Example

This example illustrates the usage of the MySQL Bulk Load Snap. In this pipeline, we map the data using the Mapper Snap, insert it into the target table using the MySQL Bulkload Snap, read the data using the MySQL Select Snap and additionally sending the first document to the output view using the Head Snap.

• Mapper
• MySQL Bulk Load
• MySQL Select

MySQL Execute Example

In this pipeline, the MySQL Execute Snap creates a table pqadb.TAM_SAMPLE_PERSONS_2, with the required field names and the data type. The Snap settings and the output preview after the pipeline execution is as displayed below:

• MySQL Execute

MySQL Insert Example

This example pipeline demonstrates how to insert records to an existing table using the JSON Generator Snap and map them to the MySQL table 'Hues' using the Mapper and the MySQL Insert Snaps, respectively. The failed records are routed to the error view.

• JSON Generator
• Mapper
• MySQL Insert

MySQL Lookup Example

The following example shows how a MySQL object record can be looked up using the MySQL Lookup Snap and record the data using the MySQL Execute Snap. In this pipeline, the MySQL Lookup Snap retrieves data from a table called 'Test1'.

• MySQL Execute
• MySQL Lookup

MySQL Merge Example

In this pipeline, the records from two different input streams are merged into a MySQL table using the MySQL Merge Snap. The upstream input from the Mapper Snap and the CSV Generator Snap are joined by the Join Snap. The new MySQL table will now have the records with columns passed from both the input sources.

• Mapper
• MySQL Select
• MySQL Merge

Execute multiple SQL statements in a MySQL database

This example pipeline demonstrates how to execute multiple SQL statements within a single transaction using the MySQL Multi Execute Snap.

• JSON Generator
• Mapper
• MySQL Multi Execute

Select data from a MySQL database table

This example pipeline demonstrates how to retrieve data from a MySQL database table using the MySQL Select Snap.

• MySQL Select

MySQL Table List Example

In this pipeline, the MySQL Table List Snap lists all the tables from a schema, formats to the JSON, writes to an output view and sends the result to an email address via the Email Sender Snap.

• MySQL Table List
• JSON Formatter
• File Writer
• Email Sender