function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Kee_ganKee_gan 

Anyone moved data from SF to own server databases (Oracle, MSSQL)

Has anyone moved SalesForce.com fields into and your own server? I have two apps one MSSQL, one Oracle and I would like to move SF.com fields (created under Cases) into these DB. I want to know firstly whether it is possible and secondly whether it is easy. Finally I suppose I want to know how you do this, plugins, done completely under Apex or you need some other means to do this. Thanks!
DebarshiDebarshi

hi,

I have moved data from SF to an Oracle Database. It can be done using the Apex Data Loader which you will have to separately download and install from the SFDC website. The procedure is explicitly mentioned in an accompanying doc. Do remember to comply with the prerequisites.
Kee_ganKee_gan
Hi Debarshi, thanks for the reply. I gather that this is for a one time load but not something that can be done in real time. what I want to do is that when I create a Case in SF I want to have a button that I can click that will move (insert) this record to a local DB. I know there will be development work but is this at all feasible.
DebarshiDebarshi

hi,

i don't think what you are trying to achieve is possible at this point of time. As far as my understanding of the SFDC platform goes, as of now, if you want to move data from the SFDC platform to an Oracle Database, you will have to use the Apex Data Loader. 
SuperfellSuperfell
There's a ton of tools to do this including the apex data loader (see data management under setup in the application), and a number of 3rd party tools include dbamp, relational junction, and others, see the integration category on the appexchange site for ideas.
RenatKhRenatKh
Hello, Kee_gan.

Perhaps, you could take a look at Apatar Open Source, a data integration tool that links databases, files and applications. It enables connectivity to both Oracle and MS SQL servers. Using a visual job designer, you can create integration jobs called DataMaps, link data between the source(s) and the target(s), and schedule one-time or recurring data transformations.

The link below is a pre-created DataMap called "Migrating Data from SalesForce.com Account to your Oracle Server".

http://www.apatarforge.org/files/business-management/salesforce.com-to-oracle.html

Another DataMap allows migrating data from SalesForce.com to MSSQL server.

http://www.apatarforge.org/files/business-management/salesforce.com-to-mssql.html

Download Apatar, run the application, open any of these DataMaps, configure them providing the paths to the servers, map the fields you want to extract from SalesForce.com with the fields in your local database, and perform transformations.

For more information, or to download a copy of Apatar, visit http://www.apatar.com

Should you have questions, I can be reached through my blog 'Naked Open Source', found at http://www.apatar.com/blogs/renat.

Renat Khasanshyn
Wizard, Apatar Data Integration for Salesforce.com
Pavel MüllerPavel Müller
Hi, 

have a look at SnowMirror (http://www.snow-mirror.com/). It replicates selected tables and columns into databases such as Oracle or SQL Server. It is simple to setup and easy to use.

Cheers, 
Pavel