Ask Search:
ETL TeamETL Team 

Data Export

My goal is to have a fully automated process that pulls a set of data from salesforce that is available accessible via FTP , or pushed to our server (or something not requiring human intervention). I have a report that currently runs the data I need but have been unable to find a way to electronically deliver that data without  using email. that requires a person to download or save something.

I do have the Salesforce Enterprise license and I am using informatica on my end to load the data to the desired repository, however since informatica wants a whopping $68,000 just for a connector which we are not willing to pay i am looking for an alternative. I am an IT person new to salesforce so while the documentation looks promising I haven't decifered an alternative to the informatica connector yet.

Does anyone have ideas or potentially samples of the of how we can fully automate this data pull?

Glenn WilsonGlenn Wilson
 You could use DemandTools to create a data export scenario and then use the Windows scheduler to run the extract at a specific time.  Specify a shared drive for the file save operation and use that same location as an accessible FTP directory 

GlennW
Neal MengelNeal Mengel
You may be able to use the Apex Data Loader set up in batch mode to Export.
Ludmila RadzevichLudmila Radzevich
Just came across your post today.

You might want to try our tool (www.apatar.com). It provides a simple interface that lets you connect to Salesforce, grab all the data you need, and write it to a file or a database or wherever you need it. And you can certainly schedule the export. Moreover it's is FREE open source app.

Drop me a line at info@apatar.com so that I can give you a quick demo of how to configure the tool and then you'll be able to build whatever Salesforce integration jobs needed yourself.

Ludmila
Salesforce DeveloperSalesforce Developer
We use DBAmp with DBAmp which has lots of capability including the ability to schedule replication of Salesforce tables. It's very reasonably priced, if you have SQL Server skills well worth looking at.
Garrett ZainoGarrett Zaino
Did you ever find a solution for this?
Neal MengelNeal Mengel

The below is from the developer that handles this for us.

Business Integration with SalesForce

We use SqlServer Integration Services (SSIS) with a CozyRoc Addin.

CozyRoc provides quite a few extensions to the basic SSIS environment, but the ones that are used for our purposes are the SalesForce Connection Manager, SalesForce Data Flow Source, and SalesForce Data Flow Destination.

 

Basically you configure the SalesForce Connection Manager with your basic SalesForce credentials, and then use the connection in either the SalesForce Data Flow Source or SalesForce Data Flow Destination.

Both the SalesForce Data Flow Source and Destination are highly configurable and provide a rich amount of functionality. 

A quick side for those that do not know anything about SSIS.

SSIS is the replacement of DTS, basically a graphical tool that allows you to transportation and transformations of data.  You have a very wide range of data flow sources and destinations, which makes it easy to port data from one system to another.  It provides some of the same functionality as Biztalk with a much smaller footprint and fewer management concerns.

We use SSIS to move our data both into and out of Salesforce from and to a variety of datastores.  OpenEdge/Progress Databases, Oracle Databases, SqlServer Databases, Excel and flat file formats.  That’s not an exhaustive list but I think you see the point.

Another nice feature that comes with the CozyRoc add-in is Dataflow sources and Dataflow destinations.  They are basically in memory datasets.  So if you need to send the same data or subsets of data from one system to another (or one flow to another), you can multicast the data to multiple dataflow destinations, and then in another Data Flow task pick up the data using a dataflow source.