TYLOGIX Data and Interfaces Reference Page

Back to Tylogix Home Page


Data Quality and Data Integration

Interfaces & Data Transmission

Data Integration and Data Quality Groups

Data Quality Pro

Data Migration Pro

A Scorecard approach to improving Data Quality

Monitoring Data Quality Performance Using Data Quality Metrics

Data Quality Management Software Product Directory (2009 Edition)

IBM Library Links

AS/400 Java Application Models

The IBM library also contains:
* Common Programming APIs Toolkit/400 Reference V3R7
* OS/400 Sockets Programming V4R2
* Where to Find Information on Secure Sockets Layer (SSL), 1.0

Open Source Data Integration Solutions

Note: These solutions also typically offer data transmission as well as transformation services.

Apatar

Cloveretl

Pentaho

Pervasive

SnapLogic

Talend

XAware

Open Source Data Quality Solutions

Talend Open Profiler

eObjects DataClean

 

 

FTP Programming

Practical Programming for AS/400 FTP Automated Interfaces

FTP is one of the most widely used modes of transferring data between systems, regardless of their operating systems. The link above features an article that I have written on AS/400 Automation.

Socket Programming
General Socket Programming Links

At the heart of the "Client-Server" expression, Sockets are a standard as well as a method of communicating. This is one of the most versatile and well-known methods of communicating over an IP network.

Most socket code is done in C, but IBM has recently come up with RPG implementations also. Both C and RPG implementations are supported on the AS/400

BSD Sockets: A Quick And Dirty Primer
TCP/IP BSD Sockets
Netscape Secure Socket Layer Technical Brief
Scott Klement's RPG IV Online Socket Tutorial

IBM Library Links

AS/400 Java Application Models

The IBM library also contains:
* Common Programming APIs Toolkit/400 Reference V3R7
* OS/400 Sockets Programming V4R2
* Where to Find Information on Secure Sockets Layer (SSL), 1.0

APPC Programming

APPC Communication Testing on the AS400
The IBM On-Line library also contains:
* OS/400 APPC Programming V4R1

While APPC and APPN are deemed to be eating TCP/IP's dust, this is still a widely used protocol, as there still are many IBM machines using this method of communication.

On the AS/400, an APPC connection is a matter of creating an ICF file linked to a controller, which itself is linked to a device. Any RPG or C program can access these files with relative ease.

Information on APPC Programming can also be found in the IBM on-line library.

MQ Series

MQ Series for AS/400
MQ Bridges

Business Integration Solutions with MQSeries Integrator (Red Book)

MQ Series is an IBM product for secure, guaranteed communications. Think of it as the "FedEx" of interface deliveries. If you are sending data and somebody cut the wire in the middle of the transmission, MQ can be configured to remember where the transmission was interrupted and resume from there. This product may look heavy but it is a good choice for mission-critical transmissions.