SEQUEL Connects to Remote Databases for Free

SEQUEL allows you access to DB2/400 databases, along with 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.

Figure 1: The SEQUEL Dashboard offers connections to multiple databases. (Click images to enlarge.)

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.

Figure 2: Users can connect to a remote database by selecting from a drop-down list.

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.

Figure 3: Select tables to add to your view.

Our support team can show you how easy it is to use SEQUEL to solve your database access issues. Call us at 800.328.1000 to request a live demo or a FREE 30-day trial in your own network of databases. Or view an archived presentation on this topic. And check out Help/Systems' other offerings in the MC Showcase Buyer's Guide.

Tom Huntington is Executive Vice President of Technical Solutions at HelpSystems, and has been with the company for nearly 30 years. He works with business alliances, acquisitions and large customer relationships and ensures that the HelpSystems software works with other major software and hardware vendors worldwide.

Tom often speaks on enterprise scheduling, security, automation topics, IBM i technology, and the HelpSystems products, and hosts technical presentations on a variety of automation topics. He is the author of the HelpSystems IBM i Marketplace Survey and has written articles on automated operations, security, cloud computing, and business intelligence for leading trade journals and newsletters. He was named an IBM Champion in 2016, 2017, 2018, 2019, and 2020 for over three decades of advocation and thought leadership on the IBM i platform.

Contact Tom at This email address is being protected from spambots. You need JavaScript enabled to view it..