Connectors

/

TiDB

Data replication

Sync TiDB data anywhere.

TiDB is a distributed SQL database that is designed to handle large-scale online transaction processing (OLTP) and online analytical processing (OLAP) workloads. It is an open-source, cloud-native database that is built to be highly available, scalable, and fault-tolerant. TiDB uses a distributed architecture that allows it to scale horizontally across multiple nodes, while also providing strong consistency guarantees. It supports SQL and offers compatibility with MySQL, which makes it easy for developers to migrate their existing applications to TiDB. TiDB is used by companies such as Didi Chuxing, Mobike, and Meituan-Dianping to power their mission-critical applications.

  • Standard
  • Alpha
Sync TiDB dataRead the docs
TiDB

One connector

Everything TiDB can do in Airbyte

  • Sync to your warehouse

    Land TiDB data in 50+ destinations on a schedule you control.

    Sync to your warehouse

    Land TiDB data in 50+ destinations on a schedule you control.

  • Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

    Incremental syncs

    Pull only the records that changed since the last run instead of reloading everything.

  • One authorization

    Authenticate TiDB once and Airbyte keeps every scheduled sync running on it.

    One authorization

    Authenticate TiDB once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the TiDB connector on Self-Managed Enterprise.

    Cloud or self-hosted

    Run the TiDB connector on Self-Managed Enterprise.

Specifications

What to know before you sync TiDB

  • Support levelStandard
  • Available onSelf-Managed Enterprise
  • Connector version0.3.5
  • Release stageAlpha

Sync capabilities

  • Full Refresh SyncSupported
  • Incremental SyncSupported
  • Change Data CaptureNot supported
  • Destinations50+ Airbyte connectors

Set up in 12 steps

  1. First, navigate to the Airbyte website and log in to your account.
  2. Once you are logged in, click on the "Destinations" tab on the left-hand side of the screen.
  3. Scroll down until you find the TiDB destination connector and click on it.
  4. You will be prompted to enter your TiDB database credentials, including the host, port, username, and password.
  5. Once you have entered your credentials, click on the "Test" button to ensure that the connection is successful.
  6. If the test is successful, click on the "Save" button to save your TiDB destination connector settings.
  7. You can now use the TiDB destination connector to transfer data from your source connectors to your TiDB database.
  8. To set up a data integration pipeline, navigate to the "Connections" tab on the left-hand side of the screen and create a new connection.
  9. Select your TiDB destination connector as the destination and choose your source connector as the source.
  10. Configure the settings for your data integration pipeline, including the frequency of data transfers and any data transformations that you want to apply.
  11. Once you have configured your data integration pipeline, click on the "Save" button to save your settings.
  12. Your data integration pipeline will now run automatically, transferring data from your source connectors to your TiDB database on a regular basis.

Authentication

Authenticate TiDB once

  • Password

    Password associated with the username.

    Password

    Password associated with the username.

Explore

Related connectors

ClickHouseDatabasesStandard Sources cloudself-managed-enterprise
CockroachdbDatabasesStandard Sources self-managed-enterprise
CouchbaseDatabasesStandard Sources cloud
DynamoDBDatabasesStandard Sources cloudself-managed-enterprise
ElasticsearchDatabasesStandard Sources cloudself-managed-enterprise
FaunaDatabasesStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

TiDB provides access to a wide range of data types, including: Structured data (organized into tables with defined columns and data types, such as CSV, JSON, and Avro files); Semi-structured data (some structure, but not necessarily a fixed schema, such as XML and JSON files); Unstructured data (no predefined structure, such as text, images, and videos); Time-series data (organized by time, such as stock prices, weather data, and sensor readings); Geospatial data (related to geographic locations, such as maps, GPS coordinates, and spatial databases); Machine learning data (used to train machine learning models, such as labeled datasets and feature vectors); and Streaming data (generated in real-time, such as social media feeds, IoT sensor data, and log files). Overall, TiDB's API provides access to a wide range of data types, making it a powerful tool for data analysis and machine learning.

1. First, navigate to the Airbyte website and log in to your account.
2. Once you are logged in, click on the "Destinations" tab on the left-hand side of the screen.
3. Scroll down until you find the TiDB destination connector and click on it.
4. You will be prompted to enter your TiDB database credentials, including the host, port, username, and password.
5. Once you have entered your credentials, click on the "Test" button to ensure that the connection is successful.
6. If the test is successful, click on the "Save" button to save your TiDB destination connector settings.
7. You can now use the TiDB destination connector to transfer data from your source connectors to your TiDB database.
8. To set up a data integration pipeline, navigate to the "Connections" tab on the left-hand side of the screen and create a new connection.
9. Select your TiDB destination connector as the destination and choose your source connector as the source.
10. Configure the settings for your data integration pipeline, including the frequency of data transfers and any data transformations that you want to apply.
11. Once you have configured your data integration pipeline, click on the "Save" button to save your settings.
12. Your data integration pipeline will now run automatically, transferring data from your source connectors to your TiDB database on a regular basis.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving TiDB data today

Free for 14 days on Airbyte Cloud. Set up the TiDB connector once and let Airbyte keep it in sync.

Try it freeTalk to sales