User wants assistance in adding TiDB as a destination connector.
I want to add TiDB as destination connector, anyone can help me add it?
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.
Sure, I can guide you through the process of adding TiDB as a destination connector in Airbyte. Here are the steps: 1. Log into your Airbyte account. 2. Click on the Destinations tab in the navigation bar found on the left side of the dashboard. 3. Click on + New destination. 4. On the Set up the destination page, select TiDB from the Destination type dropdown. 5. Enter the Name for the TiDB connector. 6. Fill in the following fields: - Host - Port - Username - Password - Database - jdbc_url_params (Optional) Note: When connecting to TiDB Cloud with TLS enabled, you need to specify TLS protocol, such as enabledTLSProtocols=TLSv1.2 or enabledTLSProtocols=TLSv1.3 in the JDBC parameters. Before you start, make sure you meet the following requirements: - To sync data to TiDB with normalization you should have a TiDB database v5.4.0 or above. - Make sure your TiDB database can be accessed by Airbyte. If your database is within a VPC, you may need to allow access from the IP you’re using to expose Airbyte. - You need a user with CREATE, INSERT, SELECT, DROP, CREATE VIEW, ALTER permissions. We highly recommend creating an Airbyte-specific user for this purpose. To create a dedicated database user, run the following commands against your database: sql CREATE USER 'airbyte'@'%' IDENTIFIED BY 'your_password_here'; GRANT CREATE, INSERT, SELECT, DROP, CREATE VIEW, ALTER ON <database name>.* TO 'airbyte'@'%'; You will need to choose an existing database or create a new database. This will act as a default database/schema where the tables will be created if the source doesn’t provide a namespace. For more details, you can refer to the TiDB destination setup guide and requirements in the Airbyte documentation.
but TiDB is not already in destination catalog for selecting
TiDB is archived and won’t be add to the catalog for new instances. You can add manually as custom connector. https://hub.docker.com/r/airbyte/destination-tidb