Apex Code Development You need to sign in to do that
Don't have an account?
dharmadeveloper ActiveSalesForce over Multiple Organizations
I posted a shorter version of this message over at Rubyforge.
We are currently trying to integrate our Rails app with SFDC for use with multiple organizations and have come up with three possible solutions:
1) Using ActiveSalesForce
2) Building our own data-sync tool with a SOAP handler which captures outbound messages and then grabs data in from SFDC and updates our local MySQL.
3) Using Relational Junction with multiple DBs on our server and using a beforefilter :database_hijack to tell our app which DB to connect to for each connection
My question is whether there is any current functionality in ActiveSalesForce which allows not only for multiple connections to a local DB and Salesforce.com but also multiple accounts/organizations in Salesforce.
Is this something other people have dealt with and, if so, what did they do?
We are currently trying to integrate our Rails app with SFDC for use with multiple organizations and have come up with three possible solutions:
1) Using ActiveSalesForce
2) Building our own data-sync tool with a SOAP handler which captures outbound messages and then grabs data in from SFDC and updates our local MySQL.
3) Using Relational Junction with multiple DBs on our server and using a beforefilter :database_hijack to tell our app which DB to connect to for each connection
My question is whether there is any current functionality in ActiveSalesForce which allows not only for multiple connections to a local DB and Salesforce.com but also multiple accounts/organizations in Salesforce.
Is this something other people have dealt with and, if so, what did they do?
Perhaps, you could take a look at Apatar Open Source, a data integration tool that links databases, files and applications. It enables SalesForce.com connectivity to MySQL, PostgreSQL, Oracle, MS SQL, MS Access, Sybase, FTP, HTTP (POST and GET), SugarCRM, Goldmine CRM, XML (local and web-based), Webdav, Buzzsaw, LDAP, Amazon S3, flat files (.CSV, .TXT), and even Flickr.
Using Apatar's Scheduling function, you can schedule one-time or recurring data transformations. That would allow you to automate data export and import for daily backups or synchronization. You can schedule Apatar to run at a specific time every day.
SalesForce.com/AppExchange overview: http://www.salesforce.com/appexchange/detail_overview.jsp?NavCode__c=&id=a03300000032Vm0AAE
Find online demos that explain how to integrate SalesForce.com with other data sources here: http://www.apatar.com/web_demo.html
For more information, or to download a copy of Apatar, visit http://www.apatar.com
Hope, this tool would help you. Should you have questions, I can be reached through my blog 'Naked Open Source', found at http://www.nakedopensource.com/.
Renat Khasanshyn
Wizard, Apatar Data Integration for Salesforce.com