We assume that you have already learned what is described in:

If you want to find the right Writer for your purposes, see Writers Comparison.

Short Summary

GD Dataset Writer writes data to a GoodData dataset.

Abstract

GD Dataset Writer writes data to a GoodData dataset. It maps the input data to a dataset's data loading columns. The writer supports both incremental loading and loading of all data.

Icon

Ports

This component has one input port and no output ports.

Figure 54.1. GD Dataset Writer Attributes

When you select this component, you must specify a GoodData project and a dataset to which the data will be written. The component takes the current GoodData project by default (the project hash is stored in the GDC_PROJECT_ID parameter)

Figure 54.2. Specifying target dataset

The most important attribute of the GD Dataset Writer is the Field mapping that defines how the input metadata fields map to the GoodData dataset columns. The mapping attribute is defined via the Mapping wizard in multiple steps. The first step involves matching of the input metadata fields (right side of the dialog) to the GoodData dataset's attributes, and facts. You need to select corresponding field in the Input fields drop-down listboxes. The dialog also takes care of the referenced datasets and date dimensions. The matching date dimension must be specified for date fields.

	Note
	See the Extracting Metadata from a GoodData Dataset for more details about deriving CloudConnect metadata from a GoodData dataset.

Figure 54.3. Simple mapping dialog (note the selection of the corresponding DATE dimension)

Similarly a referenced dataset connection point's label must be selected for linking the target dataset's to another dataset.

Figure 54.4. Mapping dialog that references another dataset

There are additional wizard steps for every dataset's attribute with multiple labels. A label that uniquely identifies every attribute's value must be selected in these steps. You'll usually select some kind of ID of the attribute here.

Figure 54.5. Selecting the primary label for multi-label attribute

It is very important to decide whether the records should be appended to the existing records in the dataset (Incremental = true) or whether the current data will be overwritten (Incremental = false).

The component supports advanced retry mechanism that can be parametrized by the Max. retry attempts and Pause between retries [secs] parameters.

GD Dataset Writer Attributes

Attribute	Req	Description	Possible values
Basic
GoodData project ID		Specifies the GoodData project where the target dataset resides. The current project (project's hash in the GDC_PROJECT_ID parameter) is used by default.	Any valid GoodData project hash. The user who is logged in the CloudConnect Designer must have permission to access the project.
Dataset		A target dataset where the data will be written.
Field mapping	yes	Mapping of the input fields to the dataset loading columns. Please use the attribute dialog for the mapping definition. The mapping defines how input fields map to the columns that the selected GoodData dataset uses for data loading.
Incremental		Specifies if the data are appended to the existing data (true) or overwritten (false).	true/false
Advanced
Max. retry attempts		Maximum number of retries that will be attempted if the previous attempts failed. Default value is 5.
pause between retries [secs]		This value specifies the delay between individual retries in seconds. Default is 60 seconds.