Integrating with

Integrating with

SalesForce integration now made possible by open[Fn]

The folks at open[Fn] have just released a integration for SurveyCTO and other ODK-based systems, and we’re very excited to have this new option available to our users. (On days like these, we’re so grateful to be connected to such a thriving open-source community.)

As many of you know, we’ve chosen to focus SurveyCTO almost entirely on data-collection, with the theory being that far better tools exist out there for data visualization and analysis. But if we’re going to send our users to other tools and platforms for working with their data, then we need to at least make it easy to route one’s incoming SurveyCTO data into those other systems. Over the past year, we’ve introduced datasets as a way to flexibly route and combine subsets of incoming data within SurveyCTO, and we’ve built a way to connect datasets to Google Sheets and Google Fusion Tables. It’s technically possible to route data through Google on to many other systems, so we’ve been a bit slow to add other direct connections.

Here, open[Fn] has provided one much-needed direct connection, to the platform.

Now, if you’re thinking, “why would I want my data in SalesForce?”, I have two answers for you:

  1. Despite the fact that their website still markets SalesForce as a CRM (customer relationship management) platform, it’s really a wildly powerful and flexible platform for all kinds of things. For a growing number of organizations, SalesForce is used for data management, monitoring dashboards, data visualization, and all manner of internal applications and processes.
  2. SalesForce is pretty expensive — unless you’re a nonprofit, in which case it’s incredibly cheap. If you’re a nonprofit, the value you can get from using SalesForce dwarfs the cost many times over.

SalesForce is great for lots of things, but data collection is not one of them (particularly offline). That’s why the SurveyCTO+SalesForce combo is such a powerful one: it allows you to use SurveyCTO for what we’re good for (collecting data) and use SalesForce for what they’re good for (managing and visualizing).

And where do these open[Fn] guys come in? Well, they’re a new nonprofit focused on creating social value by helping different technologies connect with one another. In this case, they’ve developed a service that will basically pull your incoming form data from your SurveyCTO server and push it into your SalesForce database(s). All you have to do is give them access to your SurveyCTO server, give them access to your SalesForce databases, and provide them a “map” for where individual form fields should go in your SalesForce system — and they basically take care of the rest.

For all the details, check out their website. There, you can also vote for the new technology integrations you’d like to see. SurveyCTO-ODK-SalesForce is just the beginning: they have many more integrations in store!

Comments (3)

  1. Hi all,
    I’ve heard a lot about salesforce and am excited to try it out, but I find the site too easy to get in.
    I have seen the first couple videos by open[fn] on map and importing the data.
    Could you recommend any tutorials or examples of surveycto/salesforce use?

    • What do you mean that “I find the site too easy to get in”? Is it that you don’t find Salesforce to be secure? They almost certainly have two-factor authentication options for higher levels of security.

      As for other tutorials or examples, we unfortunately haven’t produced any cases yet — but we’ll add a comment here when we do. Vera has worked with several orgs on Salesforce systems, and my impression is that much of the work is in the design and implementation of the Salesforce-side database, forms, dashboards, and overall system. As you saw in the video on mapping, getting data in from SurveyCTO or ODK is the easy part! Early adopters will probably be those who already have an internal Salesforce system and want to extend it to include incoming field data…

      • Hi Chris,
        Oops, important word missing, I meant to say that “I find it very easy to get lost in”!
        I’ll keep a look out for ODK/SurveyCTO/Salesforce pioneers.

Leave a Reply

Your email address will not be published. Required fields are marked *