RPG2SQL Integrator

Integrate RPG, SQL and Excel for Maximum ROI.

What it Does

RPG2SQL Integrator closes the gap between applications running on different platforms by allowing all your databases and spreadsheets to talk to each other in real time. Forget about complicated file transfers, database replications and manual re-keying. The data integration software allows your IBM i/iSeries programs to read, write to and update databases such as Microsoft SQL Server, Oracle, MySQL and MS Excel spreadsheets.

And because data transfers take place instantly and without manual intervention, all your stakeholders get the information they need, when they need it. The result is greater productivity, better decision making and a bigger bottom line - made possible by data integration.

Key Benefits

Remove barriers

Break down the walls between your IBM i/iSeries and PC by sharing, transferring and converting data across platforms.

Work smarter

Save time and money by eliminating complicated file transfers, database replications and manual rekeying. Let RPG2SQL Integrator do it for you.

Seamless integration

Interactively share data between IBM i/iSeries and PC environments. Use RPG and COBOL programs to read, write, insert, update or delete records in real time from PC databases that use ADO or ODBC data sources, including SQL, Oracle, Access, Excel, dBase, FoxPro, MySQL and CSV.

Real-time updates

Because data transfers occur in real time, business systems are updated instantly, and customers, partners and other users get the information they need without having to wait for overnight updates, file transfers or duplicative data entry.

How it Works

  • Simple Data Integration

    With RPG2SQL, RPG and COBOL programs can open, read from and write to PC databases that use ADO or ODBC database sources, including SQL Server, Oracle and Microsoft Access and Excel. The PC server processes an RPG or COBOL request and then executes that task. The resulting data is then returned to the RPG or COBOL program for processing.

Who's using it?

Bachrach solved complex product, promotion and pricing issues on its Website by using RPG2SQL Integrator to get IBM i and Windows databases to share data in real time.
Download the Case Study (PDF)
De La Rue Cash Systems
De La Rue cashes in with RPG2SQL Integrator by cost-effectively integrating data across systems and platforms.
Download the Case Study (PDF)
Eldorado Casino
Eldorado simplifies data analysis and saves on printing costs by using RPG2SQL to integrate data that resides on different systems.
Download the Case Study (PDF)
iDocket improved data integration and eliminated the need for a $500,000 server upgrade by shifting database searches to dedicated PCs running using RPG2SQL Integrator.
Download the Case Study (PDF)
The Pantry
The Pantry uses RPG2SQL Integrator to more efficiently transfer data across multiple platforms while removing obstacles and reducing manpower requirements.
Download the Case Study (PDF)

Looking for Support

You’ll find all relevant support resources for RPG2SQL Integrator software in our Support Center, including:

  • Documentation
  • Installation Instructions
  • Upgrades
  • Licenses
  • Troubleshooting
  • Tutorial Videos

The Document Lifecycle

Stage 1: Capture

Capturing signatures and data, and creating forms and reports that people can easily access, use, and distribute is the first stage of the document lifecycle. Learn how products like SignHere, iForms and WebForms can digitize documents and data, decrease paper costs and speed up workflow.

Stage 2: Manage

Securely managing documents and other data after they have been captured or created is the second stage of the document lifecycle. Learn how products such as WebDocs and inContact can give you the tools to securely find, use and store information, no matter where you are.

Stage 3: Distribute

Getting documents and data to the people who need them – on time and in the format they need – is the third stage of the document lifecycle. Learn how products like DeliverNow and Enterprise Workflow can automate document distribution and speed up business processes.

Stage 4: Secure

Securing data and documents is the final stage of the document lifecycle. Learn how WebDocs and our Security Solutions can protect key business information from cyber threats, data loss and costly downtime.