List of Figures

1.1. CloudConnect Products

3.1. Creating New GoodData Project

3.2. Creating the Demo Project LDM

4.1. Workspace Selection Dialog

4.2. GoodData Platform Sign In Dialog

4.3. CloudConnect Designer Introductory Screen

5.1. Giving a Name to a CloudConnect Project

5.2. Creating GoodData Project from Server Explorer

5.3. Creating GoodData empty Project

6.1. CloudConnect Perspective with Highlighted Navigator Pane and the Project Folder Structure

6.2. Opening the Workspace.prm File

6.3. Workspace.prm File

6.4. CloudConnect Perspective

6.5. CloudConnect Perspective

7.1. CloudConnect Perspective

7.2. Graph Editor with an Opened Palette of Components

7.3. Closing the Graphs

7.4. Rulers in the Graph Editor

7.5. Grid in the Graph Editor

7.6. Components Alignment

7.7. Navigator Pane

7.8. Server Explorer

7.9. Server Explorer - Project Actions

7.10. Server Explorer - CloudConnect Project Actions

7.11. Server Explorer - ETL Graph Actions

7.12. Server Explorer - Searching

7.13. Server Explorer - Working Project View

7.14. Outline Pane

7.15. Another Representation of the Outline Pane

7.16. Properties Tab

7.17. Console Tab

7.18. Problems Tab

8.1. Creating a New Graph

8.2. Giving a Name to a New CloudConnect Graph

8.3. Selecting the Parent Folder for the Graph

8.4. CloudConnect Perspective with Highlighted Graph Editor

8.5. Graph Editor with a New Graph and the Palette of Components

8.6. Components Selected from the Palette

8.7. Components are Connected by Edges

8.8. Extracting Metadata

8.9. Flat File Dialog

8.10. URL Dialog

8.11. Encoding and Record Type in the Flat File Dialog

8.12. Metadata Editor

8.13. Edge Has Been Assigned Metadata

8.14. File URL Editing

8.15. Selecting the Input File

8.16. CSV Reader Settings

8.17. Choose a dataset Dialog

8.18. Field mapping Dialog

8.19. Primary label Dialog

8.20. Running the Graph

8.21. Result of Successful Run of the Graph

9.1. Running a Graph from the Main Menu

9.2. Running a Graph from the Context Menu

9.3. Running a Graph from the Upper Tool Bar

9.4. Successful Graph Execution

9.5. Console Tab with an Overview of the Graph Execution

9.6. Counting Parsed Data

9.7. Run Configurations Dialog

10.1. CloudConnect project deployment from the Server Explorer

10.2. CloudConnect project deployment dialog

10.3. CloudConnect project remote execution

10.4. CloudConnect project remote execution dialog

10.5. CloudConnect project remote execution parameters

11.1. Import CloudConnect Examples (Step 1)

11.2. Import CloudConnect Examples (Step 2)

11.3. Import CloudConnect Examples (Step 3)

11.4. Set the CloudConnect Demo as working project

12.1. HR example LDM

12.2. HR CloudConnect Graph

12.3. Setting phase

12.4. Primary label identification

12.5. Primary label identification in the Extract Metadata from GoodData Dataset Dialog

12.6. Primary label identification in the Field mapping Dialog

13.1. Forex CloudConnect Graph

13.2. Forex Reformat Component

13.3. Forex Dataset Field Mapping

14.1. Create New Salesforce Connection

14.2. Enter username, password, and security token

14.3. The SOQL query editor supports query validation

14.4. SF Reader mandatory fields

15.1. Create New Google Analytics Connection

15.2. Enter username and password

15.3. The Google Analytics Dimensions & Metrics editor supports query validation

16.1. The Twitter REST API CloudConnect Graph

16.2. The HTTP Connector Attributes

17.1. Import CloudConnect Advanced Examples (Step 1)

17.2. Import CloudConnect Advanced Examples (Step 2)

17.3. Import CloudConnect Advanced Examples (Step 3)

19.1. List All Deployed CloudConnect Projects API

19.2. Deployed CloudConnect Projects Detail API

19.3. CloudConnect Projects Execution API

19.4. CloudConnect Projects Execution Detail API

20.1. CloudConnect Projects Scheduling

20.2. Schedule Detail

20.3. Schedule Executions

21.1. Login Dialog

21.2. Login Dialog

21.3. Notification Channel Configuration

21.4. Notification Channel Detail

21.5. Create a new subscription

22.1. URL File Dialog

23.1. Import (Main Menu)

23.2. Import (Context Menu)

23.3. Import Options

23.4. Import Projects

23.5. Import Graphs

23.6. Import Metadata from XSD

23.7. Import Metadata from DDL

24.1. Export Options

24.2. Export Graphs

24.3. Export metadata to XSD

25.1. Setting Up Memory Size

25.2. Custom CloudConnect Settings

27.1. Selecting the Edge Type

27.2. Creating Metadata on an empty Edge

27.3. Assigning Metadata to an Edge

27.4. Metadata in the Tooltip

27.5. Properties of an Edge

27.6. Filter Editor Wizard

27.7. Debug Properties Wizard

27.8. View Data Dialog

27.9. Viewing Data

27.10. Hide/Show Columns when Viewing Data

27.11. View Record Dialog

27.12. Find Dialog

27.13. Copy Dialog

28.1. Creating Internal Metadata in the Outline Pane

28.2. Creating Internal Metadata in the Graph Editor

28.3. Externalizing and/or Exporting Internal Metadata

28.4. Selecting a Location for a New Externalized and/or Exported Internal Metadata

28.5. Creating External (Shared) Metadata in the Main Menu and/or in the Navigator Pane

28.6. Internalizing External (Shared) Metadata

28.7. Extracting Metadata from Delimited Flat File

28.8. Extracting Metadata from Fixed Length Flat File

28.9. Setting Up Delimited Metadata

28.10. Setting Up Fixed Length Metadata

28.11. Selecting Dataset in the GoodData metadata wizard

28.12. Selecting the primary label for multi-label attribute

28.13. Extracting Metadata from Salesforce

28.14. Extracting Metadata from Google Analytics

28.15. Extracting Metadata from XLS File

28.16. Extracting Internal Metadata from a Database

28.17. Database Connection Wizard

28.18. Selecting Columns for Metadata

28.19. Generating a Query

28.20. DBF Metadata Editor

28.21. Creating Database Table from Metadata and Database Connection

28.22. Metadata Editor for a Delimited File

28.23. Metadata Editor for a Fixed Length File

29.1. Salesforce connection dialog

30.1. Facebook connection dialog

31.1. ExactTarget connection dialog

32.1. Google Analytics connection dialog

33.1. Creating Internal Database Connection

33.2. Externalizing Internal Database Connection

33.3. Internalizing External (Shared) Database Connection

33.4. Database Connection Wizard

33.5. Adding a New JDBC Driver into the List of Available Drivers

34.1. Edit JMS Connection Wizard

35.1. Creating Internal Lookup Table

35.2. Externalizing Wizard

35.3. Selecting Lookup Table Item

35.4. Lookup Table Internalization Wizard

35.5. Lookup Table Wizard

35.6. Simple Lookup Table Wizard

35.7. Edit Key Wizard

35.8. Simple Lookup Table Wizard with File URL

35.9. Simple Lookup Table Wizard with Data

35.10. Changing Data

35.11. Database Lookup Table Wizard

35.12. Appropriate Data for Range Lookup Table

35.13. Range Lookup Table Wizard

35.14. Persistent Lookup Table Wizard

35.15. Aspell Lookup Table Wizard

36.1. Creating a Sequence

36.2. Editing a Sequence

36.3. A New Run of the Graph with the Previous Start Value of the Sequence

37.1. Creating Internal Parameters

37.2. Externalizing Internal Parameters

37.3. Internalizing External (Shared) Parameter

37.4. Example of a Parameter-Value Pairs

39.1. Dictionary Dialog with Defined Entries

40.1. Pasting a Note to the Graph Editor Pane

40.2. Enlarging the Note

40.3. Highlighted Margins of the Note Have Disappeared

40.4. Changing the Note Label

40.5. Writing a New Description in the Note

40.6. A New Note with a New Description

40.7. Folding the Note

40.8. Properties of a Note

41.1. CloudConnect Search Tab

41.2. Search Results

44.1. Selecting Components

44.2. Components in Palette

44.3. Removing Components from the Palette

45.1. Edit Component Dialog (Properties Tab)

45.2. Edit Component Dialog (Ports Tab)

45.3. Simple Renaming Components

45.4. Running a Graph with Various Phases

45.5. Setting the Phases for More Components

45.6. Running a Graph with Disabled Component

45.7. Running a Graph with Component in PassThrough Mode

46.1. Defining Group Key

46.2. Defining Sort Key and Sort Order

46.3. Transformations Tab of the Transform Editor

46.4. Copying the Input Field to the Output

46.5. Transformation Definition in CTL (Transformations Tab)

46.6. Mapping of Inputs to Outputs (Connecting Lines)

46.7. Editor with Fields and Functions

46.8. Input Record Mapped to Output Record Using Wildcards

46.9. Transformation Definition in CTL (Source Tab)

46.10. Java Transform Wizard Dialog

46.11. Confirmation Message

46.12. Transformation Definition in CTL (Transform Tab of the Graph Editor)

46.13. Outline Pane Displaying Variables and Functions

46.14. Content Assist (Record and Field Names)

46.15. Content Assist (List of CTL Functions)

46.16. Error in Transformation

46.17. Transformation Definition in Java

47.1. Viewing Data in Components

47.2. Viewing Data as Plain Text

47.3. Viewing Data as Grid

47.4. Plain Text Data Viewing

47.5. Grid Data Viewing

47.6. XML Features Dialog

48.1. Viewing Data on Components

48.2. Viewing Data as Plain Text

48.3. Viewing Data as Grid

48.4. Plain Text Data Viewing

48.5. Grid Data Viewing

50.1. Source Tab of the Transform Editor in Joiners

53.1. SOQL Query

53.2. Salesforce Mandatory Fields

53.3. FQL Query

53.4. Dimensions & Metrics

53.5. EventStore reader field mapping

53.6. EventStore Time Intervals

53.7. Source Tab of the Transform Editor in DataGenerator

53.8. Generated Query with Question Marks

53.9. Generated Query with Output Fields

53.10. Mapping to CloudConnect fields in EmailReader

53.11. XLS Mapping Dialog

53.12. XLS Fields Mapped to CloudConnect Fields

53.13. The Mapping Dialog for XMLExtract

53.14. Parent Elements Visible in XML Fields

53.15. Editing Namespace Bindings in XMLExtract

54.1. GD Dataset Writer Attributes

54.2. Specifying target dataset

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

54.4. Mapping dialog that references another dataset

54.5. Selecting the primary label for multi-label attribute

54.6. Creating new EventStore

54.7. EventStore writer field mapping

54.8. EmailSender Message Wizard

54.9. Edit Attachments Wizard

54.10. Attachment Wizard

54.11. Create Mask Dialog

54.12. Mapping Editor

54.13. Adding Child to Root Element.

54.14. Wildcard attribute and its properties.

54.15. Attribute and its properties.

54.16. Element and its properties.

54.17. Mapping editor toolbar.

54.18. Binding of Port and Element.

54.19. Generating XML from XSD root element.

54.20. Source tab in Mapping editor.

54.21. Content Assist inside element.

54.22. Content Assist for ports and fields.

55.1. Source Tab of the Transform Editor in the Denormalizer Component

55.2. Example MetaPivot Input

55.3. Example MetaPivot Output

55.4. Source Tab of the Transform Editor in the Normalizer Component

55.5. Source Tab of the Transform Editor in the Partitioning Component

55.6. Source Tab of the Transform Editor in the Rollup Component (I)

55.7. Source Tab of the Transform Editor in the Rollup Component (II)

55.8. Source Tab of the Transform Editor in the Rollup Component (III)

55.9. XSLT Mapping

55.10. An Example of Mapping

56.1. Matching Key Wizard (Master Key Tab)

56.2. Matching Key Wizard (Slave Key Tab)

56.3. Join Key Wizard (Master Key Tab)

56.4. Join Key Wizard (Slave Key Tab)

56.5. An Example of the Join Key Attribute in ApproximativeJoin Component

56.6. An Example of the Join Key Attribute in ExtHashJoin Component

56.7. Hash Join Key Wizard

56.8. An Example of the Join Key Attribute in ExtMergeJoin Component

56.9. Join Key Wizard (Master Key Tab)

56.10. Join Key Wizard (Slave Key Tab)

56.11. Edit Key Wizard

56.12. An Example of the Join Key Attribute in the RelationalJoin Component

56.13. Join Key Wizard (Master Key Tab)

56.14. Join Key Wizard (Slave Key Tab)

57.1. Foreign Key Definition Wizard (Foreign Key Tab)

57.2. Foreign Key Definition Wizard (Primary Key Tab)

57.3. Foreign Key Definition Wizard (Foreign and Primary Keys Assigned)