Skip to main content

Python library to download data from Salesforce and synchronize with a relational database

Project description

salesforce-dbsync

Python library to download data from Salesforce and synchronize with a relational database

Example

This example performs the following steps for Salesforce Object 'Account' when run for the first time:

  • Downloads Table Metadata from Salesforce
  • Downloads Table Data from Salesforce, limited to a maximum of 10000 rows
  • Creates a MySQL Database if one does not already exist
  • Creates Tables in MySQL alongwith Indexes if the Table does not already exist
  • Uploads the data into the MySQL Table

In the subsequent runs, it performs the following steps:

  • Downloads Table Data from Salesforce
  • Refreshes data in MySQL with new records or updates that from Salesforce
  • Note: Deletes in Salesforce are ignored
import sys
from screenwriter import Screenwriter
from salesforce_dbsync import Sync_Manager

def do_init ():
	global sw, sync_mgr
	sw = Screenwriter ()
	db_creds = {'user':'mysql_uid', 'passwd':'mysql_pwd', 'db':'TESTDB'}
	sf_creds = {'user':'sf_uid',    'passwd':'pb_pwd',    'token':'sf_tok'}
	control_map = {'min-SystemModstamp-date':'2019-01-01', 'dml-limit':10000}
	replace_map = {}
        replace_map['UNWANTED-CHAR'] = ' '
        control_map['char-replace-map'] = replace_map
	sync_mgr = Sync_Manager (sw, db_creds, sf_creds, control_map)

def do_main ():
	global sw, sync_mgr
	sync_mgr.add_sync_profile ('Account', ['Name','BillingStreet','BillingCountry'], ["BillingCountry = 'Canada'"])
	sync_mgr.init_mysql ()
	sync_mgr.init_sfdc ()
	sync_mgr.create_missing_db_tables ()
	sync_mgr.sync ()

do_init ()
do_main ()

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for salesforce-dbsync, version 1.4.4
Filename, size File type Python version Upload date Hashes
Filename, size salesforce_dbsync-1.4.4-py3-none-any.whl (8.3 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size salesforce-dbsync-1.4.4.tar.gz (6.0 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page