Now you will build a sales report and send it by e-mail. In order to follow the tutorial, you will need two simple prerequisites:
As the report will be based on the Jigsaw database you created in Chapter 8, you will need the MySQL server running.
In order to send e-mails, you will need at least one valid Gmail account. Sign up for an account. Alternatively, if you are familiar with you own SMTP configuration, you could use it instead.
Once you've checked these prerequisites, you are ready to start.
Create a new transformation.
Add a Get System Info step. Use it to add a field named
today
. As Type, selectToday 00:00:00
.Now add a Table input step.
Double-click the step.
As Connection, select
js
—the name of the connection to the jigsaw puzzles database.In the SQL frame, type the following statement:
SELECT pay_code , COUNT...