+ Start a Discussion
bettylbettyl 

a local copy of the company's saleforce database

Hello,

We would like to run a local copy of the database (we have MS SQL server) to extend our report capabilities. Is there anyway to export the data from salesforce.com (sync with it) to create a local replication database?

Thank you in advance.

Betty

Pat.ax105Pat.ax105

Hi Betty,

The API provides for data replication.  I believe some partners also have a pre-built offering.  Check with the BlueWolf group for their replication tool.  Here is some documentation on the replication in the API.

"The sforce API supports data replication, which allows you to store and maintain a local, separate copy of your organization's pertinent salesforce.com data for specialized uses, such as data warehousing, data mining, custom reporting, analytics, integration with other applications, and so on. Data replication provides you with local control and the ability to run large or ad hoc analytical queries across the entire data set without transmitting all that data across the network. " from http://www.sforce.com/us/docs/sforce50/sforce_API_calls_replication.html#wp1453595

Pat

bettylbettyl

Thanks for your message. I am new to salesforce.com. Can you give me some suggestions about this issue?

 

Do I need to create a database (myCompanySaleForceDB) in MS SQL server first?

How to export all related objects to myCompanySaleForceDB?

 

After that, I can follow the �data replication steps� to retrieve the updated data, right?

 

By the way, did anyone perform this kind of activities in the past and would like to share experiences?

 

Thank you very much

 

Betty

DevAngelDevAngel

Hi bettyl,

It's not entirely trivial to set up a database for replication.  Having said that, it's not extremely difficult.  What you need to do is to create a table for each object in salesforce.com that you want to replicate.  You don't have to create all the fields, but just the fields you need for reporting from each object.  The Id field of each object is a primary key.  If you want the relationships between objects defined, you will need to establish those after initially loading the data.

Check out this link to see if there are any in market solutions that meet your needs.

http://www.salesforce.com/partners/solutions.jsp

qmanqman

Hi Betty,

I have a solution that might be of some use to you.  Basically it is code that makes salesforce.com look like a linked server to sql server.  If you have any interest, drop me an email at bemerson @ forceamp.com.

Bill Emerson

Nabamita DeNabamita De
It's a common scenario for the organizations to create a local copy of their Salesforce data or to replicate the data to another Salesforce instance whether for backup or archiving or compliance.
If you are looking for such solution, you may want to have a look in the AppExchange link. (https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000FAAtBUAX)

There's an article on the key functions you can read about (https://www.mydbsync.com/blogs/dbsync-replication-tool-key-functions/). 
richard harding 1richard harding 1
Hi Bettyl ,

I know it's been a while since your posting. I have developed a tool to replicate your Salesforce data to MySql or MSSQL 
. Contact me if you would like a trial copy. Thanks.

rhard2651@gmail.com