How do your queries access Oracle, MySQL, SQL, and other databases?

Do you need to combine System i, UNIX, and Windows data all on one executive dashboard panel? Do you need to consolidate data from multiple databases in your network? Are you tired of being forced to transfer System i data from your DB2/400 database to a data warehouse so that it can be queried?

The basic i5/OS Query product allows you to access only your local DB2 data through the queries you write. IBM’s new Web Query tool also allows you to access your DB2 data, but it costs extra to use and connect to other databases. In addition, you have to go somewhere else for support for these connections. Other tools allow you to access DB2 data on your System i, but they do it from Windows or UNIX. Wouldn’t it be nice to have a System i-centered solution?

SEQUEL connects to remote databases—FREE
SEQUEL allows you to access DB2/400 databases, along with access to Oracle, MySQL, Microsoft SQL Server, and other JDBC type 4 databases. SEQUEL makes it easy to create connections to these databases. Best of all, end users never have to know that they are viewing data from another system, or building a dashboard that presents data from multiple sources.

For example, you can combine data from Oracle, SQL Server, and DB2 into a single executive view (see Figure 1). With SEQUEL, your team can access other servers for no additional charge.

How easy is it to connect?
The SEQUEL Administrator makes it easy to set up connections to other databases. You just enter the system name, or IP address, along with a user ID and password. Once the connection has been configured, any

SEQUEL user can manually point to the defined database (see Figure 2). Or, users can set up their defaults so they always access the selected database. With SEQUEL, users can simply build a view and choose the files they want to use, without worrying where they are located.

How easy is it to add tables?
To see a list of tables you can query, simply click on the file list (see Figure 3). Just as you can with DB2 files, it’s easy to select the tables you need to create new views, tables, drill downs, summarized graphs, reports, and more from your non-System i data.

Our support team can show you how easy it is to use SEQUEL to solve your database access issues. Call us at 1-800-328-1000 to request a live demo or a FREE 30-day trial in your own network of databases. Or, you can download and view an archived presentation on this topic.

Contributed by Tom Huntington, Vice President of Technical Services

This entry was posted on Wednesday, February 20th, 2008 at 9:39 am and is filed under SEQUEL. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.