...
- Double-click on the new Database Exporter icon on your model view
- In the tab Details:
- Tick the flag Enabled
- Select the Datasource Rating and Billing
- Go to the Query String tab, and enter the query:
| Code Block |
|---|
insert into DEST_CUST_SUMM_BY_REGION |
...
(REGION, TOTAL_LAST_BILL_AMT, AVG_LAST_BILL_AMT) |
...
Values |
...
({Region}, {TotalLastBillAmount}, {AvgLastBillAmount}) |
Press
Note that the pipe to the Database Exporter is dotted – this means that it is a Push pipe. When linking a Stream to a Database Exporter you must always use a Push pipe. This is because you cannot run a Database Exporter on its own; it must always be driven from a Stream (otherwise, it has no data to process).
To test the Database Exporter you will run the Stream Customer Summary by Region. This is because the pipe you created to the Database Exporter is a Push pipe, and so by running this Stream you will push data from the Stream to the exporter.
- Run Analysis on the Stream Customer Summary by Region
- Check the log messages generated in the Console – in particular scroll to the end; you should see messages telling you that data has been exported by your Database Exporter
...