SQL Access To DBMS (DBMS only)
TECHNICAL ARTICLES -> DB ACCESS ARTICLES
[ Next ] [ Printer Friendly Version ]

If you feel as if your mission-critical production data is trapped inside a proprietary data manager, then you haven't heard about Attunity Connect from Attunity (www.attunity.com) – providing an industry-standard SQL access to more than 30 data sources, including Oracle CODASYL DBMS database.

In the past, customers who may have been best served by a CODASYL-style database management system for their application were swayed to a relational database, typically because of the availability of tools and familiarity with the relational programming environment. With the availability of the SQL interface to DBMS, customers may now feel confident in choosing the right underlying database management system for their business needs, and not sacrifice their choice of 4GLS, query tools and programming styles.

Tools, tools, tools

Attunity Connect allows much more flexibility than "just the ability to write high level programs with imbedded SQL statements." The Attunity Connect allows virtually any product that accesses data using SQL to access DBMS. This provides DBMS sites with a wide choice of 4GLS, client/server front-end tools, query and programming tools.

Many of the SQL tools available under MS Windows or the Mac environments will allow you to access your DBMS data. Imagine accessing your DBMS data using Microsoft ACCESS, Visual BASIC or even Excel!

Read & Modify with SQL!

Attunity Connect provides more than read-only access to your data. With the Attunity Connect product, you can modify existing data. 

KEY FEATURES OF ATTUNITY CONNECT INCLUDE:

• Universal data access and both applications and integration. Attunity Connect integrates relational, network, indexed, hierarchical, object, flat and application-based data sources – with each other and with today's eBusiness and B2B solutions. 

• Application Adapter Framework (AAF). The AAF extends Attunity Connect's existing data access capabilities with a new, easy way to integrate applications at a much higher level of programming interaction – using JCA, XML or native application interfaces. 

• Transparent interfaces. Applications can issue the same query - using JCA, XML, JDBC, ODBC or ADO/OLE DB interfaces, as well as Oracle and SQL Server database gateways, to all Attunity-supported applications and data sources. 

• Heterogeneous and distributed joins. With Attunity Connect, applications can perform joins across multiple data sources without a dedicated data server or programming – using a single SQL statement. Attunity Connect exploits each data source's native capabilities to carry out the joins in the most efficient manner. 

• Query optimization. Attunity Connect boosts performance by distributing processing to the most efficient and powerful server. It executes different parts of the query across the network and returns only the end result to the requesting application. 

• Peer-to-peer architecture. A single installation on any platform handles both incoming and outgoing requests for data. The same software, and any applications based on that software, can access multiple, existing and new data sources without additional programming. 

• Universal SQL. Attunity Connect native data adapters take advantage of platform-specific features to improve performance and compensate for sources with limited or no SQL support; this feature shields developers and applications from differences among data sources. 

• Web-enabled mainframe and legacy systems. Organizations can integrate back-office applications and information with web solutions using Attunity Connect. Web applications can employ Attunity's standard interfaces to exchange information with mainframe and legacy systems – with a single development effort that involves only the web applications themselves. 

• XML enterprise data. Embedded XML support gives organizations an even more open, flexible and compatible way to incorporate their IT resources in eBusiness solutions. Attunity Connect can receive SQL statements in XML and return results in XML, enabling solutions to construct complex XML documents using straightforward SQL statements.