
Five minutes, nine good reasons
It will take you only 5 minutes to read these 9 good reasons why the Querix suite of 4GL development tools is the one you need.
1 - Total Flexibility
Lycia provides a multi-tier architecture, capable of running in character mode or with any of the Querix advanced thin-clients. It creates the ultimate in application portability, migration and usability.
As all the Querix thin-clients access the same application binary, any combination of them can get simultaneous access to the application.
2 - Single cycle compilation and rapid, low-cost development
With Lycia, you don’t just compile once, and run anywhere – you Compile Once and Run Everywhere at the same time. We call it: CORE technology.
The advanced Lycia facilities for fast application tracking, software version control, software configuration management and source-level debugging will also save development time and cost significantly.
3 - Advanced Features
Lycia-compiled applications not only function like true native applications, they can also include a host of advanced features, such as:
- Choice of single and multiple document interfaces
- Extended 4GL language, with new widgets and functions
- Customizable drop-down menus to launch applications
- Right-click context sensitive menus
- Globalised language support
- SSL communications
- Full authentication
- Embedded ActiveX/OLE/JavaBean controls
- Support for RPC technologies, such as DDE
- Web Services (server & client functionality)
And there’s no need to change your source code. Lycia can be used with and without proprietary language extensions, so applications can be developed in pure Informix 4GL or modernized by utilizing the vast range of language extensions and functions.
4 - Multiple Platform Support
Lycia is supported on all common Windows, Linux and Unix platforms:
- Windows 2003, XP, Advanced Server, Vista and Windows 7 (all with 32bit and 64bit support)
- Linux 32/64bit (RedHat, SuSE, Mandrake)
- Sun Solaris (SPARC 32-bit/64-bit, Intel)
- HP-UX (PA-RISC 32-bit/64-bit, Itanium 64-bit)
- Tru64/Digital Unix
- IBM AIX 32-bit/64-bit
- Apple OSx
5 - Multiple Database Vendor Support
Lycia supports most of the major database vendors. It provides dynamic translation from Informix-style SQL and Informix data type simulation to the target database vendor’s style.
Most development tools require the development to create unique data access layers for each required RDBMS system.
Due to Querix’s unique Dynamic SQL and Data Type translator, this is unnecessary. Keeping different versions of the data access layer means unnecessary work and a maintenance nightmare.
The following databases are currently supported:
- Informix IDS/SE/OnLine
- Oracle 8i/9i/10g
- Microsoft SQL Server
- IBM DB2
- MySQL
- PostgreSQL
- Other databases accessible via ODBC, including Adabas, Sybase, Xbase
6 - Lycia 4GL compatibility and interoperability with other languages (Java & C/C++) and tools
Lycia 4GL is based on the original Informix 4GL. Albert Einstein said "Things should be as simple as possible, but not simpler" and we agree. So Querix 4GL is as simple, readable and easy-to-learn as possible, while still being a high-level-syntax language designed for modern business applications. It's fully compatible with the classic Informix 4GL, Dynamic 4GL BDS and has a vast range of its own language extensions.
FourGen Migration
If you are interested in migrating your FourGen application to Querix 4GL, for the most part, the migration process should simply be a case of:
- Recompiling the FourGen libraries with Lycia
- Rebuilding your application
Lycia fully supports the interoperation of C, C++, EsqlC and Java
Lycia gives you the complete freedom of developing with 4GL, Java and C/C++ sources in co-existence, allowing you to build flexible and extensible enterprise applications.
7 - Easy Rapid Deployment for the application, SOA and UI-Clients
Lycia does not just give you the right tools to develop rapidly complex business applications. It allows you deploy them on a button click across multiple platforms without having to
recompile the sources. You do not even need to deploy the UI-Client. Our clients with Ajax and Java Technology can be used without any deployment on your client system - all what is required is a web browser. A few mouse clicks using the graphical 'Web Service wizzard' is all what you need to publish or utilize your business services (SOA).
Lycia is the perfect choice for smooth application deployment and also supports desktops, browsers, and cloud-based environments. Lycia helps you to accelerate
your application development, reduce the overal development costs and protects your existing 4GL investments.
8 - Cloud Computing
The Lycia infrastructure model offers easy and on-demand access to networks sharing configurable computing resources that can be swiftly provided and distributed with minimal administration effort. With the support of 4GL Web Service Clients and Provider functionality, any 4GL function can be made available as a Web Service entry point and can also utilize other web services.
9 - Business Intelligence and graphical Reports
The suite can also be extended with 'LyciaBI' for fully fledged enterpise business intelligence tasks. Due to it‘s wide offering of analytical tools, LyciaBI supports day-to-day and strategic business both at the decision-making and operational levels. LyciaBI Server is the main module of the suite, offering all the core and analytical functionalities. It is based on two main conceptual models (Analytical Model, Behavioural Model) and it provides all necessary administrative tools and cross-platform services.
The Analytical Model is the core of LyciaBI Server and covers the whole range of analytical needs, providing many solutions for each analytical area:
- Reports, to show structured data in a pixel-perfect way
- OLAP analysis, to navigate through data
- Graphs, providing simple and intuitive views of the information
- Dashboard, real-time monitoring of the KPIs
- KPI models, to build and test one‘s own performance monitoring models
- Geo-referenced reporting, to publish data over a geographical representation
- Cockpits, to realize complex and interactive dashboards
- Free Inquiry (QbE), to freely build one‘s own query and generate the first report template
- Data mining processes, to discover hidden information
- Office Documents, to publish Office documents under the behavioural model control
- Analytical Dossiers, to collect documents with personal notes
- Accessible Reports, in compliance with the international standard WCAG 2.0
- RT Console for the application monitoring
- Smart Filter for the guided data selection
- External Process, to execute external processes that can interact with OLTP systems
- ETL/EII processes, to collect data from different sources.