Release notes

v8.1

Mapping Manager

  • Performance Improvements to Mapping Grid to improve the Mapping load times by 70%
  • The Test Specification Tab has been moved next to the Graphical Designer tab to utilize greater UI screen space.
  • The Mapping Statistics section has been moved from its previous location (beneath the mapping grid) to a new pop up screen to improve the mapping grid load performance.
  • Transformation Library: Pseudocode support for various ETL Tools
    • The Mapping Manager’s transformation library has now been extended to document ETL tool specific pseudocode. Using this capability, different projects can use the transformation library and pseudocode specific to a certain ETL tool without the need to use the entire library. ETL tool can be defined specific to a project so only those transformations specific to the ETL tool can be extended to the project.
    • The existing “Pseudocode” column has been renamed to “Informatica Pseudocode” to document the pseudocode specific to Informatica. Pseudocode columns specific to other ETLs can be added dynamically in the application
    • Ability to view the Release Information specific to a Mapping

Metadata Manager

  • Ability to version a metadata environment and use the active version for the mapping management process.
  • Ability to compare two environments for metadata structural changes (Table and Column changes)
  • Ability to export/import an entire environment via xml
  • Addition of “NullableFlag”, “Primary Key Flag” and “SDI (Sensitive Data Indicator) Flag” fields in the Table “Column Listing” overview grid.
  • New Metadata scanner to connect to Big Data Hortonworks, Cloudera etc. using the beeline command option.

Codeset Manager

  • Addition of 10 User Defined Fields to enrich Code value information
  • Addition of “Start Date” and “End Date” fields to Code Values to maintain active/inactive states
  • Ability to delete multiple Codesets
  • Extended view of Code Crosswalk to support the addition of the 10 new user defined fields

Reference Data Manager

  • Ability to modify the database URL dynamically within the Reference table database import screen
  • Ability to associate Reference Tables to the Mapping Grid via a drag/drop method
  • Ability to view the associated Reference Table information from the mapping grid
  • Display of published Reference Tables within the metadata browser (right hand section of mapping screen)

Requirements Manager

  • Ability to associate a Specification Document to a mapping at the mapping row level and mapping level
  • Ability to associate requirement artifacts to the mapping as a whole

Test Manager

  • Syncing of additional User Defined Fields from HP-ALM into Test Manager

**Important Note**

Data Quality Assessment Manager

Starting with version 8.1, the Data Quality Assessment Manager will be offered as a separate install from the Unified Platform! Though the products remain highly complementary, they can now be purchased separately. This offers our client base a broader choice and freedom to pursue these innovative industry leading products separately, or together, based on their specific needs.

v8.0
  • NEW** Business Glossary ModuleThe latest addition to the AnalytiX DS Unified Platform helps enterprises maintain an enterprise glossary of terms and definitions and helps enable link business terms and technical metadata to help bridge the gap between the IT and Business teams.
    • Ability to define business terms and definitions
    • Ability to associate business terms to other terms and technical metadata
    • Data Stewardship capabilities
    • Generate a business term dependency mind map to view enterprise usage and associated impacts
    • Ability to attach any type of supporting documentation to business terms to enrich definitions e.g. video, audio, images, docs etc.
  • NEW** Reporting Manager Module
    • This new offering helps SQL Savvy Users access the Unified Platform’s backend database repository to create custom reports, charts and dashboards
    • Ability to configure user specific dashboards
  • Renaming of the “System Manager” metadata module to Metadata Manager as part of the continuously growing Unified platform and governance offering. The Metadata Manager provides greater and enhanced metadata scanning capabilities and also aligns with our vision of having a metadata driven approach to enterprise data mapping and automation
    Enhancements

    • Ability to view Data Quality Assessment results for Column Attributes from the Metadata Manager module
    • Generate an Entity Relationship Model Diagram for a selected Environment
    • Ability to generate a DDL for a selected Environment (currently supported for SQL Server and Oracle Databases only)
    • Ability to compare environments and generate a change comparison report
  • Requirements Manager Enhancements
    • Ability to version Requirements Specification Documents
    • Ability to Copy Requirements Specification Documents
    • Compare Requirements Specification Docs and highlight changes
    • Email and Workflow notifications
  • Graphical Designer enhancements
    • Ability to Auto Map source/target columns
    • Ability to sort columns within a table based on natural, ascending and descending alphabetical order
    • Display of Additional metadata attributes like column length, data type, precision and scale along with the column name in the graphical designer
  • CATfX Enhancements
    • Support for R Language: Combine the power of statistical computing with AMM Engine’s API to create powerful Code Automation Templates
    • Introduction of Multiple Tabs in the CAT form designer to support logical entry of data: Logically group and design visually pleasing CAT dialogs with Tabs support
    • Multiple Dialogs: Added ability to create more than one dialog for a CAT
    • Dialog Workflow: Create workflow with multiple dialogs along with decision making scripts to define the flow of extrinsic execution combined with intrinsic flow of stock dialogs
  • Release Manager Enhancements:
    • Ability to version published mapping and create a new production mapping through the process of promotion
    • Other minor bug fixes
  • Data Quality Assessment Manager
    • Ability to support XML, flat file, excel, JSON as valid sources for data quality assessment
    • Other functional enhancements
    • Other minor bug fixes
  • Performance Improvements to Table and Column Level lineage that reduces loading times to a few seconds (up to 90+% improvement for Table Lineage and 30%+ improvement for Column Lineage)
  • Ability to configure the layout of the Mapping tabs as part of admin/user profile settings
  • Performance improvements to the End to End Lineage feature – loading time for huge data improved by 60+ %.
v7.1
  • NEW : Requirements Manager module
  • Enterprise & Project Level Mapping Grid Profiles & Customization
  • Graphical Creation of Source to Target Mappings
  • Delete Tables from Metadata Repository
  • Addition of 40 User Defined Fields to the Mapping Grid
  • Version Mapping during Excel Import process
  • Preserving renamed User Defined Field Header Names during Excel Export of a Mapping
  • Preserving renamed User Defined Field Header Names during Excel Export of a Mapping
  • Simple Query builder to generate reports out of the Mapping Manager repository
  • Global Search Feature –Exact Keyword Search
  • Ability to export Reports to HTML file format
  • Data Quality Assessment Manager module enhancements
  • CATfX Module Enhancements
  • Ability to Export Codesetsattached to a source to target mapping row as part of the excel export process
  • Ability to assign Codesetsto Columns/Attributes as valid values
  • Two way Integration with HP-ALM using REST APIs providing cross platform integrationWHAT’s
v7.0
  • Enhanced Module Launchpad
  • Collaboration Center
  • End to End Lineage View
  • Virtual Target Preview for a Source-To-Target Mapping
  • My Recent Mappings
  • Simplified Business View of Mapping
  • Enhanced Lineage Analyzer with the ability to group Source Columns
  • Enhanced Lineage Analyzer with Dual Lineage view
  • Create Integration Projects in Mapping Manager (vs Resource Manager)
  • Metadata Comparison Report
  • Select any two environments and compare table and column changes.
  • Metadata Browser Configuration for ease of access
  • Desktop View of AMM (*Beta Launch*)
  • Shortcut link to a row within a Mapping Specification
  • Rich Text Fields in the Mapping Grid
  • Enhanced Auto Map process
  • Assign Data Stewards to Metadata
  • Documentation Support for System Environments
  • Test Manager Enhancements
  • CATfX Enhancements
v6.2
  • New Module : Data Quality Module.
  • New Module : Test Manager Module
  • Drill Down on Mapping Statistics to view detailed information
  • Shortcut Links to Project and Subject Areas to improve collaboration
  • Ability to store links to Documents (e.g. SharePoint links)
  • Wizard Scanning Process in System Manager to make metadata imports faster and easier
  • Metadata scanning support for Oracle RAC Database
  • New Metadata scanner for XMI models
  • Mass Update of Mapping Status
  • Validation feature in Mapping Grid that includes Truncation Impacts, Not Mapped Sources and Not Mapped Targets
  • New Dashboard report containing summary of Source/Target fields not mapped within a project
  • Enhanced Resource Activity report
  • Enhanced Mapping Specification Report
  • Auto Assignment of User creating the mapping as Mapping Designer
v6.1
  • Extended Auto Mapping Capabilities
  • Integrated Dashboards
  • New Mapping and Enterprise Level Statistics
  • New Metadata Scanner for CSV/Flat Files
  • Graphical Overview of Mappings
  • Enhanced Lineage Analyzer
  • Web Services for Automation
  • Mapping Shortcuts
  • Flat UI with new Terrace and Web Themes
  • Run Lineage and Impact Analysis directly from the Mapping Grid
  • Search Capabilities in the Metadata Repository
  • Extended Impact Analysis with Drill Down Capabilities
  • Enhanced Business Rule window: Select Pseudocode for Transformation (vs Business Rule)
  • Reorder Subject Areas
  • Tag Attributes (Columns) with Sensitive Data Indicator (SDI) Classification
  • New Metadata Scanner for JSON Schemas/Files
  • Generate JSON Schema out of scanned metadata
  • File Manager in CATfX to provide a repository of multiple files
  • CATfX API is now available to develop code to support your integration requirements
  • New CAT Components
  • Versioning and Auto-Save of CAT Templates
  • Enhanced ETL support for Microsoft SSIS Reverse and Forward Engineering
  • New Code Automation Templates
  • Ability to Move Multiple Mappings between Projects/Subject areas
  • Integrated Search feature on metadata browser
v6.0
  • Auto-Mapping of Source to Target Columns
  • Extended Impact Analysis Capabilities
  • Table Level Lineage
  • Big Data System Scanners
  • Test Manager Module -Test Management Capabilities
  • New Look Release Manager
  • New GUI Form Editor for CAT Templates
  • Implementation of Extended Properties/Key-Value pairs at various levels
  • Multi Copy and Delete of Mappings
v5.2
  • Wizard Functionality with Schema Pre-selection to scan metadata
  • Scanner to access metadata from SAP systems
  • CATfX enhancements
    • Integrated Run with Optional Dialogs
    • Groovy support
    • Changed Editor to Code Mirror to support enhanced features
  • Mapping Manager has been upgraded to the DHTMLx 4.0 platform Benefits:
    • Increased Performance Management using latest dhtmlx version
    • Faster Web Application with increased loading times across the application
    • Faster loading times for Project/Mapping Tree and Metadata Trees
v5.1
  • Certification on Java 7 and Tomcat 7 versions.
  • CATfX Module
    • Support for Groovy programming language
    • Ability to create custom form objects to handle dynamic query inputs
    • Sorting Order for CAT templates
    • User Friendly CAT Editor
    • Error Highlighting and code folding in new CAT editor
    • Text wrapping and auto format features
  • New Look AMM Reports
    • Out of the box reports in AMM have been enhanced with a new look GUI colour scheme.
v5.0
  • NEW : Business Oriented view of System Manager Module
    • Manage Data Dictionaries
    • Instant access to Lineage and Impact Analysis
    • Global Search accessibility to entire metadata repository
  • NEW MODULE : Reference Data Manager Module
    • Standardize Reference Data across Enterprise
    • Streamline maintenance of Reference Data Sets
    • Improve Data Quality Confidence
    • User friendly Grid capabilities to maintain custom Reference data
  • NEW MODULE : Code Automation Templates Framework (CATfX)
    • Standardize Code Gen Templates across Enterprise based on methodologies and best practices
    • Streamline Code Generation process
    • Reuse and leverage enterprise Code Gen Templates
    • User friendly GUI for Code Generation. Instant preview of output formats
  • Customizable User GUI Themes
  • Enhanced Lineage Analysis Capabilities
  • New Merge feature to Branch and Merge mapping specifications
  • Extended ETL Integration to support Source/Targets as Flat File Objects in Informatica.
  • Addition of 15 User Defined fields at Subject Area Level
  • Addition of 40 User Defined fields at Mapping Level
  • Extension of Data Lineage and Impact Analysis Reports to Appended Columns
  • Addition of “Mapping State” and “Mapping Sub-State” at the Mapping Level
  • Folder structure strategy for Code Mappings
  • Import of Multiple Legacy Code Mappings
  • User restriction across Categories
  • Detailed permissions list for user access to module features
  • Versioning and Publishing of Codesets and Code Mappings
  • Copy and Pasting of Codesets from one Category to another
  • Global Search functionality across Codeset Manager
  • Compare-To utility for Codesets and Code Mappings to highlight differences
  • Folder structure strategy for Code Mappings
  • Import of Multiple Legacy Code Mappings
  • User restriction across Categories
  • Detailed permissions list for user access to module features
v4.5
  • Global Search Functionality across Mapping Manage
  • Mass update of source/target data across Mapping Specification
  • Quick Publish of Mapping Specifications
  • Multi Browser Compatibility
  • Option to change user password has been added to user settings

Release Manager:

  • Integration of Release Manager with Mapping Manager
  • Integration of Release Manager with Codeset Manager
  • Facilitate Migration of Release objects between Releases
v4.4

Enhancements:

  • Customization of User Roles and Privileges
  • Contribute to AMM by requesting new features
  • Shortcut to the AnalytiX Forum from AMM and post new queries
  • Customizable Export of Mapping Specifications to Excel
  • Auto Syncing the Mapping Specification Metadata to the Metadata repository
  • Extension of Informatica ETL export capabilities
  • Export mapping specifications into an Analytix proprietary XML format and import mappings from the XML format
  • Multiple Upload of Legacy Excel Mappings
  • Capture Change Description & Version Label while Base-lining mapping specifications
  • GUI Themes and Progress Indicators
  • Project Specific Transformations (Business Rules)
  • Extension of the Change Log feature
  • Customization of Mapping Name display
  • Customizable User defined mapping specification tabs
  • Preview option for XSD metadata
  • Enhanced the ERwin metadata scanning capability
  • Login Account Details Retrieval method
  • Renaming of Subject Areas
  • Configuration of Email Settings
  • Enhanced capabilities of the Lineage Analyzer
  • Filtering Capabilities in GUI Grids
  • New GUI interface to update metadata attributes at the system level
  • GUI Interface to update Language & Properties
  • AMM architecture has been revamped to enhance the application performance making it more robust and dynamic.
  • AMM is now certified on Websphere Application Server (version 7.x or higher)
  • Codeset Manager – Auto Mapping of Source to Target Codes

Known Issues Addressed: 7

Mapping Manager:

  • Unable to scan metadata from MySQL database.
  • Views scanned from Teradata database not expanding in the metadata browser
  • Issue when scanning metadata from an Oracle database when selecting Synonymns
  • Dynamic Excel Upload process fails when trying to upload a mapping specification from Excel
v4.3

Enhancements:

Mapping Manager Solution:

  • Application Plug-in Framework – Allows custom built application and third party applications to be integrated directly with Mapping Manager user interface and integrate with the metadata and data mapping repository. Available out of the box plug-ins will include Built In Wiki Pages, Automated Testing Framework and Discovery BI Module to access and analyze the repository metadata
  • XSD metadata scanning support
  • ER Studio/CWM format metadata scanning support
  • Vertica Database metadata scanning support
  • Datastage Forward and Reverse Engineering capabilities
  • Reverse Data Lineage Analyzer
  • Enhancement to Excel Metadata upload with option to update/delete existing tables
  • Mapping Grid – Column width specification according to user customization
  • Full screen feature for Mapping Spec grid
  • Mapping Frames customization per user preference
  • Mapping Comparison Report – New Report format + Excel export
  • 5 User Defined fields (flex fields) added to table level metadata attributes (Business Properties)
  • Advanced User settings to customize display of user defined fields (flex fields) in table/column business properties
  • GAP analysis reports (against Project or Mappings) at the metadata table and column level

Code Set Manager Add-On Module:

  • Create Code Mapping Using Drag/Drop feature
  • Upload Existing Code Mapping Specs from Excel
  • Ability to Import multiple Code Sets at a time using Excel
  • Organization of Code Sets into multi level Categories
  • Enhanced DB scan feature to support import of existing codes from Database
  • Code mapping spec grid maximize/restore
  • Restore and Purge for Codes and Code Mappings (Available only for Administrator and Power User)
  • Code Mapping Spec grid – Column Ordering and Column Visibility

Known Issues Addressed:

Mapping Manager Solution:

  • Forward Data Lineage Analyzer support for Oracle DB
  • Mapping Spec Report generated at the Project level consolidates all data into a single page and not multiple pages
  • Long Source/Target column names getting truncated in the Mapping Specification Report
  • Map Spec Excel Upload – Length conversion from numeric to string (e.g. 1 to 1.0) upon import
  • Implemented pagination fix during auto edit mode of Mapping Spec grid
  • Connection related issues with Oracle as MM DB in a multi-user environment

Codeset Manager:

  • Performance Issue related to uploading large codesets
  • Code Set Import via excel – Length conversion from numeric to string (e.g. 1 to 1.00) upon import
  • Removed limitation to create limited Categories, Code Sets & Code Mappings (100 in number)
v4.2

Mapping Manager:

  • New GUI (with a dialog) for easy selection and visualization of Pseudo code / Intended Use for Business Rules & Extended Business Rules
  • Integrated CC list for sending email alert along with the assigned users
  • Ability to add custom text to email in assignment changes.
  • Auto-Edit mode for mappings locked by the same user who is logged in
  • Extended Impact Analysis Report to include usage in Business Rule / Trans Lookup Condition / Lookup Column / Source Extract SQL. Along with the facility to export in multiple formats, viz., PDF, RTF, Excel, Word
  • Mapping Specification Report extended to include Source Summary & Target Summary
  • Dynamic expression support in Mapping Business Rule while exporting to Informatica. E.g.: CONCAT (%1, %2) with FNAME & LNAME columns will expand to CONCAT(FNAME, LNAME)
  • Export of Mappings in Projects/Subject Areas – New GUI Dialog allows user to export mapping specifications to Excel at the Project or Subject Area level with the ability to include active/passive mappings. User can export Mapping Specifications as Individual Excel Files, multiple sheets within a single excel file or consolidate all mappings into one single excel file
  • Mapping Specification Report – New GUI Dialog allows user to run the Mapping Specification Report at the Project /Subject Area/Individual Mapping level with the ability to include active/passive mappings. User can export the Mapping Specification report to PDF, Excel, Word and RTF formats.
  • Extended Impact Analysis Advance Search Dialog to include Mapping Filtering with an easy to use tree structure similar to Mapping Tree. Options to either include / exclude usage in Business Rule / Trans Lookup Condition / Lookup Column / Source Extract SQL.
  • Integrated Data Lineage Report: User can now click on any column available in metadata repository and view its forward lineage instantly.

Code Set Manager:

  • The new Code Set Manager will provide support for multiple Source Code Set/Environment combination to multiple Target Code Set/Environments.
  • The new CSM will enable the user to select Source Code Set/Environment and corresponding Target Code Set/Environment at the time of creating a new Mapping.
  • Validate functionality is provided to enable the user to view a report of all the Source codes that are not mapped to TARGET Codes. This functionality is provided at the Mapping Grid level.
  • The Publish functionality is provided at the Code Mapping Level which enables Mapping Manager Metadata browser to show only those Code Mappings that are published.
  • Completely redesigned GUI for Code Set Manager
v4.0
  • Mapping Manager contains a new improved user interface design that enhances the user experience with the tool.
  • Mapping Manager has now been certified on Oracle repository and can be run on both SQL Server and Oracle databases.
  • The product has been certified to run on Linux based environments (Ubuntu and Red Hat).
  • New theme using richer icon sets
  • Reordering of Mapping Specification Grid rows
  • Server Jobs for Datastage restored and enhanced
  • Five new customized, user-defined columns added to the data dictionary (system metadata)
  • Column Definition Comments expanded as 2 new columns to store both Column Definition and Column Comments
  • Logical Column Name added to the Mapping Specification Grid. (Target Logical Column and Source Logical Column)
  • WYSIWYG text editor implemented across Mapping Manager. (i.e. all styles/fonts applied to text in the edit mode are displayed in the view mode in the text area)
v3.1.8
  • Mappings can be renamed
  • Users can reedit the mappings that they have locked without the need of an Administrator to unlock them
v3.1.5
  • Implemented new connection pooling logic to improve tomcat performances.
v3.1.4
  • Lookup Column and Trans Lookup condition implementation to integrate with SSIS
v3.1.3
  • Lookup Column and Trans Lookup condition implementation to integrate with SSIS
  • Implementations:
  • Table & Columns Drag n Drop in Trans Lookup Condition column should generate the sql
  • Adding of new column to grid for holding Lookup Column
  • Attach the dropped columns in dropdown in Lookup Column
  • Once a column is selected in Lookup Column, the generated sql in Trans Lookup Condition should append a WHERE clause on lookup column and source column
  • Generate Lookup Component for each row in Mapping Grid
  • Attach all lookup components (in SSIS) to the source table one after another and ending in Derived Column / Copy Column / Union All / Target
  • Generate metadata xml in Lookup Component in SSIS for the generated sql in Trans Lookup Column in Mapping Grid, with few exceptions, Kind of In Progress
  • If Business Rule is specified along with Lookup Condition, derive the column from lookup rather than direct source column => Source => Lookup => Derived => Union All => MultiCast => Target
  • If No Business Rule but Lookup Condition, then derive the column from lookup rather than direct source column => Source => Lookup => Union All => Multicast => Target
  • Save Mapping Grid with the information entered
  • Support Export & Import from Excel (for Lookup Column)
  • Support Editing of saved mapping with the same kind of behaviour
v3.1.2
  • Informatica XML export – Fixed the error that was occurring when the same column name was being used multiple times in the mapping and was not importing correctly into Informatica
  • Implementation of Datastage Parallel jobs and removal of server jobs
v3.1.1
  • Integrated Source Extract SQL Query with SSIS.
  • SSIS XML export has two options, a. Default XML (initial one) b. With SQL Extract Query
  • If you go with SQL Extract Query, at all times it has to generate single source with the sql extract for that mapping
v3.1
  • Implemented Column reordering functionality.
  • Ability to reset column reordering and visibility
  • Level of Effort tab updated to include Mapping and ETL effort.
v3.0
  • Add grid font, size, backgroundcolor, foregroundcolor to conxtmenu without mapstatuscontext.xml file
  • Connecting Multiple Source Columns to Target Columns Without Transformation, while exporting to Informatica XML
  • Connecting Transformation to Target, basing on Target Column Definition, if it Exists
  • Creating Proper Connectors for above condition
  • Generating Transformation Field from Source Column Info, if Target Columns Doesnot Exist and Transformation Exists
  • Grid beatuification with support for Font, Size, Foreground Color, Background Color
  • License extended to support Subjects Count On Per Project Basis. It will default to 3, for the first version of license, where it doesnot have any value for subjects count
  • List Oracle Synonyms in the MetaData Browser with Synonym Icon / Ordering and Preview Support
  • Oracle Synonym Support while scanning Oracle MetaData
  • Provided proper error messages for errors during the upload file process in Mapping Documents
  • Subject Hierarchy Implementation
  • Synonym Reference is shown in the Table Properties for Oracle Synonyms
  • Updated Project User Details & Project Document Details Reports to show HTML Content in Description
  • SSIS XML (DTSX) Export Implementation for Mappings
v2.5.22
  • Subject Hierarchy changes by Sivag
  • Added 6 User Defined Attributes in metadatamappingspec.jsp and also altered in database
  • Grid beatuification with support for Font, Size, Foreground Color, Background Color
v2.5.21
  • Pervasive Data Preview functionality to preview first 100/1000 records.
v2.5.19
  • Implementation for the Clearing the Source & Target Items in Meta data Mapping Grid.
  • Implementation for getting the actual values instead of null values for DataTypes, when we drag Multiple Columns or Table from Meta Data Tree into Meta Data Mapping Specification
  • Oracle Synonym Support while scanning Oracle MetaData
  • List Oracle Synonyms in the MetaData Browser with Synonym Icon / Ordering and Preview Support
  • Synonym Reference is shown in the Table Properties for Oracle Synonyms
v2.5.18
  • Provided proper error messages for errors during the upload file process in Mapping Documents
  • Connecting Multiple Source Columns to Target Columns Without Transformation, while exporting to Informatica XML
  • Generating Transformation Field from Source Column Info, if Target Columns Does not Exist and Transformation Exists
  • Creating Proper Connectors for above condition
  • Connecting Transformation to Target, basing on Target Column Definition, if it Exists
v2.5.17
  • Updated Jasper Report to version 4.1.1
  • Updated all reports to show & respect HTML entered through CKEditor
  • Added support for English, Spanish, Portugese, German Languages
  • Properties Key integration into Map Compare Report JSP file
v2.5.16
  • Integrated CKEditor (WYSIWYG Editor) at all places for Text Area.
  • Microsoft Access DB (MDB) is supported in the System Manager as a DB to scan
v2.5.14
  • Added support for exporting Mapping to Informatica XML with Multiple Source Columns in a Row (Append Mode)
  • Added support for exporting Mapping to Informatica XML with Multiple Target Columns in a Row (Append Mode)
  • Added support for Pervasive Database Metadata Scanning in System Environments
v2.5.13
  • String literals (Business Rule) are formatted to Valid XML before exporting to Informatica XML
v2.5.12
  • Column Ordering Preference being saved while Importing from Excel and Scanning from Database
  • Column Ordering Preference can be changed dynamically from System Metadata Browser
  • Column Ordering Preference is saved on a User Basis. i.e., their order preference will be available from any system they login.
  • Support for exporting Custom Transformation into Informatica XML
v2.5.10
  • Ability to drag & drop table onto the mapping grid to add all columns in one shot
  • Added feature to show Project User Roles in multi-line in Resource Manager
v2.5.9
  • Updated Evaluation License Date, starts from Aug 22 2011
  • Updated Evaluation License Days to 60 from 30. This renewed license expires on Oct 22 2011
  • Mapping Validation Report, enhanced to export to PDF or RTF directly from the menu option
  • Improved performance on Mapping Validation Report
v2.5.8
  • Updated Evaluation License Date, starts from Jun 29 2011
  • Mapping Validation Report, enhanced to support Project selection and grouping by Mapping
  • Data Grid (thought out) Mapping Manager enhanced to support Inverted Commas (“)
  • Re-wrote the License saving part to store the License in Java Preferences (Repository) instead of File System, as many of our clients are having permission issues to do so.
  • Application will now remember the default selection by the user, in the Upload XML dialog for XML Type
v2.5.7
  • 1. Implemented Mapping Validation Report for a
    • Single Mapping
    • All Mappings for a Project
    • Selecting Different Project & Mapping
v2.4.4
  • Enhanced Versioning.
  • Change Control Documentation Capabilities
  • Extended XML integration with Informatica – Auto-generate an Informatica ETL Job
  • Extended XML Integration with Informatica – Reverse Engineer an Informatica ETL Job as a Data Mapping Specification.
  • Extended XML integration with IBM Information Server (Data Stage) – Auto-generate an Information Server ETL Job
  • Extended XML integration with Informatica – Auto-Import an Informatica ETL Job as a Mapping Specification
  • Extended XML integration with IBM Information Server (Data Stage) – Auto-Import an Information Server ETL Job as a Mapping Specification
  • Enhanced Mapping Comparison Capabilities (Compare to Utility)
  • Enhanced Delete Mapping Capabilities
  • Baseline Mapping Specifications at the project level.
  • Print System Analysis Report
  • Mapping Specification Data Grid – Delete multiple rows enhancement
  • Mapping Specification Data Grid – support for many to many via drag and drop
  • Added a new menu ‘Set Status Flag’ from the mapping menu to allow users to set the status flag at the row level to complete.
  • Extended the export Mapping Specification capabilities to include MS Excel and XML formats.
  • Added support for Flat File definition & Metadata Uploads to the System Manager via MS Excel import template.
  • Visual Indicators for new & changed rows in the mapping grid
  • User Passwords and database passwords for metadata are encrypted
  • Added 4 User Defined ‘Flex Fields’ to the mapping specification.
  • Extended Impact Analysis Capabilities to perform default & advanced searches
  • Extended Impact Analysis to include Business Rule / Enterprise Transformations
  • Added the capability for user to Upload/Export Enterprise Transformations via MS Excel.
  • Enhanced the Data Preview capability to extend the number of rows from 100 to 1000 upon data preview.
  • Added a built in SQL Editor
  • Enhanced Managed Metadata Capabilities – Added Ability to Maintain Data Dictionaries across all Enterprise Systems.
  • Added Data Dictionary Import & Export Capabilities.
  • Added ability to track “Sensitive Data” elements at the metadata repository level and leverage it in mappings and ETL.
  • Ability to view the audit & change history of Enterprise Transformations.
  • Enabled user defined settings for the Mapping Specification Data Grid.
  • Added packaged support for HP NeoView and Netezza database appliances.
  • Modified the default Mapping Specification Grid Layout
  • Added the ability to track resource assignments and status tracking at the Mapping Specification Version level.
  • Added email notifications to resource assignments.
  • Added a project status report at the project level & enhanced the resource contact information at the project level.
  • Added role-based security to tighten security around what users can and cannot do within each of the modules.
  • Added ability for Testing Users (Security Role Name: Tester) to update the Testing Notes and dispositions of previously versioned/frozen mapping specifications.
  • Added ability to manage, upload and export data dictionaries directly in the metadata browser
  • Added logical table name and column name to business properties in the metadata browser
  • Added email notification alerts integrated into the Mapping Assignments Tab when a mapping changes.
v2.5.4
  • Removed the schema name from SOURCE TAG NAME attribute and put it in the OWNERNAME attribute
  • Removed the schema name from TARGET TAG NAME attribute
  • Removed the schema name from INSTANCE TAG TRANSFORMATIONNAME attribute
  • Added TABLEATTRIBUTE to the INSTANCE TAG with ‘Table Name Prefix’ and value as schema name
v2.5.3
  • Updated license settings
  • Replaced ‘.’ in Oracle Schema – Table notation for Informatica XML Export
v2.5.2
  • Updated license settings
v2.5.1
  • Informatica XML Generation
GET IN TOUCH WITH US
popup