Use Data Transmission Service (DTS) to migrate data from a self-managed (on-premises or self-hosted) HBase database to AnalyticDB for MySQL Data Warehouse Edition.
When to use this method
Use DTS to migrate HBase data when:
Your source data is in a self-managed HBase database (on-premises or self-hosted)
Your target is an AnalyticDB for MySQL Data Warehouse Edition cluster (V3.0)
If your data source is a different database type (such as MySQL, PostgreSQL, or MongoDB), refer to the other import methods available in the AnalyticDB for MySQL documentation.
Prerequisites
Before you begin, make sure that you have:
An AnalyticDB for MySQL Data Warehouse Edition V3.0 cluster
Network connectivity between your self-managed HBase environment and Alibaba Cloud
The permissions required by DTS to read from HBase and write to AnalyticDB for MySQL
Migrate data with DTS
Follow the steps in Migrate data from a self-managed HBase database to an AnalyticDB for MySQL V3.0 cluster in the DTS documentation.
Verify the migration
After the migration completes:
Connect to your AnalyticDB for MySQL cluster.
Query the migrated tables to confirm that data is present and accurate.
Compare row counts between the source HBase table and the target AnalyticDB for MySQL table to verify completeness.