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.