{"id":1474,"date":"2007-10-01T14:32:29","date_gmt":"2007-10-01T14:32:29","guid":{"rendered":"https:\/\/techcafeteria.com\/new\/?p=1474"},"modified":"2014-10-26T14:36:19","modified_gmt":"2014-10-26T14:36:19","slug":"how-to-find-data-exchange-friendly-software","status":"publish","type":"post","link":"https:\/\/techcafeteria.com\/?p=1474","title":{"rendered":"How To Find Data-Exchange-Friendly Software"},"content":{"rendered":"

This article was co-written by Laura Quinn<\/a> of Idealware<\/a> and first published on the NTEN Blog<\/a> in October of 2007.<\/p>\n

\"\"\u00a0\"\"Peter Campbell, Techcafeteria<\/a>, and Laura Quinn, Idealware<\/a><\/strong><\/p>\n

This is an excerpt adapted from Idealware’s article, “XML, API, CSV, SOAP! Understanding the Alphabet Soup of Data Exchange<\/a>“.<\/em><\/p>\n

Repeat this mantra: I will not pay a vendor to lock me out of my own data<\/em>. Sadly, this is what a lot of data management systems do, either by maintaining poor reporting and exporting interfaces or by including license clauses that void the contract if you interact with your data in unapproved ways.<\/p>\n

The software you choose has an enormous impact on whether you can effectively get data in or pull it out to integrate with other packages. If you only look at the front end features, you’re only conducting half an evaluation. It’s also critical to determine how you can — or if you can — access the data.<\/p>\n

To avoid lock-in and ensure the greatest amount of flexibility when looking to buy any new application — particularly the ones that store your data off-site and give you web-based access to it — ask the following questions:<\/p>\n

    \n
  1. Can I do mass imports and updates on my data?<\/strong> If the vendor doesn\u2019t allow you to add or update the system in bulk with data from other systems, or their warrantee prohibits mass updates, then you will have difficulty smoothly integrating data into this system.<\/li>\n
  2. Can I take a report or export file; make a simple change to it, and save my changes? <\/strong>The majority of customized formats are small variations on the standard formats that come with a system. But it\u2019s shocking how many web-based platforms don\u2019t allow you to save your modifications.<\/li>\n
  3. Can I create the complex data views that are useful to me?<\/strong> Most modern donor, client\/case management and other databases are relational. They store data in separate tables. That\u2019s good \u2013 it allows these systems to be powerful and dynamic. But it complicates the process of extracting data and creating customized reports. A donor\u2019s name, address, and amount that they have donated might be stored in three different, but related tables. If that\u2019s the case, and your reporting or export interface doesn\u2019t allow you to report on multiple tables in one report, then you won\u2019t be able to do a report that extracts names and addresses of all donors who contributed a certain amount or more. You don\u2019t want to come up with a need for information and find that, although you\u2019ve input all the data, you can\u2019t get it out of the system in a useful fashion.<\/li>\n
  4. Does the vendor provide a data dictionary?<\/strong> A data dictionary is a chart identifying exactly how the database is laid out. If you don\u2019t have this, and you don\u2019t have ways of mapping the database, you will again be very limited in reporting on and extracting data from the application.<\/li>\n
  5. What data formats can I export data to?<\/strong> As discussed, there are a number of formats that data can be stored in, such as CSV (Comma Separated Values – a great format for manual imports and exports) and XML (eXtensible Markup Language – better for automatic integration). You want a variety of options for industry standard formats.<\/li>\n
  6. Can I connect to the database itself?<\/strong> Particularly if the application is installed on your own local network, you might be access the database directly. The ability to establish an ODBC connection to the data, for instance, can provide a comparatively easy way to extract or update data. Consider, however, what will happen to your interface if the vendor upgrades the database structure.<\/li>\n
  7. Can I initiate data exports without human intervention? <\/strong>Check to see if there are ways to schedule exports, using built-in scheduling features or by saving queries that can be run by the Windows Scheduler (or something similar). Don\u2019t allow a vendor to lock you out of the database administrator functions for a system installed on your own network. If you want to integrate data in real time, determine what user actions can kick off a process (for instance, clicking Submit on a web form).<\/li>\n
  8. Is there an API?<\/strong> APIs can provide a very useful set of functions for importing, exporting, and moving data programmatically. For some systems, an API may be the only way to get data in or out without human intervention. Don\u2019t assume any API is a good API, however \u2013 make sure it has the functions that will be useful to you.<\/li>\n
  9. Is there a data exchange ecosystem?<\/strong> Are there consultants who have experience working with the software? Does the software support third party packages that specialize in extracting data from one system, transforming it, and loading it into another? Is there an active community developing add-ons and extensions to the application that might serve some of your needs?<\/li>\n<\/ol>\n

    Evaluating software packages for data exchange capabilities can’t be an afterthought. It’s too important. Buying into systems that over-complicate or restrict your access to data will limit your ability to manage your business, both today and as long as you own the package.<\/p>\n

     <\/p>\n","protected":false},"excerpt":{"rendered":"

    This article was co-written by Laura Quinn of Idealware and first published on the NTEN Blog in October of 2007. \u00a0Peter Campbell, Techcafeteria, and Laura Quinn, Idealware This is an excerpt adapted from Idealware’s article, “XML, API, CSV, SOAP! Understanding the Alphabet Soup of Data Exchange“. Repeat this mantra: I will not pay a vendor
    + Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,79,82],"tags":[92,189,104,263,124,240,118,16],"class_list":["post-1474","post","type-post","status-publish","format-standard","hentry","category-nptech","category-starred","category-tech","tag-content-ownership","tag-contracts","tag-data","tag-integration","tag-laura-quinn","tag-nten-blog","tag-open-apis","tag-software"],"_links":{"self":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts\/1474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1474"}],"version-history":[{"count":1,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts\/1474\/revisions"}],"predecessor-version":[{"id":1475,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=\/wp\/v2\/posts\/1474\/revisions\/1475"}],"wp:attachment":[{"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techcafeteria.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}