RDB Connect
Finally, a product that provides easy and full SQL access to remote databases from all System i high-level languages - RDB Connect. Easily access all your databases from an RPG program! The technology used in DBU RDB is now available for programmers to integrate into their applications and tie in remote data to their systems.
RDB Connect is a collection of commands and functions allowing record level access to remote data using RPG, COBOL or CL! Currently RDB Connect allows access to MySQL, Mircrosoft SQL Server, Oracle, Postgre, and more. RDB Connect will run on System i with an operating system version of V4R5M0 and above. It requires an IP connection to the remote server that is running the database to access.
Full SQL access to remote databases from an RPG program (or any language)
- Quickly share data across platforms
- Use RDB Connect APIs (Application Program Interface) to execute SQL queries for access to remote data
- Allows any SQL query to be run
- Import & Export the remote data, to and from the System i
- Communicate with remote databases directly from RPG, COBOL, or CL programs
- Can be used in batch or interactive programs
RDB Connect is a stand alone product that offers a procedural API for using SQL queries to access remote data. An implementation of RDB Connect will contain one or more applications, a core RDB Connect library, and one or more "database drivers". The core library, independent of the applications and remote database, acts as an "interpreter" between the applications and the database drivers, whereas the database drivers contain the remote database-specific details. Thus a programmer can write applications that use standard types and features without concern for the specifics of each remote database that the applications may encounter. Likewise, database driver implementors need only know how to attach to the core library. This makes RDB Connect modular.
Uses:
- Synchronize data between computers
- Generate reports from data which resides on remote computers
- Eliminate data transfers or duplicate data entry
- Read, insert, update and delete records programmatically
RDB Connect's data integration will help increase productivity. You no longer have to wait for data from remote databases to be updated. RDB Connect does this instantly for you, giving you access to current and accurate data from remote systems. It allows you to quickly access and share data across multiple platforms. Now you can generate reports and use information the way you want, when you want.
RDB Connect allows you to remotely access and share remote data from:
- MySQL
- Microsoft SQL Server
- Oracle
- Postgre
- DB2
We use RDB Connect in our current DBU RDB (remote database) plugin to allow DBU users to access their remote data via the System i's DBU interface...it's proven!