Database and data transfer

[Mikwin]

Hello,

I have been looking for a data integration technology.

We have been searching and have had some advice. But we have not found the right software yet.  

We are needing the ability to migrate contacts and data on a daily basis. The transfer will be made manually. Maybe someone could help me.

Thanks for the help!

[start_s1]

Hi Mikwin,

You need to use data integration tool. Look at open source ETL tools. One of them is Apatar 

It has connector for Salesforce and connectors for all the databases. What you need is just create your datamap and upload you data from Salesforce to your database. You may run datamaps manually and on scheduled basis. 

Apatar's Salesforce connector supports SOQL queries, reads deleted records, supports bulk API. 

Regards,

start_s

[Rick.Banister]

What seems to be the issues with the solutions you've been researching? It would be premature to recommend a solution without more information.

Open source solutions will create a lot of work for you, which may offset any savings in software licensing. Why do you think you want to make the transfers "manually" (I'm guessing you mean "interactively" ) ? What form is your source data (flat files, etc.)?What is your level of technical proficiency? Are you a SQL programmer? What is your experience level with integration technology in general?

Message Edited by Rick.Banister on 02-24-2010 02:32 PM

Message Edited by Rick.Banister on 02-24-2010 02:32 PM

[Stefan]

We use Demand Tools for manual exports / imports and DBAmp for setting up automated extracts between Salesforce and SQL Server.

Demand Tools has lots of uses to a Salesforce adminstrator and with Dupeblocker from same company is indespensible.

DBAmp is a low cost but very effective and easy to use integration tool but does require some SQL Server knowledge.