Supported data sources
Updated at:
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 Lindorm data subscription service (the change tracking feature) and process the data yourself with the Apache Kafka SDK 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 Lindorm data subscription service (the change tracking feature) and process the data yourself with the Apache Kafka SDK or Flink Kafka Connector |
| Hadoop Distributed File System (HDFS) | Supported (Data Integration) | No dedicated service — use the Lindorm data subscription service (the change tracking feature) and process the data yourself with the Apache Kafka SDK or Flink Kafka Connector | |
| OSS | Supported (Data Integration) | No dedicated service — use the Lindorm data subscription service (the change tracking feature) and process the data yourself with the Apache Kafka SDK 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 |
Is this page helpful?