Video Walkthrough
Description
MySQL is a widely used open-source relational database management system (RDBMS) that stores and manages structured data using SQL (Structured Query Language). It is ideal for storing TikTok Lead Ads data for further analytics, CRM updates, or backend processing.
Prerequisites
Before you start, ensure you have:
- MySQL Hostname (Database server address)
- Port (Default: 3306 unless changed)
- MySQL Username (User with read/write access)
- MySQL Password
- Database Name (Target database where data will be stored)
- Table Name (Target table where leads will be inserted)
Setup Instructions
1 – Log in to Datahash
- Visit https://studio.datahash.com/login
- Enter your credentials and log in
2 – Select MySQL Connector
- In the Destinations section on the right, go to Files category
- Click on the “MySQL” connector tile
3. Choose TikTok Lead Ads Source
- Select TikTok Lead Ads as the source type
- Select the connection name you already configured in the Source Connector (TikTok Lead Ads Source)
- Provide a name for this destination connection
Enter MySQL Credentials
Fill in the required MySQL access details:
- MySQL Hostname: Your database server hostname
- Port: Database port (e.g., 3306)
- MySQL Username: User with read/write access
- Password: User password
- Database Name: Target database name
- Table Name: Target table where data will be inserted
- Click Validate Credentials to confirm access.
Field Mapping
- Map TikTok Lead Form fields to corresponding MySQL table columns
- Lead ID (or ID) field mapping is mandatory
- Map additional fields as required for your workflow
Test & Finish Setup
- Click Test Connection to verify mapping and credentials
- Once successful, click Finish
- The connected instance will now appear in your Dashboard
Managing Connections
Add New Instance
- Repeat the above steps to create another MySQL connection (e.g., different table or database)
- Validate credentials, perform field mapping, test, and finish setup
- The new instance will appear in the Manage Existing Connections table (e.g., “Ads connection 2”)
Edit Existing Instance
- In Manage Existing Connections, click the connection name
- Click the Edit icon (top-right)
- Update credentials, table details, or field mappings
- Click Finish to apply changes
(If you cancel, existing configuration will remain active)
