How to Connect TikTok with PostgreSQL
The integration will allow you to get new leads from TikTok and transfer them to PostgreSQL. This allows you to efficiently automate workflows and save a lot of time by not having to manually add each row to the table.
Let's go through the entire TikTok with PostgreSQL setup steps together!
Navigation:
1. What will integration TikTok with PostgreSQL do?
2. How to connect TikTok account?
3. How to connect PostgreSQL account?
4. How to setup data transfer from TikTok to PostgreSQL?
5. An example of the data that will be sent to your PostgreSQL.
6. Auto-update.
To start setup click "Create Connection".
Select a system as the Data Source. In this case, you must specify TikTok.
Next, you need to specify the system to which the data from the TikTok will be transmitted. In this case, you must specify PostgreSQL.
The next step is to select the TikTok account from which SaveMyLeads will get the data.
If there is no account connected to the system, click "Connect account".
Enter your email and password and give all access to work with this account.
When the connected account is displayed in the "active accounts" list, select it.
Attention! If your account is in the "inactive accounts" list, check your access to this account!
Select the Advertising Account and Page from the drop-down list and click Continue.
The next step is to select a PostgreSQL account to which leads will be sent.
If there are no accounts connected to the system, click "Connect account".
Before you start set up, you need:
- Verify that PostgreSQL accepts external connections over TCP/IP.
- Find the port on which deamon listens.
- Verify sure that this port is availabler in both directions for the SaveMyLeads IP server from which you are connecting:
* u1 - 104.131.61.128
* h1 - 159.203.143.246 - Verify that the user has access right from the IP or host of the SaveMyLeads server from which the connector is coming.
Fill the fields with the relevant data where:
- Host - your PostgreSQL domain name specified without additional https:/, /, etc.
- Login - login to PostgreSQL system.
- Password - password in PostgreSQL system.
- Database - the name of the database to which our system will refer.
- Port - port to which we will connect.
You cannot use root, toor, admin, administrator system names to improve security.
When the connected account is displayed in the "active accounts" list, select it.
Attention! If your account is in the "inactive accounts" list, check your access to this account!
Select the table where the data will be transferred.
Now you need to assign variables from the Data Source system to the columns of the table you need.
In this section, the fields will be assigned according to the template. You can completely change it or leave it as is. To add a variable, click on the column field and select the desired variable from the dropdown list. Please note that you can use not only Data Source variables, but also manually entered data.
Click "Continue" when you're done with assigning fields.
Now you see the test data to send to PostgreSQL.
Click "Send test data to PostgreSQL" and go to your PostgreSQL to check the result.
In order for data from TikTok to be transferred multi-venously to PostgreSQL, click "Finish setup".
On the main screen, click on the gear icon to select the name of the connection and select a group for it, if necessary.
When the slider is in the position shown in the picture - auto-update works. If you want to disable communication, click this slider.
This completes the integration setup between TikTok with PostgreSQL! See how easy it is!?
Now you don't have to worry, SaveMyLeads will do everything on its own!