iSecurity is a leading solution for Power i, iSeries and AS/400 Security Learn More about iSecurity
 iSecurity Overview
 Market Need
 iSecurity Products A-Z
 Prevention Pack
 Compliance Pack
 Application Security Suite
 iSecurity GUI
 Scope Products
 iBi Visualizer
  Change Tracker
  PTF Tracker
  Password Reset

iSecurity DB-Gate

Direct IBM i client-only access to non-DB2 databases

DB-Gate empowers IBM i customers with exciting data access capabilities, based on Open Database Connectivity (ODBC), employing standard IBM i facilities to enable fully database-transparent access to remote systems.

Using native SQL on the IBM i, users can now access specific files on DB2 and non-DB2 remote databases without any special hardware appliance or software on the remote database. Access, which is possible from interactive STRSQL and from any standard RPG, Cobol, C, etc. programs, is now easier and more natural than ever.

DB-Gate has been proven to be a successful and full replacement for Oracle Access Manager (OAM); note that OAM is not supported beginning with IBM i release 7.1!

The Challenge of Multi-DB Access from within the IBM i

As your enterprise applications expand in database requirements and complexity, so does your need to access multiple databases from your main application server. Current methods of accessing specific files on a remote database from within the IBM i require considerable time and resources.

If you aren't willing to transfer large batches of files (using FTP) to get to specific data you need, you'll need to implement a complex solution that requires additional middleware, use non-standard SQL statements or integrate IBM's Call Level Interface (CLI) that relies on complicated APIs and which provides only partial functionality.

The current limitation of DRDA (Distributed Relational Database Architecture), which only connects DB2-like databases, limits the possibilities of accessing databases that support JDBC, which is probably the most common standard for inter-system data access.

Top DB-Gate Benefits & Advantages

  • "Opens" the entire non-DB2 spectrum of databases
  • Greatly expands programmer's capabilities when working with non-DB2 databases
  • Reduces the need for redundant data and ETL (extract, transformation, load) data manipulation products
  • Provides detailed traceability logs
  • Eliminates the need for *SQLPCK, even when accessing another DB2 database (including one on the IBM i)
  • Low entry cost
  • No overhead
  • Virtually no learning curve.

iSecurity DB-Gate Features

  • Unique technology enables transparent access to any database (MySQL, ORACLE, MS SQL,DB2, Informix, SQLite) or data source (e.g., Excel) which resides on any IBM or non-IBM platform using STRSQL, STRQM or programs in languages such as RPG, Cobol, etc. (compiled using CRTSQL...).
  • Integrated with the STRSQL lets you prompt to see the Table names, Column names, and more.
  • Expands IBM i-based DRDA functionality by enabling transparent connectivity with JDBC databases not supported by DRDA
  • Uses standard SQL syntax and is based upon standard IBM i functionality - so there is virtually no learning curve to get up and running.
  • Remote Server Authentication that makes use of the IBM Server Authentication Entries, injecting them seamlessly when needed, and eliminating the need to remember and re-enter a user name and password for each CONNECT to a remote DB.

Learn about related iSecurity products:

  DB-Gate Data Sheet

  DB-Gate Success Stories

  Download DB-Gate Presentation

  View On-Demand DB-Gate Webinar Demo

  Download DB-Gate FREE Time-Limited Trial

   Quick Links
Download FREE Trial

Raz-Lee on YouTube

Raz-Lee on Twitter

iSecurity Solution for Power i, iSeries and AS/400 Security
Copyright © 2009 Raz-Lee Security. All rights reserved  
Terms & Conditions | Site Map