Page tree
Skip to end of metadata
Go to start of metadata

This topic provides a high-level overview of how to upload your data to the GoodData platform.

Contents:

Main Concepts

  • CloudConnect is an end-to-end ETL (Extract - Transform - Load) tool. CloudConnect Designer is a logical part of the CloudConnect solution where you create an ETL process that takes data from your data source, transforms it, and load it to Data Warehouse. For more information, see Transform and Load Data Using CloudConnect.
  • Data Warehouse is a data warehousing service where your data is stored. For more information, see Data Warehouse.
  • Automated Data Distribution (ADD) is a feature of the GoodData platform that enables you to upload data from Data Warehouse to your projects. For more information, see Automated Data Distribution.
  • Data Integration Console (DISC) is a part of the GoodData platform where you deploy, schedule, and run data processes. For more information, see Data Integration Console.

Overview

  • If you are a new customer:
    1. Identify the sources from which you want to upload data (CSV, Google sheets, and others).
    2. Run SQL scripts to process the source data and load it to Data Warehouse. You can use:
      1. Your own SQL scripts.
      2. The SQL scripts that GoodData specialists create for you.
        For more details, contact your GoodData Account Manager.
    3. Configure and use Automated Data Distribution (ADD) to transfer your data from Data Warehouse to the projects. See Automated Data Distribution.
    4. Use Data Integration Console to schedule an ADD process to run periodically. See Schedule a Process on the Data Integration Console.
  • If you are an existing customer using CloudConnect:
    1. Identify the sources from which you want to upload data (CSV, Google sheets, and others).
    2. Use CloudConnect to create an ETL process and define the following:
      1. Where to read data from
      2. How to transform the data
      3. Where to write the transformed data to
    3. Use Data Integration Console to deploy the ETL process to the GoodData platform. See Deploy a Process with the Data Integration Console.
    4. Use Data Integration Console to schedule the ETL process to run periodically. See Schedule a Process on the Data Integration Console

For one-time data loads and ad hoc data analysis, use CSV Uploader (see Add Data from a File to a Project).