Last week we were required to figure out a way to extract salesforce.com data using SSIS and store in SQL database. And also pushing local SQL data to Salesforce.com. As we expected, SSIS provides no out-of-box way to interact with Salesforce.com.
With this business case in mind, I spent a week's time to find the possible ways to sync data with salesforce.com.
First thing first, besides reliability and authenticity parameters I came up with few other evaluation criterion for vendors offering Salesforce-SSIS integration toolkit. These are categorized and summarized as:
Features
Vendor
After finalising the evaluation criterion based on our business needs, I shortlisted some well-known vendors who offer Salesforce SSIS integration toolkit:
These vendors were very helpful for arranging technical demos and answering any questions or doubts which we have before trying out POCs.
Management commitment to and support of a vendor evaluation process is imperitive.
P.S. All opionions expressed here are solely mine and do not reflect the values of my employer, client or vendor.
With this business case in mind, I spent a week's time to find the possible ways to sync data with salesforce.com.
First thing first, besides reliability and authenticity parameters I came up with few other evaluation criterion for vendors offering Salesforce-SSIS integration toolkit. These are categorized and summarized as:
Features
- SalesForce Integration mode (SSIS, ADO.Net, Sql Server)
- Other Cloud Vendor integration (Does the vendor offers integration tools besides SalesForce.com?)
- Caching (Usage of local cached data instead of making Salesforce api calls)
- BulkApi Support (Does the connector supports BulkApi connectivity provided by Salesforce?)
Vendor
- Stability (Release cycle of vendor's tools and products)
- Number of clients
- Years in business
- Location
- Support SLA
- Name
- URL
Product
- Name
- Documentation
- Ease of Use
- Support/Knowledge Resources
- Pricing
- Licensing
- Editions
After finalising the evaluation criterion based on our business needs, I shortlisted some well-known vendors who offer Salesforce SSIS integration toolkit:
- Pragmatic Works
- CozyRoc
- DBAmp
- Cdata
- KingswaySoft
- DevArt
These vendors were very helpful for arranging technical demos and answering any questions or doubts which we have before trying out POCs.
Management commitment to and support of a vendor evaluation process is imperitive.
P.S. All opionions expressed here are solely mine and do not reflect the values of my employer, client or vendor.
