Difference between revisions of "ISeriesAccess"

From MidrangeWiki
Jump to: navigation, search
m
 
(6 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[[Category:5250 Emulators]]
+
iSeries Access has been superseded by [[IBM_i_Access_Client_Solutions]]
[[Category:Administration]]
+
 
[[Category:Database]]
+
Current name: IBM i Access, product 5761-XW1, 5770-XW1
[iSeries Access http://www-1.ibm.com/servers/eserver/iseries/access/windows/] is the Windows based 5250 emulator available from IBM.   
+
 
 +
[http://www-03.ibm.com/systems/i/software/access/windows/ iSeries Access] is the Windows based 5250 emulator available from IBM, formerly known as Client Access.   
  
In addition to 5250 emulation, iSeries access provides ...
+
In addition to 5250 emulation, iSeries access provides:
  
 
* [[iSeries Navigator]] -- Graphical user interface to manage the system.
 
* [[iSeries Navigator]] -- Graphical user interface to manage the system.
 
* [[ODBC Driver]] -- Database access for MS Windows systems
 
* [[ODBC Driver]] -- Database access for MS Windows systems
 +
* Data transfer between PC and System i
 +
* Uses i/OS NetServer to work with [[IFS]] files
 +
* Windows Excel file transfer add-in
  
 
iSeries Access is also available for Linux, though missing some of the more powerful features found in the Windows version.
 
iSeries Access is also available for Linux, though missing some of the more powerful features found in the Windows version.
  
 
iSeries Access for Web gives browser based access to 5250 sessions, file transfer, job, message and spool management and more. Requires a java application server on the iSeries, which can be WebSphere or TomCat.
 
iSeries Access for Web gives browser based access to 5250 sessions, file transfer, job, message and spool management and more. Requires a java application server on the iSeries, which can be WebSphere or TomCat.
 +
 +
IBM i Access [[IBM_i_Access_Client_Solutions | Client Solutions]] is a Java application that runs on the client PC.
 +
 +
===Excel add-in===
 +
System i Access offers an Excel add-in that makes it simpler to transfer a spreadsheet to or from the System i. 
 +
 +
To install that add-in:
 +
* Close Excel
 +
* Open System i Navigator ([[iSeries Navigator]])
 +
* Click on a System i Connection
 +
* At the bottom, right pane, select ''Install Additional Components''
 +
** Fill in the server
 +
** Sign in
 +
** Under Data Access, Data Transfer, select the Excel add-in
 +
** After installation is complete, close System i Navigator (save the memory!)
 +
* Open Excel
 +
** Tools, Add-ins, Browse
 +
** {{code|Program Files, IBM, Client Access, Shared, cwbtfxla.xll}}
 +
** OK to install
 +
 +
To transfer from i to PC,
 +
* Data, Transfer data from iSeries (a new icon is on the tool bar, too)
 +
* Choose the file you want and Next
 +
* There are several options that can be changed here:
 +
** SQL to select/omit records
 +
** Date/time formatting
 +
** 65535 (binary) conversion
 +
 +
==External links==
 +
* [http://www-03.ibm.com/systems/i/software/access/index.html System i Access] home page
 +
* [http://www-912.ibm.com/s_dir/slkbase.NSF/1ac66549a21402188625680b0002037e/361c99668cfb25c086256a3f005fd2e6?OpenDocument System i Access Excel Add-in upload function]]
 +
 +
==Categories==
 +
[[Category:ISeries Access|*]]
 +
[[Category:5250 Emulators]]
 +
[[Category:Administration]]
 +
[[Category:Database]]
 +
{{stub}}

Latest revision as of 19:29, 26 February 2016

iSeries Access has been superseded by IBM_i_Access_Client_Solutions

Current name: IBM i Access, product 5761-XW1, 5770-XW1

iSeries Access is the Windows based 5250 emulator available from IBM, formerly known as Client Access.

In addition to 5250 emulation, iSeries access provides:

  • iSeries Navigator -- Graphical user interface to manage the system.
  • ODBC Driver -- Database access for MS Windows systems
  • Data transfer between PC and System i
  • Uses i/OS NetServer to work with IFS files
  • Windows Excel file transfer add-in

iSeries Access is also available for Linux, though missing some of the more powerful features found in the Windows version.

iSeries Access for Web gives browser based access to 5250 sessions, file transfer, job, message and spool management and more. Requires a java application server on the iSeries, which can be WebSphere or TomCat.

IBM i Access Client Solutions is a Java application that runs on the client PC.

Excel add-in

System i Access offers an Excel add-in that makes it simpler to transfer a spreadsheet to or from the System i.

To install that add-in:

  • Close Excel
  • Open System i Navigator (iSeries Navigator)
  • Click on a System i Connection
  • At the bottom, right pane, select Install Additional Components
    • Fill in the server
    • Sign in
    • Under Data Access, Data Transfer, select the Excel add-in
    • After installation is complete, close System i Navigator (save the memory!)
  • Open Excel
    • Tools, Add-ins, Browse
    • Program Files, IBM, Client Access, Shared, cwbtfxla.xll
    • OK to install

To transfer from i to PC,

  • Data, Transfer data from iSeries (a new icon is on the tool bar, too)
  • Choose the file you want and Next
  • There are several options that can be changed here:
    • SQL to select/omit records
    • Date/time formatting
    • 65535 (binary) conversion

External links

Categories

This article is a stub. You can help by editing it.