Interfaces to Other Languages or Databases

Code and tools for creating a connection between ABL applications and other language systems or databases


Progress 4GL Wrapper for Zlib Library

Gzip encoding for Progress 4GL based on zlib library written by Jean-loup Gailly - http://www.zlib.net/


prosql

Often I have needed to integrate Progress Databases with other applications. These applications have a horrible time talking to Progress. Yes, I know, “But, but, but there is the ODBC and JDBC connections!”
Well, that is nice if you are on Windows. I am on UNIX or some non-Progress supported operating system or using some form of middle-ware (read that as PHP, Perl, etc.) to make the integration with. Sometimes it has ODBC, sometimes it doesn't.
Sometimes it is a device that needs to interact with Progress DBs and the infrastructure just is not there.


pro2myv2 amduus edition

Use of CLI tools for exporting of Progress schema and data to MySQL with Amduus modifications to Mark Newnham's Pro2myv2 Open Source tool.

The open source tool pro2myv2 has been modified by Amduus to be more UNIX oriented. (It originally was GUI oriented and can still be used in a GUI environment.) This way it can be used from a non-GUI environment and from cron for automatic data exporting and loading from Progress to MySQL.

Attn: This tool requires a developers or query license for the version of Progress it is being used on.


pro2my or pro2myv2

Pro2My is a simple group of PROGRESS source code routines that can be run against any PROGRESS database greater than version 6 to produce a series of files containing MySQL format SQL statements. These files can be used to produce a MySQL database that is a mirror of the PROGRESS database. The routines provide a method of:

  • Extracting the data schema from the PROGRESS database
  • Checking and converting PROGRESS data to prevent MySQL database load errors.
  • Extracting the data from the PROGRESS database.

pro2mysql

Interface for Progress 4GL to query mysql databases.
Functions work like they do in php.

code: browse the code in the Subversion repository http://www.oehive.org/amduus/pro2mysql/

contributed by Matthew Lang


pro2jdbc

pro2jdbc - Progress to JDBC interface

pro2jdbc.p usage:

  1. Run pro2jdbc.p as persistent procedure then open server connection usging jdbcOpenConnection() (that two steps might be done at the beginning of your application).
  2. Run several selects using jdbcExecuteQuery(), retrieve records using jdbcGetRecord().
  3. Finally close connection using jdbcCloseConnection() and remove persistent procedure (that two steps might be done at the end of your application).

http://www.oehive.org/amduus/pro2jdbc/


pro2pgsql (Progress to PostgreSQL)

A set of 4Gl routines to migrate schema and data from a Progress DB to a PostgreSQL database.

** Package:

http://www.oehive.org/amduus/pro2pgsql/


jpjvm

This project is for the maintenance and support of John Green's "jpjvm" DLL, which loads a JVM into a Progress/OpenEdge session.


Progress/400 to OpenEdge/ODBC transformation

This zip file contains utilities and documents to aid the transformation form the V9.1C Progress/400 DataServer to the OpenEdge DataServer for ODBC. The OpenEdge DataServer for ODBC is not a direct product replacement for the Progress/400 DataServer, which retired in September 2004. The OpenEdge DataServer for ODBC provides generic connectivity to various data sources (including DB2 for Windows and the AS/400) via the ODBC open standard protocol. Although the ODBC protocol is in alignment with IBMs UDB2 RDBMS strategy (SQL only access) the generic nature of the OpenEdge DataServer for ODBC means that that specific RDBMS features related to functionality and performance can not be utilized and therefore performance (as compared to the Progress/400 DataServer) is going to be an area of the transformation process that will require special attention. The embedded whitepaper titled DB2 Accessibility Whitepaper May 2006 is currently a draft edition and will be updated overtime.


Syndicate content