Renta
Renta
  • Product
    Product
    • First-party tracking

      Powerful server-side solution for collect and connect customer data

    • Marketing ETL

      Create secure customer’s data pipelines to any data warehouses

    • ETL Add-on for Google Sheets

      The easiest way to collect your marketing data into spreadsheets

  • Resources
    Resources
    • Blog

      Stories on how to use customer data for company growth

    • Documentation

      Learn how to install, set up, and use Renta tools.

  • Pricing
  • Book a demo
  • Sign in
Sign up for free
  • Product
    Product
    • First-party tracking

      Powerful server-side solution for collect and connect customer data

    • Marketing ETL

      Create secure customer’s data pipelines to any data warehouses

    • ETL Add-on for Google Sheets

      The easiest way to collect your marketing data into spreadsheets

  • Resources
    Resources
    • Blog

      Stories on how to use customer data for company growth

    • Documentation

      Learn how to install, set up, and use Renta tools.

  • Pricing
  • Book a demo
  • Sign in
Sign up for free
Renta
Documentation
ETL pipelines
MySQL Source
  • Integration creating in data warehouse (DWH)
    • Database
    • Table
    • Integration name
    • Table name
    • Update time
    • Overwrite period
  • Integration creating in Google Spreadsheets

MySQL Source

Renta supports data export from MySQL to the following destinations:

  • Snowflake

  • Google BigQuery

  • Amazon S3

  • Clickhouse

  • SQL Server

  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Note: If your database access is restricted by a firewall, then allow connection from next IPs: 13.94.215.246; 116.203.213.108

  2. Go to the integrations catalog

  3. Select MySQL

  4. Add a MySQL database that has the necessary data

  5. Choose the added MySQL database

  6. Specify the destination you want to import the data into

  7. Go to the settings screen and set the necessary configuration:

Database

In this tab, you can choose the database that has required for uploading data.

Table

Specify the tables you want to upload from your database. All tables will be completely copied to the specified data warehouse with the preservation of data types.

Integration name

There is an auto-generated name for your integration and here you can edit it as much as you like.

Both Cyrillic and Latin are permitted, but not more than 100 symbols.

The integration name is displayed on the Integration List page.

Table name

There is an auto-generated name for your table and here you can edit it as much as you like.

Only Latin is permitted, with numbers and “_” symbol.

Update time

You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.

In that case, your integration will update in the period from 5 AM to 6 AM.

Integrations are updated according to the time zone selected in your profile settings.

Overwrite period

The data overwrite period is a retrospective update of data for the selected period.
For instance, if you choose the overwrite period “Last 7 days” - it means that all data for the last 7 days will be deleted and inserted once again with updated data.
Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.

Integration creating in Google Spreadsheets

Take advantage of the free extension available in the Google Workspace Marketplace. In order to do it:

  1. Install the extension Renta Spreadsheets Add-on.

  2. Then go to Google Sheets and in the Tools tab select Renta

  3. Press the Run button.

After that, a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.

Product
  • Marketing ETL
  • First-party data streaming
Popular data pipelines
  • Salesforce → Bigquery
  • Google Ads → Bigquery
  • Facebook Ads → Bigquery
Resources
  • Blog
  • Documentation
  • Privacy policy
  • Terms of service
  • [EBOOK] A modern data analytics stack in a post-cookie world
  • Enhanced Ecommerce Tracking via Google Tag Manager
  • Facebook Conversions API: Everything Marketers Need to Know

RENTA CDP LIMITED. All rights reserved.

Language: