Learn more
 

Ready to get started?

Learn more or sign up for a free trial:

CData Sync

In this article

Related articles

Replicate Multiple Business b-ridge Accounts


Replicate multiple Business b-ridge accounts to one or many databases.

CData Sync for Business b-ridge 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 Business b-ridge connections. In this article we show how to use the CLI to replicate multiple Business b-ridge accounts.

Configure Business b-ridge Connections

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

Windows

<?xml version="1.0" encoding="UTF-8" ?> <CDataSync> <DatabaseType>SQLite</DatabaseType> <DatabaseProvider>System.Data.SQLite</DatabaseProvider> <ConnectionString></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></ConnectionString> <ReplicateAll>False</ReplicateAll> <NotificationUserName></NotificationUserName> <DatabaseConnectionString>Data Source=C:\my.db</DatabaseConnectionString> </CDataSync>

When connecting to Business b-ridge, CompanyKey, ProjectKey, and SubscriptionKey are required.

To obtain the SubscriptionKey, follow the steps below:

  • Log in to Business b-ridge API Protal and go to "Profile" in the "Your name" menu.
  • In your subscription section click "Main Key" to retrieve their respective values.

Authenticate to Business b-ridge Account

Set the following connection properties to connect:

  • CompanyKey: Set the Business b-ridge Company Key of the connection destination.
  • ProjectKey: Set the Business b-ridge Project Key of the connection destination.
  • SubscriptionKey: Set the value "Subscription Key".

Configure Queries for Each Business b-ridge 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 Business b-ridge API. The statement below caches and incrementally updates a table of Business b-ridge data:

REPLICATE CDATA;

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 Business b-ridge accounts into the same database:

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

REPLICATE PROD_CDATA SELECT * FROM CDATA

Alternatively, you can use a different schema:

REPLICATE PROD.CDATA SELECT * FROM CDATA

Run Sync

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

Windows

BusinessBridgeSync.exe -g MyProductionBusinessBridgeConfig.xml -f MyProductionBusinessBridgeSync.sql

Java

java -Xbootclasspath/p:c:\sqlitejdbc.jar -jar BusinessBridgeSync.jar -g MyProductionBusinessBridgeConfig.xml -f MyProductionBusinessBridgeSync.sql