Standards-based data access to relational and non-relational data sources
Attunity Connect provides data access solutions on platforms ranging from Windows to Mainframes. Attunity Connect provides universal data access and connectivity allowing applications on any computing environment including .NET, Java/J2EE and legacy 3GL to access any of the supported data sources.
Attunity Connect provide comprehensive data access capabilities including:
|
Universal Data Access
|
Provides many SQL clients that fit any enterprise environment including ODBC, JDBC, OLEDB, and ADO.NET.
|
|
Standard SQL support
|
Supports ANSI SQL-92 to allow seamless integration and reuse of a common skill set.
|
|
SQL Access to Non-Relational Sources
|
Provides metadata import facilities and catalog definitions enabling the use of SQL to access non-relational sources such as VSAM and Adabas.
|
|
Read and Write
|
Support reading as well as update capabilities to all supported data sources.
|
|
Transaction management
|
Supports 2PC such that data sources can participate in distributed and global transactions.
|
|
Query Governing
|
Provides a mechanism to protect against ‘bad queries’ and their impact on the underlying data source.
|
|
Ease of Use
|
No coding is required, and users employ the Attunity Studio graphical user interface to quickly configure, test, and deploy data access.
|
Supported Data Sources (drivers and adapters)
Non-Relational data sources:
Relational databases:
- DB2, DB2/400, DB2/UDB
- DBMS
- Informix
- NonStop SQL/MP
- Oracle
- Oracle Rdb
- SQL Server
- Sybase
In addition, Attunity Connect provides generic ODBC and OLEDB connectivity that can leverage 3rd party ODBC or OLEDB compliant drivers and extend access to additional data sources.