Introducing the New Version of Unified Platform V8.2 Download My Copy!.
Menu
What is the CATfX Marketplace?

The CATfX Marketplace is a global community of automation developers and companies who have created Code Automation Templates (CATs) which are compatible with Mapping Manager to automate certain repeatable and reusable processes leveraging CATfX automation framework. Browse the marketplace and find a CAT which can save your organization time and money and get started now. Some of the community developers post CATs for free while others are available for a fee.

What types of automation is available in CATfX??

There are existing CATs which can automate the creation of ETL jobs (any etl job design pattern) for leading ETL tools,Data Vault Methodology, generate Big Data scripts for PIG, Scoop, Python, generate SQL, DDL, generate test cases & test SQL, integrate Mapping Manager repository with third-party or internal tools and much more. To learn more about CATfX and what it can do for you – please contact sales@analytixds.com or visit our CATfX Marketplace.

What is CATfX?

CATfX is a powerful automation framework and IDE built into Mapping Manager Framework where developers can create Code Automation Templates (CATs) and then publish them for use by non-technical or less technical resources to benefit, leverage and automate manual processes. CATs can be written in many languages such as Java, Jscript, XSLT, groovy, JRUBY, Python and created using any ETL tool by integrating with our Java API and web services.

Are Code-generation templates available for Data Vault agile data warehouse methodology?

Yes. We have Data Vault code-generation templates for most major ETL Tools and Native SQL scripts to support Data Vault. Code-generation templates are available for HUB, LINK, Satellite and Views and can be customized to support unique customer architecture requirements. AnalytiX DS has a close partnership with Dan Linstedt, the Data Vault 2.0 Author who certifies our code-generation templates for the marketplace. Data Vault Templates can be purchased individually or as a “Data Vault Bundle” to generate all design patterns to accelerate your implementation. To learn more about our Data Vault templates please contact sales@analytixds.com or visit: Data Vault Automation

What are the best practices to define complex business rules in Mapping Manager?

You can define complex business rules as shared and reusable business rules by defining them under the “Transformations” node.

Can Mapping Manager Connect with Third Party Tools to Scan Metadata?

Mapping Manager can connect to most databases using a JDBC driver and scan the metadata. For databases not support out-of-the-box in Mapping Manager, you can scan metadata from the database as long as you can connect to it using a jdbc driver. Note: The Jdbc driver needs to be specified by the user.

What are the best practices to define complex business rules in mapping manager?

You can define complex business rules as shared and reusable business rules by defining them under the “Transformations” node.

Can the product generate ETL Jobs based on Type1, Type2, Type3 etc or Customer specific templates?

Mapping Manager generates ETL jobs for Mapping Specifications based on its in-house custom template. Customer specific templates or Type1, Type2, Type3 etc code generation templates are not pre-built. We offer these as a service to customers using the CATfX offering. We can build these according to customers best practices and etl job design patterns.

Does mapping manager validate if the syntax of a particular business rule is correct while generating the ETL job?

Mapping Manager does not validate the correctness of a business rule while generating the ETL job. The tool accepts any text that is put in a business rule field. The tool creates the base level ETL code for ETL developers. The ETL developer can validate the business rules and correct them as a one time job and the correct pseudocode can be provided in Mapping Manager so that going forward the correct business rules and psuedocodes can be used which will compile with the ETL tool.

What are the ETL components that are generated during the forward Engineering Process?

The Out-of-the-box capabilities include support for the following components

Informatica: Source Qualifiers, Expressions (Business Rules), Lookups, Source Extract SQLs and Targets
Datastage: Sources, Expressions (Business Rules), Lookups, Source Extract SQLs and Targets
SSIS: Sources, Expressions (Business Rules), Lookups, Source Extract SQLs and Targets

Other components like Filters, Routers etc can be supported using the Code Automation Templates (CATfX Offering).

What level of Reverse Engineering is offered by the product?

Mapping Manager Reverse engineers ALL components of the ETL Tools into Mapping Manager. The ETL jobs can be exported from the ETL tools as an XML file and uploaded or a CATfX template can be invoked to directly connect to the ETL tool and scan all ETL components into Mapping Manager as Mapping Specifications. Once scanned technical and business oriented views are available to Mapping Manager users.

What level of forward engineering is offered by the product?

Out of the box, Mapping Manager can generate base level ETL jobs for Informatica, Datastage, Talend, SSIS, ODI, BODS etc. i.e. Mapping Specifications can be built in Mapping Manager by the Business Analyst. These mapping specs can then be exported out an as XML for the ETL Tool in question. When the XML file is imported into the ETL tool, a basic ETL mapping is already available.

Support for Complex mappings which include multi source/target, Filters, Routers etc. can be supported using the Code Automation Templates (CATfX Offering).

What level of forward engineering is offered by the product?

Out of the box, Mapping Manager can generate base level ETL jobs for Informatica, Datastage, Talend, SSIS, ODI, BODS etc. i.e. Mapping Specifications can be built in Mapping Manager by the Business Analyst. These mapping specs can then be exported out an as XML for the ETL Tool in question. When the XML file is imported into the ETL tool, a basic ETL mapping is already available.

Support for Complex mappings which include multi source/target, Filters, Routers etc. can be supported using the Code Automation Templates (CATfX Offering).

What other ETL tools are on the product roadmap?

For any ETL Tool not supported out of the box, Mapping Manager can easily integrate with the respective ETL tool using its CATfX (Code Automation Templates framework) Module & XML Integration library where ETL jobs can be built based upon certain job design best practices. Contact Us for more information.

What ETL Tools are Supported by Mapping Manager?

Mapping Manager can agnostically integrate with most ETL tools. The product currently supports Forward & Reverse engineering for various ETL tools like Informatica PowerCenter, IBM DataStage, Microsoft SSIS, Talend, Oracle Data Integrator, SAP Data Services, Pentaho, SAS Data Integrator and others.

This capability can be extended to other ETL tools using the Mapping Manager’s CATfX (Code Automation Templates framework) Module & XML Integration library where ETL jobs can be built based upon certain job design best practices.

Can the tool support complex business rules?

Yes. The Business Rules field is an unlimited free form text field. This field can capture any complex business rules using the concept of “Shared and Reusable” business rules. You can specify all the transformations and their respective pseudocodes for your ETL tool as reusable rules in Mapping Manager.

Can unstructured metadata be imported into Mapping Manager?

Yes. This would require a onetime conversion of the unstructured data from flat files etc. to an Excel Template provided by Mapping Manager. Metadata can then be imported into Mapping Manager using the Excel import process.

How are changes to metadata captured in the tool?

An Impact Analysis report can be run at the table or column level that will highlight all the mappings in which a particular table or column (to which a change has occurred) is being used. The Impact Analysis report captures table/column attributes being used as a source, target, business rule, and source extract SQL & Lookup conditions.

Can Mapping Manager generate lineage reports?

Mapping Manager has forward and backward lineage capabilities built into the tool using which the lineage of a source/target attribute can be instantly viewed across multiple source systems all the way to the EDW and Reporting Layers.

Can Mapping Manager integrate with Data Modelling Tools?

Mapping Manager can import an Erwin model in the form of an XML file and can integrate with other leading Data Modelers (e.g. ER Studio) using the universal OMG CWM format file. You can export any data model as an XML or CWM file from Data Modelling tools and import them into Mapping Manager.

Can Mapping Manager perform Data Modelling?

Mapping Manager is not a data modelling tool and therefore cannot create data models. But the tool can integrate with most Data Modelling tools by importing their metadata and maintaining the Data Dictionary in Mapping Manager. The CATfX marketplace has some CAT templates which will allow the tool to “generate” DDL from scanned metadata, but the tool does not support data modeling features like CA Erwin, Embarcadero and Sybase PowerDesigner.

Can Mapping Manager be integrated with BI reporting tools like Cognos and Microstrategy??

Yes. You can export the metadata out of BI reporting tools in an Excel or OMG CWM format and import the metadata into Mapping Manager using one of these two upload formats (Excel or CWM) and map data from data stores to the BI Reporting layer. Once done, you will have end to end data mappings and Lineage. CAT templates are available to automate some of the mappings to the BI layer saving time and money. Check out the CATfX marketplace or contact sales to learn more about what CATs can do to enable integration with BI Tools.

Is Mapping Manager an ETL tool?

Mapping Manager is NOT an ETL tool. It is a “Pre-ETL” tool that helps in accelerating the data mapping process using drag/drop techniques. The tool does not move any data. It is essentially a “Pre-ETL” enterprise data mapping tool that can also generate base level ETL code out of Mapping Specifications to accelerate the ETL process as well. Mapping Manger generates code for most leading etl tool providers such as: Informatica PowerCenter, IBM DataStage, Microsoft SSIS, Talend, Oracle Data Integrator, SAP Data Services, Pentaho, SAS Data Integrator and others.

How simple is it to install the software?

The Mapping Manager software installation takes 15-20 min and project teams can realize instant value by setting up integration projects, scan metadata and create the first mapping within 30 minutes.

What browsers does Mapping Manager run on?

Mapping Manager is certified to run on all major web browsers like Google Chrome (v28.0 & above), Firefox (v16.0 & above), Internet Explorer (v9 & above) and Safari (v5.1 & above)

What Web Servers can Mapping Manager be installed on?

Mapping Manager can be deployed on most webservers that support Java. Currently certified servers include Tomcat, Websphere, Weblogic & JBoss. But the app can easily be deployed on other web servers with java support as well that are not mentioned here with some minor customizations.

What Databases Can Mapping Manager Be Deployed On

Mapping Manager can be deployed with SQL Server or Oracle databases. The product is not certified to run on other databases.
SQL Server: version 2005 or higher (includes 2005, 2008, 2012)
Oracle: version 9i or higher

What Operating Systems can Mapping Manager be deployed on?

Windows Server 2003 or higher, Unix and Linux (SUSE, Ubuntu and Redhat)

What are the prerequisites to install the software?

JRE7, Tomcat 7, SQL Server or Oracle Database.

Ready to Partner with AnalytiX DS? Join Our Partner Program

Let's Connect

To explore your opportunities with the AnalytiX DS Systems Integrator program


Email UsCall Us

GET IN TOUCH WITH US
popup

Get started with AnalytiX DS for Enterprise Data Mapping and Automation platform