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?
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 email@example.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.
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.