Replication with Cassandra
Last updated
Last updated
Quick start with step by step process to use DBSync Cloud Replication with Cassandra Database. To know more about Cassandra Database (installation and configuration), please refer the link http://wiki.apache.org/cassandra/HelpForAdministrators
Sign in to the DBSync Replication portal.
Start DBSync Replication console to configure the proxy settings under the global settings option on the home page.
Follow these steps to configure a proxy global settings in DBSync replication portal.
Once, you have logged in then click to "main menu" in the right hand top corner on the home page of DBSync replication portal.
Next, enter the required proxy credentials in different text boxes like proxy host, port, username and password under the global settings section.
Click on save changes button to save a global settings details.
Source application profile Includes Salesforce and Microsoft CRM. The source app profile is created within DBSync Replication platform.
Follow these steps to create a profile under source application like Salesforce and Microsoft CRM.
Click to "add profile" in the right hand-corner of the profiles section of DBSync replication portal.
Select, the required source name application from the drop down menu under the product header.
Next, enter the name of the profile like "testprofile" under the name section.
Click on save changes button to create a new replication profile.
Start with source application setup details includes Salesforce and Microsoft CRM.
The source setup applications details required to configure your Salesforce and Microsoft CRM credentials like "username" and "password".
Follow these steps to configure your source application like Salesforce and Microsoft CRM.
Click to "Salesforce and Microsoft CRM" setup tab on the left hand corner in the profiles section of DBSync Replication portal.
Don't change the "environment and soap end details", all these details are pre-filled.
Once completed, click on next button to proceed to database setup tab.
Start with database setup tab, to fill all the necessary details and follow the same procedure for testing and validating your database credentials.
Follow these steps to configure your database credentials with different databases like MySql, SQL Server, Oracle, DB, PostgreSQL, Cassandra, RedShift, Sybase and MongoDB.
Click to "database" setup tab on the left hand corner in the profiles section of DBSync replication portal.
Select, the required "type name" from the drop down menu options like "MySql, SQL Server, Oracle, DB, PostgreSQL, Cassandra, RedShift, Sybase and MongoDB" under the "database setup" section.
To start with database credentials user has to entered all the configuration details like host, port, username, password, database name and schema.
Once, all the details enter by the user then URL details will get autofilled.
Click on test Connection button to validate your source application login details.
Click on save button to save your source apps login details.
Once completed, click on next button to proceed to advanced settings tab to get the email Id to get the notifications.
Note:
While replicating with Cassandra, please refer the following wiki link for specific details on Replication with Cassandra. http://help.mydbsync.com/docs/display/CloudReplication/3+-+Big+Data+Support
While replicating with Amazon Redshift database, please refer the following wiki link for specific details on Replication with Amazon Redshift. http://help.mydbsync.com/docs/display/CloudReplication/Amazon+Redshift
Start with advanced settings tab, to fill all the necessary details and follow the same procedure for testing and validating Advanced settings credentials.
Follow these steps to configure your Advanced settings credentials.
Click to "advanced" settings tab on the left hand corner in the Profiles section of DBSync replication portal.
Mark the checkbox to "enable database logging" to create auto created table in the database.
Next, Mark the checkbox of "email only on error" to get an email message when error will occur.
Enter an email for "email recipient" to get the notification when any run command is executed.
Click on save button to save your advanced settings details.
Once the process is completed then click on save and next button to proceed further.
Start with Source Application Objects tab, to get synced all the objects when user will get connected to different source applications like Salesforce/Microsoft CRM.
Follow these steps to synced all objects for source application like Salesforce and Microsoft CRM.
Click to "objects" tab on the left hand corner in the Profiles section of DBSync replication portal.
Once, user has connected to source applications like Salesforce and Microsoft CRM then objects will get synced and it will show on the objects tab.
Run menu to select the required commands like update database schema, source apps to database (Clean Copy), source apps to database (Incremental) to execute. As per the above commands here user has to select the Clean copy and Source to Database command to replicate all the sync objects to their database.
Once user has selected and "Run" the Command, then it will redirect to user on the log screen tab to see the status of command is completed or not. Below section explains the steps involved in source apps to database replication.
Run Process | Actions Performed |
Update database schema | Creates source apps schema into database for the selected source apps objects. |
Source apps to database(Clean Copy) | Inserts a clean copy of selected source apps object records into respective database tables & columns. |
Source apps to database(Incremental) | Performs an incremental sync from source apps to database based on the changes / edits made in source. |
Database to Source apps (By Control Flag) | This process is not compatible when Cassandra Database is used for replication. |
Start with Scheduler Jobs tab, here users can schedule the sync using Scheduler Tab.
Follow these steps to schedule the sync using Scheduler tab with scheduler functionality like run commands options, Date, Month and year format settings and repeat Drop-down menu details to set the desired duration to sync the selected objects.
Click to "scheduler jobs" tab on the left hand corner in the Profiles section of DBSync replication portal.
Once, user has connected to source applications like Salesforce and Microsoft CRM then objects will get synced and user can directly select the required process from the command drop-down and configure the frequency of the sync by selecting a desired duration from the Repeat drop-down menu.
Next, "start on" option to select the date, month and year from the drop-down menu to get the objects synced for particular Date and Month format.
Create a task in the "task section" with all the details including task name, action, command and start, date and time.
Once the process is completed then click on save and next button to proceed further.
Next, enter the "username" and "password" credential for Salesforce and Microsoft CRM.
"OR", "Other option for salesforce" click on connect to Salesforce (OAUTH) to enter Salesforce login credentials like "username" and "password" to connect the salesforce application.
Click on test connection button to validate your source application login details.
Click on save button to save your source apps login details.
At this point, both source apps and Cassandra database credentials are configured and saved for your Replication profile. (Note: The database URL can also be entered manually if you know your database Connection string.)
Select any "source apps objects" you want to sync into database from the left objects section as shown below.
Select the object fields you want to sync into database from the"available Fields"section and use"exclude fields"section to filter out fields you don't want to sync into database.
Once completed, click on the"run button" to Run the configuration for the source apps object.
