The Importance of Migrations in GeneXus Development
Version migrations in GeneXus commonly include enhancements relative to the automation of the development process.
This document is not intended to compare open source to closed source rather to describe the experience of developing applications using an open source platform using Genexus.
My name is James Reed and I have been developing software since 1987. I am currently the owner of Information Services Select Inc (ISS). I have used Genexus since 1991, both in the Fortune 500 arena and the private sector with small to medium size companies. Since then I have never considered using another development tool. Before I go into detail, let me describe GeneXus. GeneXus is an application that assists with creating applications. As a developer, Genexus allows developers to work and focus on a creative level rather than being buried in technical details thus expediting productivity and yielding stable products.
When I first heard about GeneXus I had no interest. Having worked with code generators and always hitting a limit with what you could do, inefficient code, and having to fall back on regular tools to complete the design anyway. Fortunately, when I got to see GeneXus in operation my mind was changed. GeneXus is much more than a code generator. It is a declarative language so I can simply describe my application with rules and events. I can select a target environment and a language for it to be generated. In case you are wondering, yes, an application can be described once and generated in different platforms such as Microsoft .NET or Java. GeneXus takes care of my database and structures it to conform to third form normalization while offering a number of databases to choose from. When structural changes are made it takes care of the data as well. There is much more this tool does! I’ll admit, if I had never seen it and someone tried to tell me about it, I would be skeptical.
Our open Source APPLICATION: EASE
GeneXus has allowed my organization to be extremely productive with a very small team that would have been much larger using traditional development tools. We have developed a cloud service that runs entirely on free opensource operating systems, web server software and database servers. This has allowed us to offer services at a very affordable price that are just as reliable when using proprietary software counterparts. The benefit with using GeneXus is the effort and process of development are the same. Our servers have the operating system FreeBSD installed on them. For web hosting we are using Apache HTTP server and Apache Tomcat to host our java web application. We chose PostgreSQL as our database server. With PostgreSQL we are able to offer enterprise level features and performance at no cost. All of this coupled with reliable GeneXus-generated Java Code makes for a dependable software product. In turn, it allows a product to acquire the confidence of your customer through the software services you provide.
There are a number of awesome opensource operating systems, hosting software packages and database servers. We are not saying the stated software is the best way to go, but it has proven to be a great choice for what we are doing.
We have written a number of customized applications for companies that have helped them to overcome complex problems and stream-line their processes. Our flagship product is called “Enterprise Automated Support Environment” referred to as EASE. We have done our best to create a system where business owners and their management teams can manage their business with “EASE”. Our target audience is small businesses and startups to help provide an affordable software service that produces the reliability, flexibility, and agility to compete with larger organizations. The product is completely browser based. Our customers do not have to worry with installations and compatibility issues that often arise with locally installed software packages. Some of the key functions the product offers are: Item Setup, Unit of Measure, Purchasing, Receiving, Vendors, Warehouse Management, Barcoding, Inventory Locator, Picking, Packing, Shipping, Cycle Counting, Physical Inventory Counting, Sales Orders, Customer Management, Sales Rep Commission, Human Resources, Travel Expenses w/Online Receipts, Time off Balances, Time Clock (With or Without GPS), and Delivery Tracking with Electronic Signatures and much more.
One of our clients that uses EASE is Rowland’s Safety and Supply located in Jackson, TN. They use EASE in all areas of their organization from Clocking In to payment entry of invoices. The only things EASE currently does not do is produce employee paychecks but, does provide the data for their payroll system. EASE also updates Quickbooks which produces Profit and Loss Statements as well as other financial reporting requirements.
For many of the operations at Rowlands Safety and Supply, Chromebooks have become the standard or preferred device as they are reliable, portable, and batteries last for most of the day on a single charge. Tablets are used by their truck drivers to acquire signatures and provide electronic copies of the packing slips and manifests for customers. Deliveries can be monitored online as the system can report which customers have and have not received their goods and the electronic signature is visible as well.
EASE has a complex audit tracking feature designed to record all changes. It displays the before and after values of any data that has been added or edited. User security clearance is based upon security roles. This ensures documents cannot be editable without special privileges, ensuring data integrity and consistency. Custom modules can easily be created and added to the menus and launchpads. Rowlands Safety and Supply performs a recycle service where they clean oil absorbent pads, gloves, aprons, sleeves and other Personal Protective Equipment (PPE). This saves their customers money by not having to buy new items and helps keep the environment clean as the oil is also reclaimed and recycled.
Leave a Reply