IBM iSeries Overview

The IBM iSeries, also known as IBM Power servers, is a midrange computer system introduced by IBM in 1988. Originally released as OS/400, it has evolved from the System/38 CPF operating system and was renamed to IBM i in 2008. This platform is renowned for its adaptability, designed to meet the changing needs of businesses and computing environments.

IBM i is a fully integrated operating system that combines a database, middleware, security, runtime, and hypervisor into a single stack. It inherits distinctive features from the System/38 platform, such as the Machine Interface, object-based addressing, and the tight integration of a relational database. These features work together to provide a reliable and efficient environment for running business applications.

The IBM iSeries supports a variety of programming languages and character encodings, making it a versatile choice for organizations. It offers autonomous features that significantly reduce the need for large system administration teams, and can be integrated with modern technologies including AI, IoT, and data analytics. Furthermore, the iSeries can be deployed across different cloud environments, offering flexibility for public, private, and hybrid cloud setups.

IBM iSeries Plugins for Excel

Excel Data Transfer Add-In Overview

The IBM iSeries plugin for Excel, known as the Excel Data Transfer add-in, facilitates the integration between Excel and IBM iSeries systems. This add-in allows users to execute download and upload transfer requests within 32-bit versions of Microsoft Excel, streamlining data management tasks between the two platforms.

Installation of Excel Data Transfer Add-In

The Excel Data Transfer add-in is typically installed automatically with the installation of Client Access or iSeries Access. However, it is not installed automatically if Client Access or iSeries Access is installed with a custom installation or a 5250 installation. For Microsoft Office versions such as Office 2000, Office 2003, Office XP, Office 2007, and Office 2010, the add-in does not install by default.

Manual Installation of Excel Data Transfer Add-In

For instances where the Excel Data Transfer add-in is not installed, it can be added manually. This is done by navigating to the directory where Client Access or iSeries Access is installed and running the cwbtfxla.xll file. Users should note that the Excel Data Transfer add-in is not supported with Excel 2013, indicating that integration with more recent versions of Excel may require alternative solutions or updates.

Common Use Cases

• I

  
  Data transfer between IBM iSeries and Microsoft Excel
• I

  
  Real-time multidimensional analysis and reporting within Excel
• I

  
  Automated data workflows including validation and error checking
• I

  
  Collaborative real-time work and secure data management from anywhere
• I

  
  Direct connection to IBM Planning Analytics for advanced data management and analysis

Frequently Asked Questions

What is the IBM iSeries Excel plugin?

The IBM iSeries Excel plugin is a data transfer add-in for Microsoft Excel that allows users to run download and upload transfer requests from 32-bit versions of Microsoft Excel.

How can I install the IBM iSeries Excel plugin?

If the plugin is not installed automatically, you can add it via the Add/Remove programs in the Control Panel for iSeries Access for Windows. Instructions are also provided in the Client Access or iSeries Access User's Guide.

Which versions of Excel and Client Access are compatible with the IBM iSeries Excel plugin?

The plugin is designed to work with Client Access for Microsoft Windows 95 and Windows NT, Client Access Express, and IBM iSeries Access products, and supports data transfer up to and including V5R4 iSeries Access for Windows. It is not supported with Excel 2013.

How do I know if the IBM iSeries Excel plugin is installed?

Users can verify if the plugin is installed through selective setup in the Client Access or iSeries Access group. The plugin should also display toolbar buttons under the Add-in tab in Excel when installed correctly.

What should I do if the IBM iSeries Excel plugin does not appear in Excel?

If the plugin does not appear, ensure it is installed by checking the Add/Remove programs in the Control Panel for iSeries Access for Windows. If it's not installed, follow the manual installation process as detailed in the User's Guide.