What's New

What's New

This section includes the new features and enhancements for CA ERwin Data Modeler Release 9.64. The list includes a brief description and where relevant, a link to more information about each feature.

Support for 64-bit Architecture

From Release 9.64, CA ERwin Data Modeler is available as 32-bit and 64-bit versions.The CA ERwin Data Modeler 64-bit version provides improved performance when compared to the 32-bit version.

You can install either a 32-bit or 64-bit version of CA ERwin Data Modeler Release 9.64 on your computer depending on your operating system and hardware requirements. You can also upgrade from an existing Release 9.x 32-bit version to the 64-bit version.

Note: You cannot have both 32-bit and 64-bit versions of CA ERwin Data Modeler of 9.x release on the same computer. But, you can have 32-bit and 64-bit versions from different releases on the same computer. For example, you can install the Release 9.64 64-bit version and the Release 8.2.9 32-bit version of CA ERwin Data Modeler on the same computer.

Internationalization (i18n)

From Release 9.64, CA ERwin Data Modeler is internationalized and supports the following languages:

• Brazilian Portuguese
• French
• Japanese
• Korean
• Russian
• Simplified Chinese

Metadata Integration Bridges Updated

CA ERwin Data Modeler has been updated to support Meta Integration® Model Bridge (MIMB) version 9.0 from Meta Integration® Technology, Inc. You can access the bridges when you click File, Import, From External Format or File, Export, To External Format.

The following bridges are added:

• Database (via JDBC) (Import)
• IBM Lotus Notes (via JDBC-ODBC) (Import)
• Microsoft SQL Server Analysis Services 2005 to 2012 (File) (Import)
• Microsoft SQL Server Analysis Services 7.0 to 2000 (Repository) (Import)
• Oracle Hyperion Essbase Integration Services (EIS) (Import)
• SAP BusinessObjects Crystal Reports XI (File) (Import)
• SAP BusinessObjects Crystal Reports XI (Repository) (Import)
• SAP NetWeaver Business Warehouse BW (via ODBO) (Import)
• Tableau (File) (Export)

The following bridges are removed:

• CA Erwin Data Profiler - Beta Bridge (Import)
• IBM Infosphere Discovery -Beta Bridge (Import)
• Microsoft SQL Server Integration Services (File) (Import)
• Oracle Data Warehouse Administrative Console (DAC) (Import)
• SAP BusinessObjects Data Integrator (BODI) - Beta bridge (Import)
• SAP NetWeaver Master Data Management (MDM) - Beta bridge (Import)
• Syncsort DMExpress (Import)
• Oracle Data Integrator (ODI) 11g - Beta bridge - (Export)
• SAP BusinessObjects Data Integrator (BODI) - Beta bridge (Export)
• SAP NetWeaver Master Data Management (MDM) - Beta bridge (Export)
• Syncsort DMExpress (Export)

The following bridges are renamed:

Microsoft SQL Server Support

CA ERwin Data Modeler is now compatible with Microsoft SQL Server Release 2014 SP1.

Enhanced Script Client API

You can now forward engineer a model to generate a schema and reverse engineer a data model from a schema using the Script Client API. For more information about using the Script Client API, see the ISCPersistentenceUnit section in the API Reference Guide.

Table Filter Option for REC

You can now reverse engineer a model from the database by filtering the tables using the Table Filter option. You can specify multiple search strings as comma separated values in the Table Filter text box.

Note: Table Filter option supports only SQL Server, Oracle, DB2, and Teradata databases.

API Access Only License

You can now use API access only license to access Script Client APIs with the WorK Group edition features. You must install CA ERwin Data Modeler on a workstation to use the API access only licenses.

Note:

• You cannot use the CA ERwin Data Modeler UI with the API access only license. You must have a standard, work group, community or a navigation license to use the Data Modeler UI.
• The API access only license does not support concurrent licensing.

To make the Script Client APIs work with the Work Group edition features, install the API access only license.

Follow these steps:

1. Click Start, CA, ERwin, ERwin Data Modeler.

   The CA ERwin DM Licensing dialog appears.

2. Click Install License File button.
3. Navigate to the license file and click Open.

The API access only license file is installed.

Alternate Catalog for DB2 LUW

The Alternate Catalog option now supports DB2 LUW.