"Using Gatsby taught me better database design through positive reinforcement." After looking at Cold Fusion, a leading Web site design and management tool from Allaire Corp., of Cambridge, Mass., Polsky chose Gatsby Database Explorer from Gatsby Software Inc. in Hillsborough, N.C. The product dynamically builds a Web interface for Microsoft Access databases without HTML, CGI, or Java programming. Gatsby 2.0, which was developed for workgroup users, has only been available since June, so few analysts have looked at the product. Deployment, so far, is limited, though the company won't provide sales figures. "Cold Fusion is much more flexible than Gatsby," says David Hadfield, general manager for American Information Components, a small Microsoft Access-focused consulting firm in Loveland, Colo. "Gatsby is an interface right out of box, so you spend no time formatting a form. It has a niche no one else is getting into."
In this article: Strategic Resource Solutions Corp. Lessons Learned
--Erick Polsky, Webmaster, Strategic Resource Solutions
AT A GLANCE: Strategic Resource Solutions Corp. The company: Based in Cary, N.C., Strategic Resource Solutions is a subsidiary of Carolina Power and Light. SRS provides systems, lighting solutions, mechanical services, support, and software to help firms control building environments and reduce energy costs. The company currently employs 500 people. The problem: How to provide employees with immediate access to a variety of information such as ever-changing telephone lists housed in a Microsoft Access database. The solution: An intranet that provides Web-enabled database access. The IT infrastructure: Gatsby Database Explorer 1.0 from Gatsby Software in Hillsborough, N.C., which dynamically builds a Web interface for Microsoft Access databases without HTML, CGI, or Java programming. SRS' intranet also uses Compaq Proliant, Microsoft Access 97, DreamWeaver 1.2, Adobe Photoshop 4.0, and custom ASPs.
"Using Gatsby taught me better database design through positive reinforcement."
After looking at Cold Fusion, a leading Web site design and management tool from Allaire Corp., of Cambridge, Mass., Polsky chose Gatsby Database Explorer from Gatsby Software Inc. in Hillsborough, N.C. The product dynamically builds a Web interface for Microsoft Access databases without HTML, CGI, or Java programming.
Gatsby 2.0, which was developed for workgroup users, has only been available since June, so few analysts have looked at the product. Deployment, so far, is limited, though the company won't provide sales figures. "Cold Fusion is much more flexible than Gatsby," says David Hadfield, general manager for American Information Components, a small Microsoft Access-focused consulting firm in Loveland, Colo. "Gatsby is an interface right out of box, so you spend no time formatting a form. It has a niche no one else is getting into."
However, while initial users such as Polsky compare Gatsby to Cold Fusion, Daniel Denning, director of marketing at Gatsby, describes the Gatsby Database Explorer as a new class of product that is most comparable to one part of the Fusion suite, the "NetObjects TeamFusion content contributor." This is a Java applet that allows users to contribute formatted or simple text to internal data objects that have previously been created in the company's TeamFusion client. "Cold Fusion and ASP [active server page] are scripting technologies that allow you to build custom pages," Denning says. Gatsby lets users maintain the content that fuels custom, database-driven pages, he says.
An intranet product
The Gatsby interface adapts to changes made to the database by users. The software automatically builds an interface based on specific database privileges, so new code doesn't have to be written every time a new table is added, a field is renamed, or a relationship is modified, Polsky says.
Gatsby positions its technology as an intranet product, partly because the limited interface lacks the splash most companies want on their external sites. For instance, Polsky had to turn down requests from an SRS sales manager who wanted the names of top salespeople listed on an intranet page to blink and be in purple. The Gatsby interface provides only global customization of sites, rather then customization of individual pages.
While the software lacks the power necessary for enterprise deployments, it may be the answer for smaller firms or departmental-style intranets that use Microsoft Access databases, officials say.
"Gatsby could be used by a small business with 10 or 15 concurrent users all entering information into a database," says consultant Hadfield. "If you put Gatsby on top of Access 2000, you could probably go with an even higher number of concurrent users because the database engine in 2000 is better."
A license for the professional edition of Gatsby Database Explorer 2.0, which allows a firm to Web-enable an unlimited number of databases and users, sells for $1,295. A license for one database on one Web site costs $395. In comparison, one license for NetObjects' Fusion 4.0 has an estimated street price of $300; Drumbeat 2000 is $399; and Allaire's Cold Fusion 4.0 starts at $395.
"Erick is the prototypical Gatsby user--someone who needs to put up an intranet with a limited budget, limited time, and no skills to program in Visual Basic to create and maintain Microsoft Access forms," says Denning.
True to this description, Polsky was able to go from design to deployment of the SRS intranet in two weeks using Gatsby. The simplicity of the software allows him to permit individual departments to edit their own content without knowing HTML. If users have questions, they usually find the answers in two Gatsby FYI sites that Polsky posted on the intranet, freeing him from adding intranet help-desk duties to his already jammed schedule.
Polsky says anyone "who's somewhat computer literate" can use the Gatsby software. "I have never received a support call about the interfaces Gatsby dynamically created," he says.
Better ways to share information
Polsky joined SRS during a stream of acquisitions and department reorganizations, which required the firm to look for a more streamlined way to share information with its ever-expanding work force. Initially, the IT department considered using the public folders in Microsoft Exchange to dispense information.
The thought was to allow all users to post important internal public files to the Exchange public folders. Then employees could surf the hierarchy to find the files they wanted. "However, since there was no control over who posted and what was posted, the tree grew, and finding desired data became impossible," Polsky says. "A few months passed and no body was deleting their obsolete files." Soon different individuals posted multiple revisions of the same document to different locations.
"In no time at all, duplicated data was in various subdirectories and the owners of files would quit the company, leaving out-of-date information that could still be accessed," says Polsky, who reports to the head of marketing/corporate communications at SRS.
SRS company officials realized they needed a better way to control how data became available throughout the company. "Otherwise, you end up with mounds of garbage," Polsky says.
An intranet promised to solve that problem, but Polsky wasn't sure what tact to take in developing it. He pondered using a straight HTML approach with Microsoft FrontPage. However, he was concerned that it would require individual departments to be trained on the software--something that didn't fit in with his time frame or his budget.
It seemed a database-driven site would provide the speediest development cycle with the most flexibility. Polsky considered using the built-in ODBC connections in Access, letting the system create pages from the wizard that he would then customize. But when he tested this idea, he found it too time-consuming.
"I'd create a fairly simple page, have the wizard create the ASP scripting technology, and it would generate 1,500 lines of code," Polsky says. "I was capable of going through the lines of code to figure out how to customize it to make it look the way I wanted. But I wasn't willing to go through that much code."
Another complication turned Polsky away from Allaire's Cold Fusion. "At the time, I was not a programmer at all so I was afraid of the whole Cold Fusion solution," Polsky says. "Colleagues I talked to said Cold Fusion was a fast tool if you knew how to use it, but I didn't have the time to learn how."
Since then, Polsky says he's realized learning to put databases on the Web was vital to his survival as a Webmaster. Gatsby leveraged his existing Access skills, solving his immediate database publishing needs. "Then I could start solving problems while beginning to learn ASP," he says. "Now that I have strong ASP skills, I still use Gatsby for many tasks. It is a tool that allows me to rapidly deploy Web database solutions."
The more SRS' Polsky has learned about buildings intranets, the more he has realized the company's intranet was poorly designed in the first iteration. "Access rewards you for being a bad database designer," he says. "You can do all sorts of flaky things and Access provides pull-down lists as a result of doing it in a half-assed way. If you create normalized data with a relationship, Access won't create pull-down boxes in forms, so it encourages bad habits."
As a result, he has designed a new and better database and intends to import the content from his old databases with ease. "Using Gatsby taught me better database design through positive reinforcement," Polsky says. "I was rewarded for good design with a more rich and navigable Web interface. I wish I had designed our intranet using the database design skills I now possess thanks to Gatsby." //
Joe Mullich, who lives in Glendale, Calif., has written for more than 100 publications and won over two dozen awards for feature and column writing. He can be reached at JoeMullich@aol.com.