Remote Database Access from your IBM i
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.
As your enterprise applications expand in database requirements and complexity, so does the 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’ll need to implement a complex solution that requires additional middleware, doesn’t use SQL statements or integrates with IBM’s Call Level Interface (CLI) that relies on complicated APIs and which provides only partial functionality.
DRDA (Distributed Relational Database Architecture), which only connects DB2-like databases, limits the possibility of accessing databases that support JDBC, one of the most common methods for inter-system data access.
DB-Gate empowers IBM i customers with exciting data access capabilities, employing standard OS/400 facilities to enable totally database-transparent access to remote systems.
Using native SQL tools and interfaces on the IBM i, users can now access specific files on DB2 and non-DB2 remote databases without any special hardware appliance or proprietary software on the remote database. Access is now available through natural interfaces such as interactive STRSQL or directly from any standard RPG, Cobol, C, etc. program
- 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 CRTSQLxxx).
- Native integration with STRSQL enables prompting for remote database Column names and attributes.
- Expands IBM i-based DRDA functionality by enabling transparent connectivity with JDBC databases which support DRDA.
- Use of standard SQL syntax preserves familiar work environment
- OS/400 Server Authentication integration allows for transparent insertion of user name and password defined to a specific remote database definition.