LindormTable supports data migration to and from relational databases, NoSQL databases, big data systems, and file systems. Before you start, identify which migration service handles your source or destination — this determines the tools and procedures to use.
Choose a migration service
Three services handle LindormTable data migrations. Select the one that matches your source or destination:
| Service | When to use |
|---|---|
| Lindorm Tunnel Service (LTS) | HBase, MaxCompute, CSV, and Parquet imports; HBase Performance-enhanced Edition and Kafka exports; incremental import for HBase 1.x, HBase 2.x, and Performance-enhanced Edition; incremental Kafka export |
| Data Integration | Relational databases (MySQL, PolarDB, PostgreSQL, Oracle, SQL Server) and Cassandra imports; most big data and file system exports; Cassandra and MongoDB exports |
| Data Transmission Service (DTS) | MongoDB imports only |
Incremental export to MaxCompute, HDFS, and OSS has no dedicated service. Use the change tracking feature with Apache Kafka SDKs or Flink Kafka Connector instead.
Data Integration is a data synchronization service provided by the open source platform DataWorks.
Import data to LindormTable
| Category | Source | Full import | Incremental import |
|---|---|---|---|
| Relational databases | MySQL | Supported (Data Integration) | Not supported |
| PolarDB | Supported (Data Integration) | Not supported | |
| PostgreSQL | Supported (Data Integration) | Not supported | |
| Oracle | Supported (Data Integration) | Not supported | |
| SQL Server | Supported (Data Integration) | Not supported | |
| NoSQL | HBase 1.x | Supported (LTS) | Supported (LTS) |
| HBase 2.x | Supported (LTS) | Supported (LTS) | |
| ApsaraDB for HBase Standalone Edition | Supported (LTS) | Not supported | |
| ApsaraDB for HBase Performance-enhanced Edition | Supported (LTS) | Supported (LTS) | |
| Cassandra | Supported (Data Integration) | Not supported | |
| MongoDB | Supported (DTS) | Supported (DTS) | |
| Big data systems | MaxCompute | Supported (LTS) | Not supported |
| File systems | CSV | Supported (LTS) | Not supported |
| Parquet | Supported (LTS) | Not supported |
Export data from LindormTable
| Category | Destination | Full export | Incremental export |
|---|---|---|---|
| Relational databases | MySQL | Supported (Data Integration) | Not supported |
| PolarDB | Supported (Data Integration) | Not supported | |
| PostgreSQL | Supported (Data Integration) | Not supported | |
| Oracle | Supported (Data Integration) | Not supported | |
| SQL Server | Supported (Data Integration) | Not supported | |
| NoSQL | ApsaraDB for HBase Standalone Edition | Not supported | Not supported |
| ApsaraDB for HBase Performance-enhanced Edition | Supported (LTS) | Supported (LTS) | |
| Cassandra | Supported (Data Integration) | Not supported | |
| MongoDB | Supported (Data Integration) | Not supported | |
| Big data systems | MaxCompute | Supported (Data Integration) | No dedicated service — use the change tracking feature with Apache Kafka SDKs or Flink Kafka Connector |
| Hadoop Distributed File System (HDFS) | Supported (Data Integration) | No dedicated service — use the change tracking feature with Apache Kafka SDKs or Flink Kafka Connector | |
| OSS | Supported (Data Integration) | No dedicated service — use the change tracking feature with Apache Kafka SDKs or Flink Kafka Connector | |
| Kafka | Supported (Data Integration) | Supported (LTS) | |
| File systems | CSV | Supported (Data Integration) | Not supported |
| ORC | Not supported | Not supported | |
| Parquet | Not supported | Not supported | |
| JSON | Not supported | Not supported |
该文章对您有帮助吗？