Features
		Industry Standards Based - Supports industry access standards including: SQL, ODBC, OLE DB, JDBC and .NET.
		Reusable Architecture - A single metadata model can be created, spanning all enterprise data sources and applications requiring data access.
		Distributed SQL Engine:
			Fast Performance - CONNX utilizes this engine by distributing query processing between the client and the server without sending duplicate data across the network. As a result, the work is done on the machine that is best suited for the task. Scalability - CONNX is easily adaptable to all environments, enabling organizations to scale from project to enterprise; from two-tiered to n-tiered; and from one to many data sources. Thus, the amount of resources available to CONNX increases as you add clients.

		Cross-Platform Joins - With a single SQL statement, CONNX allows your applications to join related data across systems as if all data existed in one relational database.
		Business Views - CONNX supports the creation of data views across and within data sources, allowing related data from different sources to appear as one logical table and enabling the simplification of complex structures.
		Security - CONNX respects all existing database security and provides additional user group, row, field, table and database security. CONNX provides a complete level of ANSI security above and beyond any existing security in place.

 

Benefits         Preservation of Existing Systems - CONNX preserves your existing legacy systems investment by providing standards-based real-time read/write access to the data you need, often eliminating the need to migrate data or create data warehouses.         Reusability of Existing Reports and Applications - When you move from one application platform to another, your investment in CONNX will not be lost. CONNX acts as a middle layer between your applications and reports. Those applications will continue to work as designed even though the data has moved and the data structures have changed.         Vendor Neutral - Because CONNX is based on open standards, your enterprise is not locked into one proprietary solution. With CONNX you can . . .   combine related information from different systems into one true enterprise-wide view across the IT structure of your organization.         use this same view for development or business intelligence using familiar end-user tools and applications.         maintain and capitalize on the investment in your enterprise data, combine it with the latest technologies, preserve the integrity of that data, improve productivity and keep your business running smoothly.         rest easy that as business requirements evolve, your data source and/or targets can change independently of your desktop applications or environment.         Empowering End Users - CONNX makes data more understandable to end users. Through CONNX features such as Aliases and Views, your IT department can simplify data structures, field names, and pre-join related data for their end-users without modifying their database.       Learn More About CONNX Capabilities