Meta Lead Ads

  1. Home
  2. Docs
  3. Meta Lead Ads
  4. Step 2: Set up data destinations for Meta Lead Ads (Instant Forms)
  5. Option 9: Set up MySQL database as data destination for Meta Lead Ads (Instant Forms)

Option 9: Set up MySQL database as data destination for Meta Lead Ads (Instant Forms)

Description:

MySQL is an open-source relational database management system. It is widely used  for managing data for huge enterprisesMySQL is an open-source relational database management system (RDBMS) that is widely used for managing and storing data. It utilizes Structured Query Language (SQL) for accessing and manipulating data, making it a popular choice for web applications, data warehousing, and more.


Prerequisites:

  • MySQL Hostname
  • Port
  • MySQL Username
  • MySQL Password
  • Database Name
  • Table Name

Getting Started:

  • Go to https://studio.datahash.com/login
  • Enter your credentials to log in
  • Navigate to Files category under Destinations list in the right section.
  • Click on the “MySQL” connector tile


Select the Meta Lead Ads source type.

Now select the connection name you want to integrate and provide a name to it. This is the same connection name you have already connected in the Source connector (Meta Lead Ads Source). After that provide a name to the connection.

Provide the MySQL access credentials. This is the most crucial step where the user needs to provide the credentials which will help Datahash to push the data in the table provided. These credentials are:

  • MySQL Hostname:  Hostname of your SQL Server service.
  • Port: The port number associated with the SQL Server database instance.
  • MySQL Username: Name of the user with the required read/write access to the above database.
  • Password: Password for the username provided.
  • Database Name: The database name in your SQL Server instance where the data will be sent.
  • Table Name: The table name in your SQL Server instance where the data will be pushed.

 Once done, click on Validate Credentials.

Field Mapping: It is a critical step in the process where you need to map your Meta Lead form Fields with the respective MySQL Database Columns.

The Lead ID or ID field in the Lead forms is mandatory to be mapped with MySQL Database column. Ensure correct mapping to avoid any issues in the setup. You can map as many fields as required.

Once done, click on ‘Test Connection’.

Click Finish to complete the setup.

You can see the connected instance in the dashboard.

Adding New Instances and Editing Existing Instances:

  • To add another instance or edit the existing one, click on the Edit icon to open the RACS for the Manage connections.

Adding a new instance:

  • Start the same setup as done above by selecting the lead ads source type and other required fields.

Once done, click ‘Next’ to proceed.

 Provide the MySQL access credentials. Once done, click on Validate Credentials

Field Mapping: It is a critical step in the process where you need to map your Meta Lead form Fields with the respective MySQL Database Columns

The Lead ID or ID field in the Lead forms is mandatory to be mapped with MySQL Database column. Ensure correct mapping to avoid any issues in the setup. You can map as many fields as required.

Once done, click on ‘Test Connection’.

Click Finish to complete the setup.

You can see the newly created instance “Ads connection 2” in the manage existing connection instances table.

Editing an existing connection instance:

  • Click on the connection name in the manage existing instances table to open the setup.
  • Click on the ‘Edit’ icon available at the top right corner to enable the edit mode.

Choose the field value/values which you would like to update. Once done, click on Next

 .

Choose the field value/values which you would like to update. Once done, click on Next

  • Once done, click on the ‘Test connection’ .
  • In case you click on ‘cancel’ during the edit flow, and closes the setup, the previous configuration will keep running as it is. The updates are pushed only when you click on the Finish button.

Cick Finish to complete the setup.

How can we help?