User Guide : Map Connectors : Source and Target Map Connectors : GoodData
 
Share this page                  
GoodData
This is an add-on connector and is not included in the default installation of Actian DataConnect Studio IDE. The connector is available at esd.actian.com.
Note:  This topic covers connections to GoodData 2011 and later.
GoodData is a web-based cloud computing platform that provides a complete business intelligence platform-as-a-service (BI PaaS) that brings the benefits of cloud computing to the world of business intelligence and data warehousing. Built as a complete integrated platform and offered as a service, GoodData delivers on the fundamental promise of the cloud – on-demand, self-service to deploy and use, and easily adaptable to business requirements. This connector sets field width in characters.
Connector-Specific Notes
Deletes
The GoodData API does not support Delete operations.
Uperts
The GoodData API supports Upsert only when there is a CONNECTION_POINT column in the target dataset, otherwise the Upsert operation will be recognized as Insert.
Non-SLI Data Sets
This connector supports loading data into data sets that are in SLI mode. The new created/replaced data set is also in SLI mode after transformation is complete.
Case Sensitivity
All metadata, including names of projects, datasets and columns, is case-insensitive.
Date Types
If you want to set the value of your target field type as Date, you must use the function DateValue to format it.
Maximum Number of Columns
The maximum number of columns for a single dataset is 64.
Upload Mode
The upload mode "Append" and "Clear and append" work.
Restriction of GoodData Type
In all fields, you must make sure that at least one field's type is Fact or Connection_Point.
Property Options
You can set the following target (T) properties.
Property
S/T
Description
Batch Response
T
Not used.
FlushFrequency
T
Not used.
Upload Mode
T
How to load data into target dataset:
• Append (default) – Insert records directly into the target dataset.
• Clear and append – Clear all data inthe target dataset and append new records.
• Create/Replace – If the specified project does not exist, it will be created. If the target data set does not exist in the specified project, a new data set will be created. If the data set exists, then drop it first and create a new one. Then insert records into the new data set.
Data Types
These are the allowed data types for fields in the target dataset:
• BigDecimal
• BigInteger
• Short
• Double
• Integer
• Long
• Float
• String
• Character
• Date
• Text
Additional Information
This section includes information about the following:
• Custom Field Types
• Parent and Child Records
• Entity Support
• Mapping
Custom Field
The GoodData connector supports the following custom fields.
Custom Field Type
GoodData Display Name
BigDecimal/Double/ Float
DECIMAL
Date
DATE
Short/Integer/Long/ BigInteger
BIGINT
String/Character
VARCHAR
Parent and Child Records
Multi-level records are not allowed in GoodData connectors.
Entity Support
For record entities, only Insert and Upsert are allowed. For a dataset in GoodData, the operation is Insert or Upsert is determined by the CONNECTION_POINT. The records with the same CONNECTION_POINT value replace the existing records in the dataset if the Upload Mode is Append.
Mapping
For the mapping relationship between GoodData Type and DI Type, you can refer to the table below.
For example, if you expect the GoodData Type is Connection_Point, you will fill up the Description as Connection_Point and select one of the Type Text, Character and String in the Map Designer.
Description
DI Type
GoodData Type
Reference
Text, Character, String
Reference
Date
Date
Date
Connection_Point
Text, Character, String
Connection_Point
Attribute
Text, Character, String
Attribute
Fact
Short,Integer,Long,Double,BigInteger,BigDecimal,Float
Fact
null
Text, Character, String
Attribute
 
Short,Integer,Long,Double,BigInteger,BigDecimal,Float
Fact
 
Date
Date
Table Mapping
The "null" means you don't fill up the Description. You will use it for map Fields in the Map Designer.
In the field value for the target reference field, the user must enter a value like: "(schema:reference:value)".if the user not enter a value like that, it will cause error.
For example, the value of the Reference field like: "store:storeid:" & Records("R1").Fields("Store")
"store" is the schema name, in other word, it is the dataset name which is relate to the current dataset.
"storeid" is the name of the connection point field.
Operation
This section includes the following information
• Uploading a file with a new model
• Updating a file and model by changing existing field types
• Updating a file and model by adding/removing a new field
• Adding a new Data Set
Uploading a file with a new model
To create a project and dataset in GoodData
1. Select the Connection as ASCII(Delimited).sc.xml file.
2. In the Source File/URI field, choose the source file with .csv extension.
3. Set the Header property to True.
4. Enter the following Connection information:
5. Server: https://secure.gooddata.com
6. Username: your own username
7. Password: your own password that corresponds to the username
8. To create a new project in GoodData, enter the value as null in the table.
9. Choose the Upload Mode as Create/Replace.
10. Drag all the fields to the Target Record position.
11. Choose the Field Type that you want to use. Use the table mapping that is mentioned above.
12. Since the source file is file1.csv and the Field Count's data type is Integer, select Integer Type for Count Field.
13. Select AfterEveryRecord from the left.
14. Add the ClearMapInsert action.
15. To create a table name, ensure that you use the format (project name).(dataset name). For example, the table name for a for a project named Pervasive and a dataset named file1 is Pervasive.file1.
16. Click the Run Map button.
Updating a file and model by changing existing field types
To update the existing field types for a project and dataset
1. Select the connection ASCII(Delimited).sc.xml
2. In the Source File/URI field, choose the source file with .csv extension.
3. Set the Header to True.
4. Update the following connection information:
5. Server: https://secure.gooddata.com
6. Username: your own username
7. Password: your own password that corresponds to the username
8. From the Table, select the dataset that you want to change.
9. Choose the Create/Replace upload mode.
10. Drag all the fields to the Target Record position
11. Choose the Field Type that you want to use. Use the table mapping that is mentioned above.
12. Add the ClearMapInsert action and select the table name.
13. Click the Run button.
Updating a file and model by adding/removing a new field
To add or remove a field from an existing project or dataset
1. Select the connection as ASCII(Delimited).sc.xml
2. In the Source File/URI, choose the source file with .csv extension. If you want to remove a field, ensure that the source file does not contain the field content.
3. Set the Header to True.
4. Update the following connection information:
5. Server: https://secure.gooddata.com
6. Username: your own username
7. Password: your own password that corresponds to the username
8. From the Table, select the dataset that you want to change.
9. Choose the Create/Replace upload mode.
10. Drag all the Fields to the Target Record position.
11. Choose the Field Type that you want to use. Use the table mapping that is mentioned above.
12. Add the ClearMapInsert action and select the table name.
13. Click the Run button.
Adding a new Dataset
To add a dataset
1. Select the Connection as ASCII(Delimited).sc.xml
2. In the Source File/URI, choose the source file with .csv extension.
3. Set the Header to True.
4. Update the following connection information:
5. Server: https://secure.gooddata.com.
6. Username: your own username
7. Password: your own password that corresponds to the username
8. To create a new dataset in GoodData, enter the value as null in the table.
9. Choose the Create/Replace upload mode.
10. Drag all the Fields to the Target Record position.
11. Choose the Field Type that you want to use. Use the table mapping that is mentioned above.
12. To create a table name, ensure that you use the format (project name).(dataset name).
13. Click the Run button.