Release Notes

File-AID/EX 16.03

August 23, 2017

Obtaining the Latest Release Notes

What’s New

File-AID/EX Maintenance Support

Software and Hardware Requirements

Technical Notes

Known Issues

Product Documentation

Support Resources

Obtaining the Latest Release Notes

These Release Notes may have been revised. For the latest version, go to FrontLine , Compuware's customer support Web site. The first time you access FrontLine, you must register and obtain a password. After logging onto FrontLine, select your product from the product list. On the product page, click the Documentation link below the product name. The latest Release Notes document is listed with the other documentation.


What’s New
June 28, 2017
File-AID/EX in Topaz Workbench

Additional File-AID/EX functionality for Related Loader is now available within Topaz Workbench; File-AID/EX 16.03.09 is required for this functionality.

Topaz Workbench Related Loader Editor

Topaz Workbench Related Loader Editor is included in the File-AID/EX perspective. The editor now allows users to do the following:

  Change the target table name.

  Specify execution time credentials.

  View source table metadata.

  Map source columns to target columns.

  View and edit DDL used to create tables.

  Specify Load Utility options for DB2 and Oracle.

Export and Import Related Loader Specifications

Most Related Loader specifications created in standalone File-AID/EX can now be opened in the new Topaz Workbench Related Loader Editor. When importing a specification created in standalone File-AID/EX that has features that are not yet supported in Topaz Workbench, a warning message appears identifying the unsupported features. Saving the specification for use in Topaz Workbench will drop the unsupported features.

The following Related Loader features are unsupported:

  File encryption and decryption

  Embedded Privacy Rules

  Lookups

  Expressions

Coexistence of Standalone File-AID/EX and Topaz Workbench

The following information applies to the coexistence of standalone File-AID/EX and Topaz Workbench:

  Related Extract and Related Loader specifications created or edited in Topaz Workbench cannot be edited in standalone File-AID/EX.

  Within the File-AID Explorer view, the icon displayed for each specification differentiates specifications created in Topaz Workbench from those created in standalone File-AID/EX.

  When a specification is saved, it is saved in the new format within the existing File-AID/EX repository structure. Warning messages requiring user confirmation prevent accidentally overwriting a specification created by standalone File-AID/EX with a new Topaz Workbench specification.

April 3, 2017
File-AID/EX in Topaz Workbench

Selected File-AID/EX functionality for Related Loader is now available within Topaz Workbench; File-AID/EX 16.03.08 is required for this functionality.

Topaz Workbench Related Loader Editor

Topaz Workbench Related Loader editor is now included in the File-AID/EX perspective. This editor allows users to do the following:

  Create a new Related Loader specification based on an extract specification stored in the File-AID/EX repository, the File-AID/EX extracted data file or an extract file produced by File-AID/RDX.

  Select the host and database where the data is to be loaded.

  View list of tables and choose which will be loaded.

  Change the schema for selected tables or for all tables.

  Specify SQL Insert options.

  Automatically create tables in the target environment.

  Execute the specification to load data into the target environment.

Coexistence of Standalone File-AID/EX and Topaz Workbench

The following information applies to the coexistence of standalone File-AID/EX and Topaz Workbench:

  Related Extract and Related Loader specifications created or edited in Topaz Workbench cannot be edited in standalone File-AID/EX.

  Within the File-AID Explorer tree, the icon displayed for each specification differentiates the Related Extract and Related Loader specifications from those created in standalone File-AID/EX.

  Editing Related Loader specifications created in standalone File-AID/EX will launch the File-AID/EX Wizard; they cannot be opened by the Topaz Workbench Related Loader.

  When the specification is saved, it is saved in the new format within the existing File-AID/EX repository structure. Warning messages requiring user confirmation prevent accidentally overwriting a specification created by standalone File-AID/EX with a new Topaz Workbench specification.

January 4, 2017
File-AID/EX in Topaz Workbench

Selected File-AID/EX functionality is now available within Topaz Workbench; File-AID/EX 16.03.07 is required for this functionality. The File-AID/EX perspective within Topaz Workbench includes the following:

  File-AID Explorer to navigate the File-AID/EX repository content and request actions for specifications

  Selection Criteria editor to create selection criteria for use with Related Extract

  Related Extract editor to create and edit Related Extract specifications. This editor allows users to do the following:

-- Select a driving table and discover relationships based on the selected relationship type.

-- View objects and relationships within the extract.

-- Adjust the extract results by excluding objects and/or relationships and setting navigation options.

-- Visualize the set of objects in the extract.

-- Specify the Data Privacy repository and project for applying Dynamic Privacy Rules.

-- Define input and output keys.

-- Set extract options.

  The ability to execute specifications and view execution logs

  The ability to execute Related Extract specifications without saving them to the repository

  The ability to edit specifications for ConverterPro, ComparePro, and Related Loader from Topaz Workbench, which launches the existing standalone File-AID/EX wizard for each feature

Note: The following information applies to the coexistence of standalone File-AID/EX and Topaz Workbench:

-- Related Extract specifications edited in Topaz Workbench default to using the new Related Extract editor. Once a Related Extract specification is saved from Topaz Workbench Related Extract editor, it can no longer be edited in standalone File-AID/EX.

-- Within the File-AID Explorer tree, the icon displayed for each specification differentiates the standalone File-AID/EX Related Extract specifications from the Topaz Workbench Related Extract specifications.

-- When a Related Extract specification created in standalone File-AID/EX is opened, it is automatically transformed to the format used by Topaz Workbench Related Extract. When the specification is saved, it is saved in the new format within the existing File-AID/EX repository structure. Warning messages requiring user confirmation prevent accidentally overwriting a specification created by standalone File-AID/EX with a new Topaz Workbench specification.

-- The ability to define embedded Data Privacy rules, apply file encryption, filter on schema, and set a limit for dependent records to fetch are not yet supported in the Topaz Workbench Related Extract editor. When an existing specification that uses an unsupported feature is opened within Topaz Workbench Related Extract a warning message is displayed and the user has a choice to open in standalone File-AID/EX or drop the unsupported features and open in Topaz Workbench.

-- There is no mass conversion of existing Related Extract specifications; specifications are transformed to the new Topaz Workbench format when they are edited from Topaz Workbench Related Extract.

October 3, 2016
Related Loader Requires Extract Data File

Related Loader does not support the repository extract option for Related Extract specifications created in Topaz Workbench. Therefore, a Related Loader specification created in standalone File-AID/EX that uses a Related Extract specification created in Topaz Workbench must use an extract data file.

August 16, 2016
Support for IBM Authentication Methods

To provide a higher level of authentication assurance for IBM z/OS applications, File-AID/EX (with File-AID Common Components 16.03 PTF VJ16096) now supports the use of IBM Password Phrase Authentication for z/OS. File-AID/EX does not support IBM Multi-Factor Authentication for z/OS.

April 15, 2016
Specification Generation Utility Improvements

The utility to generate Converter/Pro specifications has been enhanced to include generation of the database to database specification. When the utility is executed, four ConverterPro specifications will be generated: database to delimited, delimited to delimited, delimited to database and now database to database. These specifications are generated for each table based on the content of the properties file specified.

In addition, a new option has been added to control whether leading and trailing spaces are stripped for the delimited files.

January 1, 2016
Data Type Enhancement

Improved processing for user defined data types based on underlying data type.

Improved processing for CLOB and XML columns.

Oracle Service Name Enhancement

Connecting to an Oracle database using Service Name is now supported.

Specification Generation Utility Improvements

Two new options were added to the Specification Generation Utility. Source and target passwords are now specified on the command line at execution time. The new FILE_HEADER parameter in the properties file specifies whether the input file has a header record.


File-AID/EX Maintenance Support

Compuware is committed to actively supporting its current product releases. Up-to-date product release support and retirement information is available on FrontLine's FrontLine Support - Product Currency Tables page.


Software and Hardware Requirements

For further information about IBM System z software and hardware compatibility--specifically regarding IBM's z/OS Recommended Service Upgrade, IBM's Extended Address Volumes, IBM DB2 for z/OS, and z/OS product compatibility--refer to https://frontline.compuware.com/charts/hardware.aspx .

File-AID/EX Enterprise Edition (File-AID/EX Executive)
Hardware Platforms

  Mainframe Systems:

-- z800, z890, z900, z990 mainframe systems

-- z13

-- zEC12, zBC12

-- z196, z114

-- z10-EC/BC

-- z9-EC/BC

-- z900, z990

-- z800, z890

Operating Systems

  IBM z/OS V1.13, 2.1, 2.2, 2.3

  IBM ISPF for the supported z/OS releases

File-AID/EX and File-AID/EX Execution Server
Hardware Platforms

  Mainframe Systems:

-- zEC12, zBC12

-- z196, z114

-- z10-EC/BC

-- z9-EC/BC

-- z900, z990

-- z800, z890

  Distributed Systems:

-- AIX Power

-- HP-UX Itanium

-- Linux x86, x64

-- Solaris Sparc

-- Windows x86, x64

Hardware Requirements

  Hardware:

-- Linux x86, x64

-- RISC workstation

-- RS/6000 workstation

-- Sun SPARC workstation

-- Windows x86, x64

  Processor: 1 GHz processor minimum; 3 GHz recommended on Linux; 1 GHz minimum; 3 GHz recommended on Windows

  Hard Disk: 700 MB minimum; 1 GB recommended. Additional disk space may be required when extracting large sets of data.

  RAM: 1 GB minimum; 2 GB recommended; 4 GB recommended

Operating Systems

  HP-UX 11iv2 (11.23), 11iv3 (11.31) on Itanium-based machines.

  IBM AIX Enterprise Edition V6.1.0, 7.1.0

  Microsoft Windows 7, 8.1 (Update KB 2919355), 10

  Microsoft Windows Server 2008, 2012

  Red Hat Enterprise Linux 5.x, 6.x, 7.2, 7.3

  Solaris 9, 10 (Sparc processor-based versions only)

Major Subsystems

  IBM DB2 for z/OS: Toleration support for V10.1, 11.1, 12.1

  IBM IMS Transaction and Database Servers V12.1, 13.1 (PSBs generated prior to IMS 11 only)

Languages

  Oracle Java SE 7, 8 (Java 7 is installed automatically on Windows systems during File-AID/EX installation but must be installed manually on UNIX and Linux. Toleration support for Java 8 on UNIX and Linux.)

Corequisites

  Compuware Products and Components:

-- File-AID/RDX 10.2, 16.3, 17.2. File-AID/EX can load from an extract file created by File-AID/RDX.

-- File-AID Data Privacy: Refer to the File-AID Data Privacy Release Notes.

-- File-AID/EX 16.03.09 is required for Topaz Workbench 18.02.01.

Distributed

  IBM DB2 for Linux, UNIX, and Windows (LUW): V9.5, 9.7, 10.1, 10.5. DB2 LUW requires IBM DB2 Connect Unlimited Edition for System z for Windows or the type-4 JDBC drivers.

  Microsoft Internet Explorer 6, 7, 8, 9, 10, 11 for the supported Windows releases (for using the installation media and viewing online help)

ISV Software

  Microsoft Access 2003, 2007, 2010

  Microsoft Excel 2003, 2007, 2010

  Microsoft .NET Framework 2.0, 3.5 SP1, 4, 4.5, 4.5.1

  Microsoft SQL Server (other editions may be acceptable but have not been tested):

-- Microsoft SQL Server 2005 Standard Edition

-- Microsoft SQL Server 2008 Standard Edition

-- Microsoft SQL Server 2008 R2 Standard Edition

-- Microsoft SQL Server 2012 Standard Edition

-- Microsoft SQL Server 2014 Standard Edition

-- Microsoft SQL Server 2016 Standard Edition

  Oracle JDBC 10.1.0, 10.2.0, 11.1.0, 11.2.0, 12.1.0 on Windows and UNIX

  Oracle Client 10g, 11g, 12c on Windows. The Oracle Database Client - Administrator level is supported. Instant Client is not supported.

  Oracle SQL Loader

  SAP Adaptive Server Enterprise 15.0.3, 15.5, 15.7 on File-AID/EX-supported Windows, HP-UX, AIX, and Solaris operating systems

Supported File Types by File-AID/EX Component

The table below indicates which file types are supported by the various File-AID/EX components. File types are supported for the supported versions of third-party products listed in the Software and Hardware Requirements section.

File Type

ConverterPro

ComparePro

Related Extract

Related Loader

IBM AS/400

Yes

 

 

 

IBM DB2 for z/OS

Yes

Yes

 

 

IBM DB2 Load Utility

 

 

 

Yes

IBM DB2 for Linux, UNIX, and Windows

Yes

Yes

Yes

Yes

File-AID/RDX

 

 

 

Yes

IBM IMS Transaction and Database Servers

Yes (source only)

 

 

 

Microsoft Access

Yes

Yes

 

 

Microsoft Excel

Yes

Yes

 

 

Microsoft SQL Server

Yes

Yes

Yes

Yes

MVS

-- VSAM ESDS

Yes

 

 

 

-- VSAM KSDS

Yes

 

 

 

-- QSAM

Yes

 

 

 

Oracle JDBC

Yes

Yes

Yes

Yes

Oracle SQL Loader

 

 

 

Yes

Sybase Adaptive Server Enterprise

Yes

Yes

Yes

Yes

Teradata

-- ConverterPro support for Teradata requires that the specification source and target be different. Use null source if necessary.

Yes

 

 

 

Windows/Unix Files

-- Delimited

Yes

Yes

 

 

-- Fixed

Yes

Yes

 

 

-- Text

 

Yes

 

 

XML

Yes

Yes

 

 

Discontinued Support

  File-AID/EX 16.03 is the last release to support the following:

-- z/OS 1.13

-- Solaris 9

-- IBM IMS Transaction and Database Servers V12.1

-- Oracle Java SE 7

-- IBM DB2 for LUW V9.5

-- Microsoft Internet Explorer 6, 7, 8, 9, 10

-- Microsoft Access 2003, 2007

-- Microsoft Excel 2003, 2007

-- Microsoft SQL Server 2005 Standard Edition

-- Oracle Client 10g

-- File-AID/EX API using C++ and Visual Basic


Technical Notes
Viewing Online Help in Google Chrome

A Google Chrome security update prohibits viewing of WebHelp when the help is deployed locally from a file server (as opposed to a Web server). Attempting to view locally deployed help displays a blank help window. Compuware suggests that online help be viewed using Internet Explorer. Alternatively, Chrome's security feature can be turned off by launching Chrome with the command line option --allow-file-access-from-files. This method should only be used when opening local WebHelp that you trust.

File-AID Rules Engine Compatibility

The version of the File-AID Rules Engine installed with File-AID/EX must match the version of File-AID Services and Topaz Workbench.

Setting Preferences and Advanced Properties

When setting preferences and advanced properties (particularly those affecting encoding) in ConverterPro, these properties are not also modified in ComparePro. The opposite is also true, if preferences and advanced properties settings are changed in ComparePro, it does not modify settings in ConverterPro.

Open Source

This product contains the use of open source software packages. Any open source software that was modified as part of its use within this tool suite has been included on the product media in a folder named 'Open Source'. Within those files, any modifications to the original code structure have been documented with comments indicating they are changes made by Compuware and not the original author. In addition, the license files for those corresponding open source packages are also included in a folder named 'Licenses'.


Known Issues
New Related Extract Engine and Concurrent Extract Requests

Release 5.2 introduced a new Related Extract engine that uses DBMS for faster extraction. If this new engine is being used and multiple File-AID/EX execution servers are concurrently executing Related Extract requests that target tables in the same database and use the same schema for storing temporary tables, conflicts could result in failed execution, and--in very rare cases--in extraction of incorrect or inconsistent data. If this situation occurs, clear the Use DBMS for faster extraction check box in the Advanced Settings tab of the Execution Options dialog box to use the original Related Extract engine.

Windows User Authority Installation Requirements

Due to current registry update requirements, an installer must have Administrator authority or be a member of the Administrator group. Any other authority level will cause the installation to fail.

ComparePro

There is a known limitation where ComparePro jobs being executed by a Remote Execution Server will not function if using the standard default Derby repository. Compuware suggests creating a separate repository in one of the other supported database types in this case.


Product Documentation

The installation package includes the following File-AID/EX documentation in electronic format:

  Release Notes in HTML format

  The product manuals and licensing guide in PDF format

  The Adobe Master Index file (.PDX) for searching PDF files

PDF and PDX Files

View and print the PDF files with Adobe Reader. If necessary, you can download a free copy of the reader from Adobe's Web site, http://www.adobe.com .

With a few minor exceptions, the provided PDF files comply with the requirements of section 508 of the Rehabilitation Act of 1973.

The PDX Master Index file allows you to quickly search all of the PDF files in your documentation set at one time. Click the File-AID/EX PDF Index File link on your documentation list to launch Adobe Reader and load the file.

In some environments, opening the .pdx file from the browser page link results in a blank browser page. Instead of using the link, copy the files to your local machine or shared drive, start Adobe Reader, and open the cwaf_idx.pdx file. To view the files from your local or shared drive:

Copy all of the documentation files to the same folder on your local machine or shared drive.

1. Navigate to the folder where the .pdx file is located and double-click it. It will open Adobe Reader.

2. Type the word or phrase you want to search for in the search field.

3. Ensure that the selection "In the index named cwaf_idx.pdx" is selected.

4. You can check the boxes for additional criteria if desired. Then click Search .

5. Each book that contains the search criteria appears in the Results list. Expand the book to see each instance of the located search criteria for that book.

6. Click one of the expanded instances of the search results and that page will open in the appropriate book.

7. See Adobe Reader's Help for more information.

Provide your user groups with access to the documentation by copying all of the files and folders to a shared location on your network. Users can bookmark the bookshelf.htm file for easy access.


Support Resources
Compuware FrontLine Support Web Site

Access online customer support for Compuware products via our FrontLine support web site. View or download documentation, frequently asked questions, and product fixes, or directly e-mail Compuware with questions or comments. To access FrontLine, you must first register and obtain a password at https://go.compuware.com .

Online Documentation

Documentation for this product is provided on CD-ROM in the following electronic formats:

  View PDF files with the free Adobe Acrobat Reader, available at http://www.adobe.com .

  View HTML files with any standard Web browser.

World Wide Web

Compuware's site on the World Wide Web provides information about Compuware and its products. The address is https://www.compuware.com .

Contacting Compuware Customer Support

At Compuware, we strive to make our products and documentation the best in the industry. Feedback from our customers helps us to maintain our quality standards.

Questions about any File-AID/EX product or comments on this document should be directed to:

Compuware Customer Support

Compuware Corporation

One Campus Martius

Detroit, MI 48226-5099

1-800-538-7822

Outside the USA and Canada, please contact your local Compuware office or agent.

If problems occur, consult your manual or the File-AID/EX customer support representative at your site.