RDB Connect 3.0

Remote Database access

RDB Connect

DBU Audit Whitepaper Available Now!Finally, a product that provides easy and full SQL access to remote databases from all IBM 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, Microsoft SQL Server, Oracle, Postgre, Access, DB2 and more. RDB Connect will run on IBM 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 IBM 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
  • Access
  • Oracle
  • Postgre
  • DB2
  • and More!

We use RDB Connect in our current DBU RDB (remote database) plugin to allow DBU users to access their remote data via the IBM i's DBU interface...it's proven!

back to top

Now you can generate reports and use information the way you want, when you want. RDB Connect is a stand alone product that offers a procedural API for using SQL queries to access remote data. It gives you access to current and accurate data from remote systems.

RDB Connect

RDB Connect Case StudyAAA Cooper Transportation Access Real-Time Driver Information

RDB Connect Case StudyJust What the Doctor Ordered

Your Data Needs to TalkYour Data Needs to Talk - Spotlight Profile by Don Rima

RDB Connect Features

  • Read and write to remote data sources
  • Create, copy, update and delete records
  • Works with ILE RPG or COBOL programming
  • Requires no database replication
  • Allows any SQL record selection query to be run

RDB Connect Benefits

  • Eliminate database replication which increases productivity
  • Data is always current
  • Seamless data integration

RDB Connect Uses

  • Share data across platforms
  • 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

Products

IBM Business Partner

Support Information

  • Annual contract available
  • Provides technical assistance and product releases
  • Disaster Recovery
  • Customer Portal
  • FAQ knowledge base
  • Promotional discount for other products
  • Video Demos
  • Webinars
  • Individual demos / webinars available upon request
  • Product Documentation Page

IBM Platforms
AS/400, iSeries, i5, Sytem i, IBM i and Power Server

 

Testimonials

Two Thumbs UP on RDB Connect!

"I installed the trial version of RDBConnect on Friday and am VERY pleased. Over the weekend I wrote several RPGLE programs using RDBConnect. Connections & transactions between our two systems are very quick. And the learning curve was minor. We are working on a Web based ordering system. We needed some way to be able to "talk" to the webserver/sql server from an RPGLE program and RDBConnect has made it very easy."

Robert Stitzel

"We are using DBU RDB to access remote MSSQL databases.    IBM doesn't provide an easy way for the IBM i to be a client to a remote SQL database, but DBU RDB does!

Since a lot of the company's data resides on MS servers running MSSQL, we needed a way to examine and get that data into native, IBM i physical files. DBU RDB does both! "

Wilson Jones
Tulsa, OK

"We love DBURDB! Prodata has RDB for DBU which allows you to do a DBU on the remote database, where RDBCONNECT allows you to connect to the remote database using a CL or RPG program. Plus, their support is world-class!"

Bruce Collins,
AAA Cooper Transportation