Replicate Multiple Vimeo Accounts via the CData Sync CLI

CData Sync for Vimeo is a stand-alone application that provides solutions for a variety of replication scenarios such as replicating sandbox and production instances into your database. Both Sync for Windows and Sync for Java include a command-line interface (CLI) that makes it easy to manage multiple Vimeo connections. In this article we show how to use the CLI to replicate multiple Vimeo accounts.

Configure Vimeo Connections

You can save connection and email notification settings in an XML configuration file. To replicate multiple Vimeo accounts, use multiple configuration files. Below is an example configuration to replicate Vimeo to SQLite:

Windows

<?xml version="1.0" encoding="UTF-8" ?>
<CDataSync>
  <DatabaseType>SQLite</DatabaseType>
  <DatabaseProvider>System.Data.SQLite</DatabaseProvider>
  <ConnectionString>Profile=C:\profiles\Vimeo.apip;ProfileSettings='APIKey=your_personal_access_token';</ConnectionString>
  <ReplicateAll>False</ReplicateAll>
  <NotificationUserName></NotificationUserName>
  <DatabaseConnectionString>Data Source=C:\my.db</DatabaseConnectionString>
  <TaskSchedulerStartTime>09:51</TaskSchedulerStartTime>
  <TaskSchedulerInterval>Never</TaskSchedulerInterval>
</CDataSync>

Java

<?xml version="1.0" encoding="UTF-8" ?>
<CDataSync>
<DatabaseType>SQLite</DatabaseType>
  <DatabaseProvider>org.sqlite.JDBC</DatabaseProvider>
  <ConnectionString>Profile=C:\profiles\Vimeo.apip;ProfileSettings='APIKey=your_personal_access_token';</ConnectionString>
  <ReplicateAll>False</ReplicateAll>
  <NotificationUserName></NotificationUserName>
  <DatabaseConnectionString>Data Source=C:\my.db</DatabaseConnectionString>
</CDataSync>

Vimeo is a professional video hosting platform. The Vimeo API uses personal access tokens (bearer tokens) to enable secure access to video metadata, user information, channels, groups, categories, and related resources.

Using API Key Authentication

To authenticate to the Vimeo API, you will need to provide a personal access token. To obtain your access token:

1. Log in to your Vimeo account at https://vimeo.com
2. Navigate to https://developer.vimeo.com/apps
3. Create a new app or select an existing app
4. Under "Personal Access Tokens", click "Generate" to create a new token
5. Select the required scopes: public and private for read access
6. Copy the generated token

After obtaining your access token, set the following connection properties:

• AuthScheme: Set this to APIKey.
• APIKey: Set this to your Vimeo personal access token.

Example connection string

Profile=C:\profiles\Vimeo.apip;ProfileSettings='APIKey=your_personal_access_token';

Configure Queries for Each Vimeo Instance

Sync enables you to control replication with standard SQL. The REPLICATE statement is a high-level command that caches and maintains a table in your database. You can define any SELECT query supported by the Vimeo API. The statement below caches and incrementally updates a table of Vimeo data:

REPLICATE Videos;

You can specify a file containing the replication queries you want to use to update a particular database. Separate replication statements with semicolons. The following options are useful if you are replicating multiple Vimeo accounts into the same database:

You can use a different table prefix in the REPLICATE SELECT statement:

REPLICATE PROD_Videos SELECT * FROM Videos 

Alternatively, you can use a different schema:

REPLICATE PROD.Videos SELECT * FROM Videos

Run Sync

After you have configured the connection strings and replication queries, you can run Sync with the following command-line options:

Windows

APISync.exe -g MyProductionAPIConfig.xml -f MyProductionAPISync.sql

Java

java -Xbootclasspath/p:c:\sqlitejdbc.jar -jar APISync.jar -g MyProductionAPIConfig.xml -f MyProductionAPISync.sql