Get Started with CData Sync for Marketo



Description

Drop-in, point-and-click synchronization your data migration, ETL, and back-office processes and Marketo. Easily replicate Marketo data to one or many cloud-based and on-premises databases.

CData Sync for Marketo gives you complete control over your Marketo replication. CData Sync is lightweight, stand-alone software that can run behind your firewall or hosted in the cloud.

Marketo Integration

Integrate live Marketo data into the data stores your organization uses for external and internal facing applications. Sync your data warehouse or reporting server with Marketo, or complete a data migration with point-and-click simplicity. CData Sync replicates Marketo data to a variety of traditional and emerging databases.

Syncing databases with Marketo becomes a similar procedure to a data migration or ETL between two relational databases. CData Sync for Marketo models Marketo entities as relational tables, making it easy to configure mappings to your database. Use standard SELECT statements with the REPLICATE keyword to declare replication tasks.

Sync is easy to manage for sales reps, analysts, and DBAs: Use straightforward REPLICATE SELECT statements to configure full or partial replication. Dynamically update schema changes.

Replication tasks can be triggered with the Windows Task Scheduler or the Unix Cron syntax. Schedule email notifications. Use Sync's command-line interface in your batch files.

Sync runs on your server behind firewall or hosted in the cloud. High-performance replication and a light footprint result from smart, incremental upgrades.

Secure by default, all connections to Marketo are encrypted with TLS/SSL out of the box.

Setup Guide

Follow the steps below to replicate Marketo Activities to SQLite. Replicating Marketo to a database consists of the following four basic steps:

  1. On the Connection tab, obtain the connection properties specific to your Marketo account.
  2. On the Database tab, enter the connection properties to the replication database. To connect to an SQLite database, specify the database file.
  3. On the Sync tab, add tables to replicate. By default all tables are replicated. To select the tables to replicate, clear the Replicate All Tables option and click Add Tables.

    By default, each table is replicated in full. To select the columns to replicate, use a REPLICATE SELECT statement.

    The Query column of the table contains the REPLICATE statement that is used to replicate the table. The default REPLICATE SELECT statement requests incremental changes from Marketo since the last time the database was updated.

    You can use a REPLICATE SELECT statement to configure the replication options for a table. You can define global options for all tables on the Sync Options tab.

  4. On the Scheduler tab, click the Enable Windows Scheduler Task option, select a start time, and select the interval.
  5. Click Run to sync the database with Marketo.

You can now access up-to-date Marketo data as an SQLite database:

Next Steps

You can find more guides to replicating Marketo data in the CData knowledge base (KB) and help documentation. Free trials and support are available.

Download Sync

To get started working with live Marketo data, download a free trial.

Driver Technology Documentation

The Sync help documentation includes resources to help you connect to Marketo and execute standard SELECT queries.

Integration Tool Support

The Sync documentation also includes resources to help you configure the replication database.

How to Contact CData Support

If you do not find a guide for your application in the knowledge base or have questions during your trial, contact CData support.

For more information on CData support packages, see Support Options.

 
 
Downloads