CYBERSCIENCE Supported Relational Databases

Cyberscience Business Intelligence is available for all major relational and non-relational database systems. Thus, Cyberquery supports your current and most alternative environments.

The benefits of multiple simultaneous database support

Cyberquery simultaneously supports different database systems. This means Cyberquery seamlessly joins data from disparate systems, for example; sales information from Microsoft SQL Server, product data from Oracle or Progress and personnel data from C-ISAM all in the same report. Cyberquery hides all physical details of the underlying data. This eliminates complexity and maximizes user productivity.

Cyberquery database independence

All details of the physical underlying database are hidden in the Cyberquery Data Dictionary. This means that all reports, queries and data extracts are completely independent of the database. Thus Cyberquery provides you with the freedom to change the database you use in the future as operational needs dictate without the need to modify any queries. We support relational and non-relational databases. The relational databases we support include:

Your relational database is:	IBM DB2	IBM-Informix OnLine/IDS	ODBC	Microsoft SQL Server
	Oracle	Progress	Sybase	MySQL	PostgreSQL

IBM DB2

Cyberquery fully supports DB2 including simultaneous support of multiple servers and databases. We support the DB2 outer join capability. Cyberquery is a native DB2 client, providing either networked or local connection to DB2 Universal Database servers. Supported operating systems: AIX, HP-UX, Linux, Solaris and Windows.

IBM-Informix OnLine/IDS

Cyberquery accesses Informix Dynamic Server (IDS) as a native ESQL/C client, providing either networked or local connection. Cyberquery can access multiple IDS databases in a single query, and provide support for IDS stored procedures. Supported versions are 7.x, 9.x (IDS2000) and 10.x.

ODBC

Cyberquery supports Open Database Connectivity (ODBC) 2.0. The ODBC interface uses a relational model to communicate with databases, even if the database is not itself relational. This provides access to all databases which offer an ODBC interface, on both Windows and Unix-based systems.

Microsoft SQL Server

Cyberquery supports Microsoft SQL Server 2008 R2 and earlier, including 2000, 2005 and 2008, using either networked or local connection. Enquiries may reference tables from more than one database and from more than one server.

Oracle

Cyberquery provides a high level of integration with Oracle, using the Oracle outer join capability and many of the Oracle intrinsic functions. Cyberquery is a native OCI client, providing either networked or local connection to Oracle 8i, 9i, 10g, 11g and 11g R2 servers.

Progress

Cyberquery supports:

Progress 7, 8, 9, 10 and OpenEdge databases under Unix;
Progress 8, 9, 10 and OpenEdge databases under Windows.

Cyberquery accesses Progress using a native ESQL interface, providing either networked or local connection. Cyberquery supports access to multiple databases in a single query. See Cyberquery for Progress Software Partners and Cyberquery for QAD.

Sybase

Cyberquery supports Sybase 10, 11, 12 and 15. Enquiries may reference tables from more than one database and from more than one server. Cyberquery accesses Sybase using a native DBLibrary connection providing either networked or local connection.

MySQL

Cyberquery supports MySQL versions 3.x, 4.x and 5.x. Enquiries may reference tables from more than one database and from more than one server. Cyberquery accesses MySQL over ODBC on both Windows and Unix-based systems.

PostgreSQL

Cyberquery supports PostgreSQL versions 7.x and 8.x. Enquiries may reference tables from more than one database and from more than one server. Cyberquery accesses PostgreSQL over ODBC on both Windows and Unix-based systems.