What is One Click Data Warehouse

Introduction

One Click Data Warehouse (OneClickDw) allows you to configure the ApsaraDB for RDS (RDS) data source and Object Storage Service (OSS) data warehouse (new schema) in the Data Lake Analytics (DLA) console. The system automatically and seamlessly synchronizes data from RDS to OSS at the specified time, and creates the same table structure in OSS as in RDS. You can analyze data in OSS without creating any tables, so that online RDS services are not affected.

Prerequisites

Before you use OneClickDw, you must create a RDS instance and an OSS bucket.

Note: Make sure that the DLA service, RDS instance, and OSS bucket are in the same region.

RDS

Create a RDS instance as the data source. For more information, see Quick Start for MySQL, Quick Start for SQL Server, Quick Start for PostgreSQL, or Quick Start for PPAS.

OSS

Create an OSS bucket as the data warehouse.

1. Sign up for OSS

2. Create a bucket

3. Create a folder

   You can determine whether to create a folder to store RDS data according to your service requirements.

DLA

1. Activate DLA

2. Initialize the password of the DLA primary database account

How to use OneClickDw

• Create schemas by using the wizard

  After you create a schema, DLA automatically synchronizes data from RDS to OSS at the specified time, creates the same table structure in OSS as in RDS, and creates a corresponding OSS table in DLA.

• Instantly synchronize data

  After you create a schema, you can synchronize data at any time, and create the same table structure in OSS as in RDS, and create a corresponding OSS table in DLA.

• View data synchronization tasks