The blog will walk you through the Progress OpenEdge Database basics and help you get an idea you need essentially to become a Progress Database Administrator.
The Oedt Plug-in (Oedt) is an eclipse plugin which extends the Progress Developer Studio for OpenEdge. Development of Oedt started almost five years ago, trying to solve some issues related to a large code base. Starting with non blocking workspace project builds, support for typical git workflow up to an editor implementation.
Features: A better Project Builder as incremental eclipse project builder, replaces the default Progress OpenEdge project builder. A better project view. A database view without SQL connection. An enhanced ABL editor. A much better code assistance for autocomplete.
pdfInclude is a Progress library which allows Progress developers to output documents in Adobe PDF file format without having to use third-party tools or utilities. pdfInclude is a stand-alone component that defines a tool set of Progress functions and procedures that aid in the output of a PDF file directly from within the Progress 4GL/ABL. pdfInclude is developed itself 100% in Progress 4GL/ABL (using zlib). pdfInclude makes use of Progress code that is compliant with versions 9, 10 and 11 of the Progress 4GL/ABL on UNIX and/or Windows platforms.
DocxFactory is a free and open source cross platform C/C++ library with C#, Java, Python, Progress 4GL wrappers and command line tools for generating Microsoft Word .DOCX files (also called Open XML).
To create a .DOCX file, design a template (regular .DOCX file) and merge your data with the template using your favorite programming language. No technical knowledge of the .DOCX file format (Open XML) is required. The library is multi platform, very fast and can be used from many languages. Examples for OpenEdge are available.
Progress Programmers Pal (3P), is a notepad++ plug-in designed to help Openedge ABL developpers, 3P is a free and open-source software release under GPL License.
3P transforms notepad++ into an ABL code editor, providing: a powerful auto-completion, tool-tips on every words, a code explorer to quickly navigate through your code, a file explorer to easily access all your sources, more than 50 options to better suit your needs, the ability to run/compile and even PROLINT your source file with an in-line visualization of errors, and so much more!
PCase is a CASE-tool which allows you to insert and view the design of a structure from a relational database graphically using an entity relationship diagram (ERD). With this easy to use tool Progress databases can be generated and updated directly. The structure of an existing Progress database can be read and shown as an ERD. Besides this you can also generate standard triggers and maintain database versions.
Kinvey is a extensive BaaS-solution (“Backend-as -a-Service”) tool. With Kinvey, the development of backend systems for mobile and web applications is much faster. Kinvey supports all importanat platforms. It comes with a lot of service-offers and many developer-tools. Progress bought Kinvey June 2017.
OpenEdge is supported by a wide range of communities. The following list is a snapshot of the major groups of Progress OpenEdge users. Whenever a question needs an answer or some information is wanted, these places are right.
Facebook – English speaking
Xing – German speaking community
Progresstalk – Classical forum
This group is for discussions and informations about Progress OpenEdge topics like ABL, 4GL, DB, .NET, HTML5, cloud and third party integration.
Progress Software Users – The official group of Progress Software, with about 6500 members.
Progress OpenEdge Users/Developers – The independent developers group, about 3000 members.
Progress User Group (PUG) – This group focus on the activities of the Progress User Groups (PUGs) and the yearly large conference held in EU and US (2600 members).
Viper empowers developer to run reports in 4GL in a fast and easy way. The run time of Viper is available for Windows and Linux/Unix in both 32 and 64 bit and compatible with OpenEdge from 9.x to 11.x. Technically Viper is a DLL, which is loaded from the 4GL. The interface is encapsulated into a 4 GL API and access to the layout from the Viper Designer is given through an interactive 4GL interface. We deliver a viewer for the report format, but creating PDF for cloud and SaaS printing is easy.
A part of Progress since 2014, Telerik by Progress is committed to giving developers the tools they need to harness and master the technological evolution shaping our society and the world. From innovative approaches to native, web and hybrid development, to time-saving tooling and testing products, developers rely on the quality and dependability of Progress to create transformative experiences.
This plugin for Total Commander can list, view or extract files stored in PROGRESS OpenEdge PL archives (procedure libraries). It’s much easier as using PROLIB Utility. When is plugin already installed just press F3 for viewing or F5 for copying from archive.
The XenCraft Word Parser for Progress (XenWORD) is a shared library that parses text into words using the Progress word rules table, the same rules used for database word indexes. This gives developers and users the ability to review how the text is being parsed, to confirm the correct rules are being used or to experiment with new rules. The library can also be used more generally for text parsing and manipulation.
WizTOM for PROGRESS is a highly efficient technology for localizing Progress applications. You can use it to add languages to your application to reach global markets, to expand your base of users in your local market, or to customize applications for individual clients. If you struggle with maintaining homebrew localization tools and processes, or have projects that have outgrown Progress Translation Manager, WizTom can relieve you of unwieldy localization processess and bring you to a modern and supported methodology.
IAP’s Skin-Client for Mobile enables Progress Developers to become App developers using 100% pure OpenEdge ABL in a remarkably short time frame.
The Skin-Client for Mobile has a “write once, deploy anywhere” approach which means that your code will run on iOS and Android and Blackberry and Windows Mobile and J2ME. The Skin-Client for Mobile removes the need to learn device-specific languages or development environments and thus saves you valuable time and money in your App creation.
Each of these free tools comes with a document explaining the principles and how to use them:
· dbreport – A great tool with two purposes:
1. Reviewing the DB schema more quickly and easily than any other tool we’ve seen
2. Changing views and retrieving data in a dynamic browser for any table.
A superb tool for analyzing and converting your V8 (or existing V9) DB into V9 areas. For either version, it helps generate both the multi-volume structure with distinct record-per-block settings if desired. It also helps analyze current tables and will generate a DF for with tables in designated areas. A graphical-only tool to read the DB analysis output and allow you to create an well-tuned V9 DB structure.
A terrific tool to help you analyze where your code is slow. It is based on the Progress performance analyzer tool, but goes beyond this tool to give you more granularity in understanding where the problems lie and why.
A personal debugger which you can use whether you have character or GUI. It allows you to insert your own code (of course, you’re finding someone else’s bugs) and do a large variety of things that aren’t possible with the Progress debugger.
· vst dashboard
A starting point for building your own VST “dashboard”; this tool includes several useful metrics, and enough clear, documented code to help you monitor your system and build your own.
The XenCraft Unicode Collation for Progress (XenPUC) is a shared library that allows Progress to use a language-based collation instead of a binary collation. The collation is for use by Progress applications and database indexes using Unicode.
Prolint/Proparse is an open source tool for automated source code review of Progress 4GL code. It reads one or more sourcefiles and examines it for bad programming practices or violations against coding standards. Prolint/Proparse does not change or rewrite source code, it is no beauty.p. Prolint/Proparse works with a customizable library of rules. A rule is a specific test that Prolint/Proparse can perform on source code. Every rule has a ‘severity-level’ ranging from 0 to 9 (0=informational, 9=severe violation). One can easily customize the severity levels to company preferences. One can also switch rules on/off and save these settings in any number of profiles.
OF-1 is a developer framework for OpenEdge 10.x and 11.x that enables individuals and teams to develop local enterprise level systems, SaaS applications, Web UI’s in Java and HTML5 from 1 single ABL source code!
It brings Application modernisation with migration possibilities from Character, Standard Progress Client/Server, ADMx, DWP, Dynamics and much more – and is a great Application Developer Productivity Tool. It is also often used for Add-Ons to existing ERP Systems like MFG/Pro or proALPHA.
The OF-1 Productivity Suite consists of the core OF-1 product as framework, PCase as ERD diagrammer and source-code generator and Skin-Client as SaaS-ready solution. They all focus on productivity and allow you to grow with your needs.
A database reorganization can improve performance, eliminate fragmentation and reduce the size of the database … and it can take a lot of time. BravePoint’s ProD&L helps you get your time back by reducing the downtime required for a database reorganization to less than a few hours — regardless of the size of your database.
KSV Editor is a modification of the standard Progress Procedure Editor™ coming with the Progress development environment. It has a lot of useful features which facilitate programming on Progress 4GL. It allows writing programs both for GUI and CHUI modes as well as for earlier versions of Progress.
The Progress® WebClient® product is a major addition to the Progress® Software Corporation product line. WebClient® enables the development of true ‘thin client’ applications to be distributed, deployed and maintained over networks without ever doing any work on the client machine. The automatic deployment and update mechanism supports and implements the Application Service Provider (ASP) model where end users ‘rent’ applications on a pay-as-you-go basis and are automatically ensured of running the latest version of the application.
When organizations started deploying their WebClient® applications over the internet significant performance bottlenecks became apparent. While the applications do have acceptable performance over Local Area Networks and Intranets, traditional Progress® development environments prove to be too slow for delivery over the public internet, often still accessed by users through dial-up modems. When faced with the task of providing thousands of dial-up users access to central databases over the internet,Netsetupquickly recognized that an entirely new architecture was required to achieve this goal.
Extensive measurements revealed that traditional Progress® architectures suffer from three major bottlenecks when faced with internet deployment: too many AppServer calls, excessive data exchange, and large r-code deployment to the client.
The Dynamic WebClient® Architecture is based on the union of a single ‘Business Logic’ object on the server and a single ‘User Interface’ object on the client. Together, these two objects are capable of delivering full-blown Windows applications to the end user with sub-second response times over dial-up internet connections.
The use of bandwidth is typically much lower than a comparable HTML-based web application. A single user interaction results in just a single AppServer call, even if that interaction returns a screen full of browser and viewer data. Due to the stateless architecture a single application server can support thousands of concurrent users.
As a matter of fact, with the Dynamic WebClient® Architecture you do not have to wait for UMTS frequencies to become available to provide wireless access to your Progress® applications; a standard GPRS connection is sufficient to run DWA applications on your laptop. Even a 9.600 baud GSM connection can be used to access DWA applications from anywhere in the world. This claim leaves the major industry players out in the cold.
A development team led by internationally renowned Progress specialist Peter van Dam was instituted to develop a new WebClient® architecture for the internet.
The answer was found in the combination of a completely ‘dynamic’ approach, highly compressed intelligent data transfer, sophisticated caching techniques, and the use of a central repository to store application definitions.
Stateless AppServers ensure virtually unlimited scalability. The result is an internet deployment architecture for Windows applications with unparalleled performance: the Dynamic WebClient® Architecture.
The Dynamic WebClient® Platform is the development environment for applications based on the Dynamic WebClient® Architecture. This environment enables developers to rapidly (re)develop Progress® based Windows applications for deployment over the internet.
Using the Dynamic WebClient® Platform does not mean that the existing applications are to be completely rewritten. Often it is sufficient to redevelop specific key parts of the front-end, leaving the rest of the application intact.
The Progress Software Developers Network™ (PSDN) is a set of online and offline services designed to help developers write best-of-breed business applications using Progress® products and technologies. In the Code Sharesection you’ll find tons of code snippets up to complete solutions for various use cases well sorted in many categories, e.g. .NET sample code, Fathom jobs and library components, Progress 4GL programs, ADM2 smart objects, internet solutions with XML and WebSpeed’s SpeedScript, reporting, database maintenance …