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

  • 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.
  • CloudConnect is an end-to-end ETL tool. CloudConnect Designer is a logical part of the CloudConnect solution that can be used to 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 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.
    4. Use Data Integration Console to schedule an ADD process to run periodically.
  • 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.
    4. Use Data Integration Console to schedule the ETL process to run periodically.

For one-time data loads and ad hoc data analysis, use CSV Uploader.

Blueprints