Data Management

Scheduling a Data Flow

You can create a schedule that will run a data flow on a specified data and time, or on a recurring basis. You can configure where the logs and outputs are sent. You can also send emails on start, completion, or failure.

To create a schedule for a flow, click the Schedule and E-Mail button () on the ribbon.

The Scheduler window opens, as shown in the following image.


Adding a Target in a Flow

Once a data flow contains all of the fields you need, you can load it to a target data store. 

  • To add a new target, click New Target at the top of the flow canvas, as shown in the following image.

  • To add an existing target, click Existing Target at the top of the flow canvas, as shown in the following image.

    A file picker opens, so you can select the existing target.

Enabling Sampling in a Data Flow

When a data source in a flow has a large volume of data, you can enable sampling for better response time. You can make decisions based on a sample, provided that sample is representative of the entire data set. Data Prep has a built-capability to automatically generate a random sample (with a 99% confidence level and +/- 1% margin of error).

To enable sampling:

Introducing Joins

Your data may be arranged and structured in different ways depending on the size and amount of detail that it provides. Smaller data sources may be saved in a single spreadsheet or flat file, such as a CSV file, making them easy to access and distribute. Larger data sources, however, may contain too many records or fields to efficiently store in a single file.

Preparing and Managing Data

After uploading or connecting to data by clicking Get Data from the Reporting Server browser interface, you can return to the Reporting Server browser interface to prepare or manage more data, or if you choose, visualize your data in WebFOCUS Designer.

From the WebFOCUS start page, click Applications Directories, or, from the Home Page, click the plus menu , and then click Prepare and Manage Data.