Difference between revisions of "NewYork2008:Managing Custom Database Projects"

From Managing Nonprofit Technology Projects Wiki
Jump to navigation Jump to search
Line 10: Line 10:
 
Will participants please add their names to the comments.
 
Will participants please add their names to the comments.
  
Participants:
+
'''Participants:'''
Michelle
 
Norman Rees
 
Rachel
 
Hannah – pm for custom database
 
Colin Harrison
 
  
 +
*Michelle
 +
*Norman Rees
 +
*Rachel
 +
*Hannah – pm for custom database
 +
*Colin Harrison
  
Michelle:  Unique differences between bespoke and off the shelf.
 
  
Jim: Databases I created are for a specific purpose, Aim to make it as flexible as possible
+
'''Michelle:'''  Unique differences between bespoke and off the shelf.
  
Norman: Some applications you expect to customise to certain degree
+
'''Jim:''' Databases I created are for a specific purpose, Aim to make it as flexible as possible
  
Michelle: There are problems that nobody has tackled. Goal of funder to be moving in the direction of delivering these services. Significant problems with data management. Nothing out there that was specific enough. They need to be scalable and customisable. Build into consideration who could see what. Not sure it’s flexible enough.
+
'''Norman:''' Some applications you expect to customise to certain degree
  
Jim: A lot depends on who the customer is.
+
'''Michelle:''' There are problems that nobody has tackled. Goal of funder to be moving in the direction of delivering these services. Significant problems with data management. Nothing out there that was specific enough. They need to be scalable and customisable. Build into consideration who could see what. Not sure it’s flexible enough.
  
Colin: Sometimes the answer is a training issue e.g. taking stuff out of Access and put it into Excel’ to perform statistical analysis.
+
'''Jim:''' A lot depends on who the customer is.
  
Rachel: Sometimes not possible
+
'''Colin:''' Sometimes the answer is a training issue e.g. taking stuff out of Access and put it into Excel’ to perform statistical analysis.
  
Michelle: Support + maintenance issues
+
'''Rachel:''' Sometimes not possible
  
Gabrielle: Will there be more users who know how to use tools such as Excel. You can use Excel to create cool images of your data. Demo graphics of users makes a lot of difference. Had to create another dept. Salesforce is complicated Now have 2 staff supporting salesforce. Very powerful. Happy to link it to other software. App exchange platform. Hundreds if not thousands of apps available. Up to 10 licences free if you are a non-profit.  
+
'''Michelle:''' Support + maintenance issues
 +
 
 +
'''Gabrielle:''' Will there be more users who know how to use tools such as Excel. You can use Excel to create cool images of your data. Demo graphics of users makes a lot of difference. Had to create another dept. Salesforce is complicated Now have 2 staff supporting salesforce. Very powerful. Happy to link it to other software. App exchange platform. Hundreds if not thousands of apps available. Up to 10 licences free if you are a non-profit.  
 
    
 
    
Nicholas Carr: end of IT departments? The skills for web-based apps are quite  different. Bespoke: You get to the point where you cannot go back. Before you do that, see what is available; Need: Advice about linking various applications  
+
'''Nicholas Carr:''' end of IT departments? The skills for web-based apps are quite  different. Bespoke: You get to the point where you cannot go back. Before you do that, see what is available; Need: Advice about linking various applications  
  
Michelle: A lot of software is being developed in an open way. Look at APIs. What is new is that companies hare developed them for non profits. Sometimes they can be difficult. Question to ask is "Have you got an open Apr, and how much does it cost? What do you use?" PERL, Java , php ,co_ fusion, Ruby, ms.net. Ruby will be huge, as it allows rapid development of applications by having standard modules off the shelf.
+
'''Michelle:''' A lot of software is being developed in an open way. Look at APIs. What is new is that companies hare developed them for non profits. Sometimes they can be difficult. Question to ask is "Have you got an open Apr, and how much does it cost? What do you use?" PERL, Java , php ,co_ fusion, Ruby, ms.net. Ruby will be huge, as it allows rapid development of applications by having standard modules off the shelf.
  
 
'''AH-HA's:'''
 
'''AH-HA's:'''

Revision as of 23:16, 15 January 2016

Description

Designing and implementing custom developed database projects is one of the most difficult kinds of technology projects that one can do. How can you make this process a dream instead of a nightmare? How can you make get the information from stakeholders, work with vendors, train staff, and make the process move smoothly and on schedule? We'll share experiences, ideas and best practices.

Session Notes

(Session Note Taker will enter notes here) Databases

Will participants please add their names to the comments.

Participants:

  • Michelle
  • Norman Rees
  • Rachel
  • Hannah – pm for custom database
  • Colin Harrison


Michelle: Unique differences between bespoke and off the shelf.

Jim: Databases I created are for a specific purpose, Aim to make it as flexible as possible

Norman: Some applications you expect to customise to certain degree

Michelle: There are problems that nobody has tackled. Goal of funder to be moving in the direction of delivering these services. Significant problems with data management. Nothing out there that was specific enough. They need to be scalable and customisable. Build into consideration who could see what. Not sure it’s flexible enough.

Jim: A lot depends on who the customer is.

Colin: Sometimes the answer is a training issue e.g. taking stuff out of Access and put it into Excel’ to perform statistical analysis.

Rachel: Sometimes not possible

Michelle: Support + maintenance issues

Gabrielle: Will there be more users who know how to use tools such as Excel. You can use Excel to create cool images of your data. Demo graphics of users makes a lot of difference. Had to create another dept. Salesforce is complicated Now have 2 staff supporting salesforce. Very powerful. Happy to link it to other software. App exchange platform. Hundreds if not thousands of apps available. Up to 10 licences free if you are a non-profit.

Nicholas Carr: end of IT departments? The skills for web-based apps are quite different. Bespoke: You get to the point where you cannot go back. Before you do that, see what is available; Need: Advice about linking various applications

Michelle: A lot of software is being developed in an open way. Look at APIs. What is new is that companies hare developed them for non profits. Sometimes they can be difficult. Question to ask is "Have you got an open Apr, and how much does it cost? What do you use?" PERL, Java , php ,co_ fusion, Ruby, ms.net. Ruby will be huge, as it allows rapid development of applications by having standard modules off the shelf.

AH-HA's:

1. Differences between going with a package and bespoke systems
2. Concept of a hybrid model
3. Before you think about the technology – what is the detailed information and processes that you need.
4. Documentation is extremely important. You can use a Wiki effectively to do this. Track-combination bug tracker and wiki.