24:
685:
176:) was popular in the governments of North West Europe, and can be found in many government departments. OpenROAD appeared in beta form on the SUN platform in 1991 as Windows4GL 1.0, and was available to British Universities under a special license agreement. The development environment was known as the Sapphire Editor.
379:
The defining feature of the release was general-purpose system classes for XML support, to allow creation and parsing of arbitrary XML documents without the need to create additional user classes or to use external components (3GL Procedures or
External Class Libraries). Providing an XML based export
280:
Variations in the distribution include FAT client (Requires Ingres NET for communication), Thin eClient (can be used without Ingres NET but needs to use the
Application Server instead (DCOM)), and finally mClient for Mobile Windows Clients (HTTP services required to interface to the Application
380:
file format will that will be documented, human readable, produce clean differences between different revisions of a file, allow changes to be merged, will allow OpenROAD source components to be managed by many different
Software Configuration Management (SCM) systems.
624:
The OpenROAD Server enables business logic written in the OpenROAD 4GL language to be accessed by client applications. The OpenROAD Server is multi-threaded and allows concurrent access from a number of client interfaces. These client interfaces include the following:
179:
The
Sapphire Editor allowed the creation of complex GUI interfaces using an IDE, rather than large volumes of Motif code / resource files. This was one of the first environments to enable rapid prototyping of GUI clients.
602:
The reason for the varying and shorter
Lifecycle dates of latest versions is Actian is working to bring OpenROAD releases current to Actian X. The Lifecycle dates will re-align with the 11.2 release in 2021.
284:
It was possible to use images in any environment (Unix, VMS or MS Windows up to version 3.51), however portability issues between GUI environments (mostly related to FONT differences) made this difficult.
278:
After 3.51, the UNIX environments used a
Commercial PC emulator to give native capability, possibly one of the hurdles on the ROAD to its Open Source status across all platforms.
331:
It is an interpreted language that uses a runtime distributable client to process 'image' files, thus no DLL or .NET dependency issues under MS Windows (ActiveX aside).
928:
824:
132:
612:
143:
732:
664:
782:
803:
913:
710:
656:
47:
695:
714:
699:
706:
655:
databases. On IBM z/OS mainframes, EDBC (a separate product) provides the same level of access to native
425:
OpenROAD 6.0 included the additional UNICODE support of OpenROAD 2006 5.5, a special limited release.
761:
Extension of the OpenROAD language into the Ingres database engine replacing the
Procedure language.
169:
158:
877:
136:
71:
31:
23:
120:
648:
155:
433:
OpenROAD 6.2 (All
Platforms) and Ingres 10.2 Client only for support of OpenROAD as a client
107:
83:
165:
96:
76:
611:
922:
652:
887:
900:
882:
470:
451:
429:
406:
384:
360:
338:
684:
668:
183:
Windows4GL 2.0 introduced
Microsoft Windows compatibility and the debugger.
758:
In process access to Ingres NET for FAT clients making distribution easier.
749:
The ability to construct user objects that inherit from the system classes
88:
540:
516:
492:
173:
131:, which stands for "Open Rapid Object Application Development", is a
36:
610:
92:
746:
Intellisense for source, SQL statements and user defined objects.
678:
660:
100:
783:"Lifecycle Dates - Transactional Database - Actian OpenROAD"
121:
https://www.actian.com/data-management/openroad-rad-4gl-ide/
752:
Better configuration management for large development teams
591:
579:
574:
854:
142:
It includes a suite of development tools, with built-in
867:
312:
290:
259:
236:
213:
154:
The history of OpenROAD is closely tied to that of the
671:
databases to enable you to access data from anywhere.
232:
OpenROAD 3.0 was when it became stable on MS Windows.
872:
629:
Java clients (JSP, Java
Servlets, Java applications)
116:
106:
82:
70:
62:
46:
30:
146:(IDE) (Written in OpenROAD), and Code Repository.
825:"Accessing and Integrating Data with OpenROAD"
764:Access to the sources of the OpenROAD language
584:
333:There was a Macintosh Beta version produced.
8:
16:
713:. Unsourced material may be challenged and
255:OpenROAD 3.5(1) was when it became stable.
15:
733:Learn how and when to remove this message
647:OpenRoad Server has built-in support for
596:
190:
929:Fourth-generation programming languages
868:North American Ingres Users Association
774:
497:OpenROAD 11.2 (Solaris SPARC, IBM AIX)
133:fourth-generation programming language
164:The Ingres Product set, (marketed by
7:
711:adding citations to reliable sources
632:.NET clients (VB.NET, C#, ASP.NET)
472:Old version, yet still maintained:
453:Old version, yet still maintained:
431:Old version, yet still maintained:
408:Old version, yet still maintained:
386:Old version, yet still maintained:
362:Old version, yet still maintained:
340:Old version, yet still maintained:
314:Old version, no longer maintained:
292:Old version, no longer maintained:
261:Old version, no longer maintained:
238:Old version, no longer maintained:
215:Old version, no longer maintained:
144:Integrated development environment
14:
388:OpenROAD 5.1 (Unix except HP-UX)
364:OpenROAD 5.1 (Windows and HP-UX)
135:(4GL) and development suite from
914:OpenROAD Application Development
683:
22:
474:OpenROAD 11.0 (Linux, Windows)
53:OpenRoad 11.2 / May, 2021
888:Ingres Community OpenROAD Wiki
873:German Ingres User Association
172:, Ingres Corporation and then
1:
755:Native access to .NET classes
580:Old version, still maintained
455:OpenROAD 11.0 (Solaris, Aix)
206:End of Obsolescence Support
901:Openroad-users Mailing List
575:Old version, not maintained
945:
878:Ingres UserGroup Nederland
804:"OpenROAD Server Overview"
635:COM clients (VB, C++, ASP)
200:End of Enterprise Support
675:Features needed (Q2 2008)
58:
42:
21:
203:End of Extended Support
545:OpenROAD 11.2 (Windows)
542:Current stable version:
518:Current stable version:
494:Current stable version:
240:OpenROAD 3.5 (Windows)
63:Implementation language
616:
592:Latest preview version
615:OpenRoad Architecture
614:
521:OpenROAD 11.2 (Linux)
197:General availability
707:improve this section
643:Open Database Access
458:Sep, 2020 31-Dec-22
342:OpenROAD 2006 (5.0)
263:OpenROAD 3.5 (Unix)
883:OpenROAD FAQ (1997)
170:Computer Associates
159:relational database
18:
855:Ingres Corporation
617:
137:Actian Corporation
37:Actian Corporation
743:
742:
735:
564:
563:
126:
125:
936:
836:
835:
833:
832:
821:
815:
814:
812:
811:
800:
794:
793:
791:
790:
779:
738:
731:
727:
724:
718:
687:
679:
653:Vector/Avalanche
638:OpenROAD clients
598:
593:
588:
581:
576:
571:
543:
519:
495:
473:
454:
432:
409:
387:
363:
341:
315:
293:
266:September, 1997
262:
239:
216:
191:
26:
19:
944:
943:
939:
938:
937:
935:
934:
933:
919:
918:
861:Community links
845:
840:
839:
830:
828:
823:
822:
818:
809:
807:
802:
801:
797:
788:
786:
781:
780:
776:
771:
739:
728:
722:
719:
704:
688:
677:
645:
622:
620:OpenROAD Server
609:
600:
599:
594:
589:
582:
577:
572:
567:
541:
517:
493:
471:
452:
436:November, 2014
430:
407:
385:
361:
345:December, 2006
339:
313:
291:
260:
237:
214:
189:
187:Version history
166:ASK Corporation
152:
54:
12:
11:
5:
942:
940:
932:
931:
921:
920:
917:
916:
904:
903:
891:
890:
885:
880:
875:
870:
858:
857:
844:
843:External links
841:
838:
837:
816:
795:
773:
772:
770:
767:
766:
765:
762:
759:
756:
753:
750:
747:
741:
740:
691:
689:
682:
676:
673:
644:
641:
640:
639:
636:
633:
630:
621:
618:
608:
605:
597:Future release
595:
590:
586:Latest version
583:
578:
573:
566:
565:
562:
561:
559:
556:
553:
550:
547:
538:
537:
535:
532:
529:
526:
523:
514:
513:
511:
508:
505:
502:
499:
490:
489:
487:
484:
481:
478:
475:
468:
467:
465:
462:
459:
456:
449:
448:
446:
443:
440:
437:
434:
427:
426:
423:
420:
417:
414:
411:
404:
403:
401:
398:
395:
392:
389:
382:
381:
377:
374:
371:
368:
365:
358:
357:
355:
352:
349:
346:
343:
336:
335:
329:
326:
323:
320:
319:January, 2001
317:
316:OpenROAD 4.1)
310:
309:
307:
304:
301:
298:
295:
294:OpenROAD 4.0)
288:
287:
276:
273:
270:
267:
264:
257:
256:
253:
250:
247:
244:
241:
234:
233:
230:
227:
224:
221:
218:
211:
210:
207:
204:
201:
198:
195:
188:
185:
151:
148:
124:
123:
118:
114:
113:
110:
104:
103:
86:
80:
79:
77:Cross-Platform
74:
68:
67:
64:
60:
59:
56:
55:
52:
50:
48:Stable release
44:
43:
40:
39:
34:
28:
27:
13:
10:
9:
6:
4:
3:
2:
941:
930:
927:
926:
924:
915:
912:
911:
910:
908:
902:
899:
898:
897:
895:
894:Mailing Lists
889:
886:
884:
881:
879:
876:
874:
871:
869:
866:
865:
864:
862:
856:
853:
852:
851:
849:
848:Product links
842:
826:
820:
817:
805:
799:
796:
784:
778:
775:
768:
763:
760:
757:
754:
751:
748:
745:
744:
737:
734:
726:
716:
712:
708:
702:
701:
697:
692:This section
690:
686:
681:
680:
674:
672:
670:
666:
662:
658:
654:
650:
642:
637:
634:
631:
628:
627:
626:
619:
613:
606:
604:
587:
570:
560:
557:
554:
551:
548:
546:
539:
536:
533:
530:
527:
524:
522:
515:
512:
509:
506:
503:
500:
498:
491:
488:
485:
482:
479:
476:
469:
466:
463:
460:
457:
450:
447:
444:
441:
438:
435:
428:
424:
421:
418:
415:
412:
410:OpenROAD 6.0
405:
402:
399:
396:
393:
391:August, 2012
390:
383:
378:
375:
372:
369:
366:
359:
356:
353:
350:
347:
344:
337:
334:
330:
327:
324:
321:
318:
311:
308:
305:
302:
299:
296:
289:
286:
282:
277:
274:
271:
268:
265:
258:
254:
251:
248:
245:
242:
235:
231:
228:
225:
222:
219:
217:OpenROAD 3.0
212:
208:
205:
202:
199:
196:
193:
192:
186:
184:
181:
177:
175:
171:
167:
162:
160:
157:
149:
147:
145:
140:
138:
134:
130:
122:
119:
115:
111:
109:
105:
102:
98:
94:
90:
87:
85:
81:
78:
75:
73:
69:
65:
61:
57:
51:
49:
45:
41:
38:
35:
33:
29:
25:
20:
906:
905:
893:
892:
860:
859:
847:
846:
829:. Retrieved
819:
808:. Retrieved
798:
787:. Retrieved
777:
729:
720:
705:Please help
693:
646:
623:
607:Architecture
601:
585:
568:
544:
520:
496:
413:March, 2012
367:April, 2011
332:
297:April, 1998
283:
279:
243:April, 1996
182:
178:
163:
153:
141:
128:
127:
112:Proprietary
831:2023-04-14
810:2023-04-14
789:2023-04-14
769:References
723:April 2023
669:Datacom/DB
558:31-May-33
555:31-May-29
552:31-May-25
549:Aug, 2021
534:31-May-33
531:31-May-29
528:31-Dec-24
510:31-May-33
507:31-May-29
504:31-Dec-24
486:31-Dec-26
483:31-Dec-24
480:31-Dec-22
477:Sep, 2020
464:31-Dec-26
461:31-Dec-24
445:31-Dec-31
442:31-Dec-26
439:31-Dec-21
422:31-Mar-27
419:31-Mar-22
416:31-Mar-17
400:31-Dec-25
397:31-Dec-20
394:31-Dec-16
376:31-Dec-25
373:31-Dec-20
370:31-Dec-15
354:31-Dec-23
351:31-Dec-18
348:31-Dec-13
328:31-Mar-19
325:31-Mar-14
322:31-Mar-09
306:31-Mar-19
303:31-Mar-14
300:31-Mar-09
275:31-Dec-18
272:31-Dec-13
269:31-Dec-08
252:31-Dec-18
249:31-Dec-13
246:31-Jan-08
229:31-Dec-11
226:31-Dec-06
223:31-Dec-01
220:May, 1995
694:does not
281:server).
32:Developer
923:Category
907:Webcasts
827:. Actian
806:. Actian
785:. Actian
649:Ingres/X
194:Release
129:OpenROAD
72:Platform
17:OpenROAD
715:removed
700:sources
569:Legend:
525:May-21
501:May-21
150:History
117:Website
108:License
97:Solaris
89:Windows
667:, and
209:Notes
174:Actian
156:Ingres
66:C, C++
93:Linux
698:any
696:cite
657:VSAM
651:and
709:by
665:IMS
661:DB2
101:AIX
925::
909::
896::
863::
850::
663:,
659:,
168:,
161:.
139:.
99:,
95:,
91:,
84:OS
834:.
813:.
792:.
736:)
730:(
725:)
721:(
717:.
703:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.