What is One Click Data Warehouse

Prerequisites

Before using the function of one-click data warehouse (one-click DW), perform the following steps:

Note: Before creating an Object Storage Service (OSS) data warehouse, make sure that Data Lake Analytics (DLA), ApsaraDB for RDS (RDS), and OSS are in the same region. Otherwise, the one-click DW function is unavailable.

RDS

Create an RDS instance as the data source according to your service requirements. For more information, see Quick Start for MySQL, Quick Start for SQL Server, Quick Start for PostgreSQL, or Quick Start for PPAS.

OSS

When using the OSS bucket as a data warehouse for storing RDS data or data in a user-created database based on Elastic Compute Service (ECS), perform the following steps:

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 based on your business needs.

DLA

1. Activate DLA

2. Initialize the password of the DLA primary database account

Procedure

• Create an OSS data warehouse by one click

• Instantly synchronize data

  After you create a data warehouse, you can synchronize data at any time, create the same table structure in the target data warehouse (OSS data warehouse) as in the data source (RDS instance or user-created ECS-based database), and create a corresponding data warehouse table structure in DLA.

• View data synchronization tasks