We are using Quickbooks Enterprise (running on a local server, not hosted) and we are considering using Financial Force. Can someone explain or point me to the procedure(s) & tool(s) that I can use to transfer our data from QBE to FF? Thanks!
In general, you'd normally be looking for an ETL tool and there are a number of vendors that offer them for Quickbooks in the App Exchange.
The fact that your server is local could make that problematic unless you want to connect your server as an endpoint with Salesforce. Otherwise, I'd expect you to need to export the data from Quickbooks as CSV files, then import it into Salesforce using Dataloader or another tool of your choice. It's also conceivable that you could "back-up" your QuickBooks data to the cloud via the net (like uploading to a "data pool"), then have a Salesforce integration tool send it to Salesforce for you from there (not certain it would be worth the effort).
I'd recommend talking with vendors Quickbooks integration vendors on the App Exchange and/or other integration vendors to get their recommendations for how to connect your server's database with Salesforce, then decide what solution fits your budget.
Getting data into FinancialForce is essentially getting data into Salesforce. Some of the objects you want to populate are FF objects, but others are standard SF objects.
So are you asking about the best Salesforce ETL tool? Is budget an issue? Flexibility? Underlying language?
I've used Talend to get data into and out of SF tons of times and its incredibly powerful. It's also a bit flaky and lacks robust documentation, but as I was using Talend's free version, that's par for the course. If people understand ERD's, and can handle a bit of scripting, they can handle Talend.
You can pay for other tools like Informatica, but the price-tag for a one-time data migration might be a bit much.
I'd say something like data loader isn't in fact your first choice. Data loader is fine for one or two objects, but chances are you'll want to run this integration again and again, building it up iteratively. You're better spent putting the hours into a migration template/script than the hours into a manual migration.
Or you could build Apex scripts in Salesforce that suck the data in (presuming you can directly access QB Enterprise, or cleanly and repeatedly export the data to an accessible structure).
Other options besides FinancialForce are Accounting Seed and Breadwinner. Sage Live might some day be a great option, but as of Dec 2015, I'd let someone else be the guinea pig.