...
- In your model, add a new database exporter:
- Hover over the stream
Customer Summary by Region
, and press - Add a new Database Exporter - Give the new exporter the Name:
Customer Summary By Region
- Press
- Hover over the stream
...
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
- Open the console - the Console
- Your job will be at the top of the list in the Completed Tasks section - to see messages, double click this
- Check the log messages for this job – in particular scroll to the end; you should see messages telling you that data has been exported by your database exporter
...
- Hover over the icon for the database exporter
Customer Summary By Region
- In the tool bar press - Show Outputs
- The Datasource
Rating and Billing
will appear on your model view - Hover over the icon for the datasource
Rating and Billing
- In the toolbar, press - Show Tables
- Find the table you exported to -
DEST_CUST_SUMM_BY_REGION
- Double-click on the table to bring up the table data - this is the data you just exported