CA ERwin Data Modeler Release Notes
Contents
1. ccccsessssecececeesessscesecececseeaeeseeececsesueaesecececeesesasaeeeeeees 38 Contents 5 Support for CA ERwin Data Modeler Workgroup Edition ccceesceceeseececseeeeceeseeeeceeaeeeeceeneeeeeaeeecseaaeeeseeneeeees 38 Chapter 4 Installation Considerations for CA ERwin Data Modeler Workgroup Edition 39 Microsoft SQL Server 2005 Permissions ccssccccsssceceessreecseeececseneecsesueeecseasececseeeeceesueeeceeaaecsceeeeceeaueeeseeaaeeeceeeeeeeees 39 Specify Use of Foreign Characters With Microsoft SQL Server 2005 cccccccssscceceeeeececseeeeceeseeeeceesaeeeceeneeeseeneeeseaaes 40 Specify Use of Foreign Characters With Microsoft SQL Server 2000 ssssssseeeeeeeeeeenee enne enne nennen enne 40 Client Version ero ALIS E 41 Chapter 5 Installation Considerations for CA ERwin Data Modeler Navidator Edition 43 Silent rasta lisse EET 43 Client Versiom CHOCKING ccccssscticessbseicccadeessaceienseasssendsnsosintensbinnicasadeesoacessndeesalbeantsadunteesesesieasobiedesea abansaisadendedaddassoscuien 43 Chapter 6 General Considerations for Using CA ERwin Data Modeler Workgroup Edition 45 CONVENSIOMMMTONMATION ERE 45 Conversion Preparation Recommendations ccsesseccesseececeeseececseccececseeecseauececeeeeeceeaeeecsesaeeeceeaeececeeeeeceeaeeeseeaeeens 45 Conversioncot Custom Security Profiles ota ot petto einn rite onte Ek erii E qe2. General Considerations for Using CA ERwin Data Modeler Navigator Edition The following sections contain general information you should know before using CA ERwin Data Modeler Navigator Edition Model Display in the Difference Reconciliation Dialog Help Files In a workgroup modeling environment two users may check out and make changes to the same model The first user may make changes to the model and save the changes to the mart When the second modeler makes changes and saves them to the mart the Difference Reconciliation dialog is displayed You use features in this dialog to view the differences on the object level the more detailed property level or search the text of the comparison lists Note In the Difference Reconciliation dialog the model in the left pane is the current model that you are checking in to the mart The model in the right pane is the version of the model already in the mart The context sensitive online help in CA ERwin Data Modeler Navigator Edition is identical to the online help in CA ERwin Data Modeler This means that the online help may discuss capabilities such as saving a model that is not possible in the CA ERwin Data Modeler Navigator Edition product Chapter 7 General Considerations for Using CA ERwin Data Modeler Navigator Edition 49 Chapter 8 Known Issues This section contains known issues you should review before using CA ERwin Data Modeler r8 This section contains the following t
3. Cen EENE o ESAE MERE R FER ents 46 Conversion Notes for Oracle Microsoft SQL Server and Sybase ccccccccesssececssscececssececeesaececssssececsseseceesaeeecssseeees 46 r8 Model Conversion and Complete Compare Differences ccccccssssececseseececseececeesueeeceeaeececseeeececueeeseeaaeeseeeeeeeees 46 Model Display in the Difference Reconciliation Dialog eeseseseeseseeeeeeen ener en nennen enne enne 47 Uninstalling CA ERwin Data Modeler Workgroup Edition seen 47 Chapter 7 General Considerations for Using CA ERwin Data Modeler Navidator Edition 49 Model Display in the Difference Reconciliation Dialog eseessssseeseseeeeeeee eene nennen enne enne 49 Help dr eL 49 Chapter 8 Known Issues 51 SOL ITIOS ggg 51 Model and Version Name Limit on Oracle esssssssseeseeeeeeen eene enne enne en tenes en ren tene nn seen nennen nensi 51 Editing UDP Valuesn the Bulk Editor rere eph ptu rabie ea e ABER SERRE E PARE CEN URN BRS E XR RR ERA 52 Reverse Engineer from Database eise errata I rl ERE a E ER Re FRE e a Fea Ree E GREEN VE FRE ERA TTE RENE ER RESCUE Tra rui ERE 52 CA ERwin Data Modeler r8 and Crystal Reports Shell Installation seeeessseeeeeeeneeeenenneeen nenne 52 CA ERwin Data Modeler r8 Silent Installation ccccccsssececssseececseecec
4. HKEY_LOCAL_MACHINE Software Wow6432Node SAP BusinessObjects m For 32 bit Windows OS delete HKEY_LOCAL_MACHINE Software SAP BusinessObjects m Delete HKEY_CURRENT_USER Software CA ERwin Data Modeler 9 0 Crystal Reports Path m Delete HKEY_CURRENT_USER Software CA ERwin Data Modeler 8 2 Crystal Reports Path 2 Launch CA ERwin Data Modeler the Crystal Reports Path for Crystal Reports 2008 is recreated for respective releases and the Crystal Reports Developer menu item is enabled Chapter 9 Fixed Issues This section includes the list of issues that is fixed This section contains the following topics Issues Fixed in this Release see page 56 Chapter 9 Fixed Issues 55 Issues Fixed in this Release Issues Fixed in this Release 56 Release Notes The following issues are fixed in CA ERwin Data Modeler release 8 2 9 Issue No 21577042 2 Problem No 12621 DB2 CC ALTER STATEMENT GEN DROP AND RECREATE In CA ERwin Data Modeler release 8 2 8 when a specific DB2 z OS model was compared with another DB2 model or with the database the length of a column was changed and the DDL was generated the updated DDL included rename drop recreate statement instead of the ALTER table column statement Issue No 21517625 1 Problem No 12560 Reverse Engineer Owner Problem In CA ERwin Data Modeler release 8 2 8 while reverse engineering from an Oracle10 11 database although the options were set to reverse engineer the objects for a
5. IBM Cognos BI Reporting Framework Manager IBM Cognos BI Reporting PowerPlay Transformer IBM DB2 Cube Views IBM DB2 Data Server via JDBC IBM InfoSphere Data Architect IDA IBM InfoSphere Federation Server via JDBC IBM Lotus Notes via JDOBC ODBC Metadata Integration Bridges Updated IBM Rational System Architect SA 10 4 to 11 x Encyclopedia IBM Rational System Architect SA 7 1 to 11 x File Informatica PowerCenter Repository Micro Focus Merant AppMaster Builder Microsoft Office Access via JDBC ODBC Microsoft Office Excel Java Alpha Microsoft SQL Server Analysis Services 2005 to 2008 Repository Microsoft SQL Server Analysis Services 7 0 to 2000 Repository Microsoft SQL Server Analysis Services 7 0 to 2000 via ODBO Microsoft SQL Server Database via JDBC Microsoft SQL Server Reporting Services Repository MicroStrategy MDX Adapter via ODBO Oracle Data Integrator ODI 11g Beta bridge Oracle Database via JDBC Oracle Warehouse Builder OWB Oracle Warehouse Builder OWB via CWM XMI SAP BusinessObjects Crystal Reports XI Repository SAP BusinessObjects Data Integrator BODI SAP BusinessObjects Designer Repository SAP BusinessObjects Desktop Intelligence Repository SAP BusinessObjects Web Intelligence XI SAP ERP Central Component ECC Beta bridge SAP NetWeaver Business Warehouse BW via ODBO SAP NetWeaver Business Warehouse BW via XML SAP NetWeaver Master Data Managem
6. Problem No 12668 COL ED NOT WORK IF FILTERED Issues Fixed in this Release In CA ERwin Data Modeler release 8 2 8 in the Column Editor of a DB2 LUW r9 7 model when the column names were filtered the remaining columns in the dialog froze Issue No 20397736 1 Problem No 11448 SPELL CK IN BULK EDTR NOT WORK In CA ERwin Data Modeler release 8 2 8 the Spell Check button did not function properly in the Bulk Editor Instead of replacing a wrongly spelt word with the correct one it inserted the correct word before the wrongly spelt word Issue No 21562372 1 Problem No 12593 CAN T RESET LICENSE WINDOW In CA ERwin Data Modeler release 8 2 8 the Licensing dialog was not appearing when the product was launched Even Reset All Messages option did not work Issue No 21442282 1 Problem No 12454 BULK EDITOR MISS ROLENAMED COL In CA ERwin Data Modeler release 8 2 5 a role named fishhook column did not show in the Bulk Editor Column list Issue No 21534848 1 Problem No 12597 CAN T GET ALTER SCRIPT In CA ERwin Data Modeler release 8 2 8 Alter Script could not be created for some Sybase models that were upgraded from a previous version Issue No 21557677 1 Problem No 12007 CAN T SAVE VOLUMETRICS CSV REPORT IN FOLDER SELECTED Volumetrics report could not be saved as a CSV file to a specific path in CA ERwin Data Modeler release 8 2 7 The message Unable to open CSV File writing was displayed Issue No 21363672 1 Problem No 12
7. You can strip the installer of the dbo role after the installation or upgrade is complete For more information about preparing the DBMS environment see the CA ERwin Data Modeler Workgroup Edition Implementation Guide Chapter 3 System Information 37 CA ERwin Data Modeler Navigator Edition Requirements Client Workstation Requirements You must install CA ERwin Data Modeler r8 2 on each client workstation that needs to access models in the mart and each client workstation must have access to the DBMS on which the mart is located It is recommended that client workstations have at least 2 GB of RAM CA ERwin Data Modeler Workgroup Edition r8 2 also supports CA ERwin Data Modeler Navigator Edition r8 2 as a client Note In a workgroup environment CA ERwin Data Modeler users can only connect to a mart initialized with the same serial number identifier that the user has licensed on their local machine CA ERwin Data Modeler Navigator Edition Requirements If you plan to use CA ERwin Data Modeler Navigator Edition review the following requirements to ensure your environment is set up properly Support for CA ERwin Data Modeler Workgroup Edition 38 Release Notes CA ERwin Data Modeler Navigator Edition r8 2 is enabled for use with a mart enabled version of CA ERwin Data Modeler Workgroup Edition Consult with your mart administrator for a GUEST user permission to access models in CA ERwin Data Modeler Workgroup Edition You
8. if installing from DVD media Note The minimum screen resolution supported is 1024 x 768 If your screen resolution is less than the minimum supported some portions of the screen will not be visible Administrative Priviledes Required Because the installation process for CA ERwin Data Modeler writes to the registry and system folders the person installing upgrading or removing CA ERwin Data Modeler must have Administrative privileges If you run an install without Administrative privileges all files may not be installed or upgraded and users can encounter problems when running the software 34 Release Notes Current User Installation Current User Installation In the CA ERwin Data Modeler release 8 0 when you installed CA ERwin Data Modeler only the user who installed the software could use it Beginning with r8 2 the license mechanism is changed to per machine instead of per user When you install CA ERwin Data Modeler anyone using the computer can use it In addition if a valid license is available multiple users can use CA ERwin Data Modeler simultaneously on a computer Because of this change the license files are now available in the following locations Windows XP C Documents and Settings All Users Application Data CA ERwin Data Modeler lt release number gt Windows 7 C ProgramData CA ERwin Data Modeler lt release number gt Supported Target Server Databases The following target server databases are supp
9. product release The release number changes only when a significant portion of a document changes to support a new or updated product release For example a document for r8 may still be valid for r8 1 Documentation bookshelves always reflect the current product release number Occasionally we must update documentation outside of a new or updated release To indicate a minor change to the documentation that does not invalidate it for any releases that it supports we update the edition number on the cover page First editions do not have an edition number Chapter 10 Documentation 61
10. that all copies and partial copies of the Documentation have been returned to CA or destroyed TO THE EXTENT PERMITTED BY APPLICABLE LAW CA PROVIDES THIS DOCUMENTATION AS IS WITHOUT WARRANTY OF ANY KIND INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY FITNESS FOR A PARTICULAR PURPOSE OR NONINFRINGEMENT IN NO EVENT WILL CA BE LIABLE TO YOU OR ANY THIRD PARTY FOR ANY LOSS OR DAMAGE DIRECT OR INDIRECT FROM THE USE OF THIS DOCUMENTATION INCLUDING WITHOUT LIMITATION LOST PROFITS LOST INVESTMENT BUSINESS INTERRUPTION GOODWILL OR LOST DATA EVEN IF CA IS EXPRESSLY ADVISED IN ADVANCE OF THE POSSIBILITY OF SUCH LOSS OR DAMAGE The use of any software product referenced in the Documentation is governed by the applicable license agreement and such license agreement is not modified in any way by the terms of this notice The manufacturer of this Documentation is CA Provided with Restricted Rights Use duplication or disclosure by the United States Government is subject to the restrictions set forth in FAR Sections 12 212 52 227 14 and 52 227 19 c 1 2 and DFARS Section 252 227 7014 b 3 as applicable or their successors Copyright 2014 CA All rights reserved All trademarks trade names service marks and logos referenced herein belong to their respective companies Contact CA Technologies Understanding your Support Review support maintenance programs and offerings Registering for Support Acce
11. 3685 If any documentation is updated after a main release the cover page of the documentation always includes an edition number to indicate the release for which it was updated see Release Numbers see page 61 for more information Chapter 3 System Information 33 Operating System Support Operating System Support CA ERwin Data Modeler requires that you have the 32 bit version of one of the following operating systems installed Microsoft Windows Vista Microsoft Windows 2008 Server Microsoft Windows 2003 Server m Microsoft Windows XP through SP3 m Microsoft Windows 7 Note CA ERwin Data Modeler is a 32 bit application and is fully compatible with 64 bit operating systems except for the following known issues m 64 bit database drivers and clients will not work with the application The workaround is to use 32 bit database drivers and clients in the 64 bit operating system environment m Running the ERwin API in a 64 bit environment requires some changes to the workstation registry For more information about changing the registry see the CA ERwin Data Modeler WE Implementation and Administration Guide System Requirements The following requirements must be met or exceeded for CA ERwin Data Modeler to install and run correctly m Microsoft based workstation Intel Pentium 4 or equivalent m 2 GB available hard drive space m 2 GB RAM minimum more is recommended for large models m DVD readable device only
12. 577 ERRONEUS DDL GENERATION In CA ERwin Data Modeler release 8 0 if both Generate and Generate as Constraints were selected for a PK index and the Create PK option was selected for the Primary Key PK under Referential Integrity the DDL was incorrectly generated It created a Unique Index AFTER the Primary constraint which created a PK index in the database automatically Issue No 20518832 1 Problem No 11586 FET WRONG CONSTRAINT SYNTAX In CA ERwin Data Modeler release 8 1 the Alter Script DLL for an Oracle model had incorrect syntax for adding constraints The keywords ENABLE VALIDATE were generated in the wrong position Issue No 21493242 1 Problem No 12501 CC MODEL WITH BLANK CRASH In CA ERwin Data Modeler release 8 2 5 a specific SQL Server 2008 model displayed an error message when compared with an empty model Saving the model as an XML file and importing the XML to a new model did not work either Chapter 9 Fixed Issues 57 Issues Fixed in this Release Issue No 21490664 1 Problem No 12506 CANNOT SPLIT ALL MODELS In CA ERwin Data Modeler release 8 2 6 when a Logical Physical model was split the message An unexpected error occurred was displayed and only the Physical Only model was created 58 Release Notes Chapter 10 Documentation This section contains information about current product documentation This section contains the following topics Documentation Formats and Deliverables see page 5
13. 9 Technical Documentation Series see page 60 Release Numbers see page 61 Documentation Formats and Deliverables The following changes have been made to CA ERwin Data Modeler documentation m Inthe earlier versions of CA ERwin Data Modeler pre r8 installing documentation was optional Now when you install CA ERwin Data Modeler documentation is installed by default m The following online help systems are now available only through the CA ERwin Data Modeler bookshelf Add in Manager Online Help Datatype Standards Online Help ERwin Online Help Naming Standards Online Help Note In r8 these online help systems were available in the bookshelf and in the CA ERwin Data Modeler r8 Doc folder Deliverables Included m The Bookshelf provided with CA ERwin Data Modeler which is installed by default includes documentation for CA ERwin Data Modeler Navigator Edition You can open the Bookshelf in a web browser from the CA ERwin Data Modeler Start menu The documentation provided on the Bookshelf includes Deliverable Name Format Provided Add In Manager Online Help HTML Administration Guide Workgroup Edition HTML and PDF API Reference Guide HTML and PDF Datatype Standards Online Help HTML Editing Forward Engineering Templates HTML and PDF Chapter 10 Documentation 59 Technical Documentation Series Deliverable Name Implementation Guide Implementation Guide Workgroup Edition Installation Guide Metamo
14. CA ERwin Data Modeler Release Notes Service Pack 8 2 9 ca This Documentation which includes embedded help systems and electronically distributed materials hereinafter referred to as the Documentation is for your informational purposes only and is subject to change or withdrawal by CA at any time This Documentation may not be copied transferred reproduced disclosed modified or duplicated in whole or in part without the prior written consent of CA This Documentation is confidential and proprietary information of CA and may not be disclosed by you or used for any purpose other than as may be permitted in i a separate agreement between you and CA governing your use of the CA software to which the Documentation relates or ii a separate confidentiality agreement between you and CA Notwithstanding the foregoing if you are a licensed user of the software product s addressed in the Documentation you may print or otherwise make available a reasonable number of copies of the Documentation for internal use by you and your employees in connection with that software provided that all CA copyright notices and legends are affixed to each reproduced copy The right to print or otherwise make available copies of the Documentation is limited to the period during which the applicable license for such software remains in full force and effect Should the license terminate for any reason it is your responsibility to certify in writing to CA
15. Conversion and Complete Compare Differences see page 46 Model Display in the Difference Reconciliation Dialog see page 47 Uninstalling CA ERwin Data Modeler Workgroup Edition see page 47 Conversion Information CA ERwin Data Modeler r8 2 will be installed in new folders on your hard drive however both r7 x CA ERwin Model Manager and r8 2 can exist on the same machine Note You must be at r7 x or later in order to convert existing models to r8 2 Additionally before you can use the Submodel Manager to work with models in the mart you must first upgrade each r7 x model to r8 2 For more information about converting from r7 x to r8 2 see the CA ERwin Data Modeler Workgroup Edition Implementation Guide Conversion Preparation Recommendations Before you convert we recommend the following 1 Verify that all models to be converted were saved and opened in your current database 2 Close all open sessions 3 Delete any unnecessary models This reduces the conversion time and the amount of space used by the mart database during the conversion A complete CA ERwin Data Modeler Workgroup Edition Pre Conversion checklist is available on the CA ERwin Data Modeler technical support page Before attempting to convert your mart be sure to read this document If you need assistance during the conversion process you can open a support issue from the support link Chapter 6 General Considerations for Using CA ERwin Data Mo
16. Domains Default Values Functions Indexes Logins Schemas Spatial Indexes Stored Procedures Synonyms Chapter 2 New Features and Enhancements 27 Publishing CA ERwin Data Modeler Models to a Web Portal m Tables m Triggers m User IDs m Validation Rules m Views Publishing CA ERwin Data Modeler Models to a Web Portal You can now publish your model to the CA ERwin Web Portal using the Web Portal Publish menu option You must have the CA ERwin Web Portal details and you must start the service before you publish Note You can also export a model to MIR XMI format using the File Export To External Formats menu option Model Templates 28 Release Notes New model templates were added to CA ERwin Data Modeler to facilitate easier and consistent creation and maintenance of data models In addition to the model template files used in previous releases erwin tmpl which can still be used r8 2 model template files use the erwin extension Note You can use either erwin tmpl or erwin extensions as a template for creating models However to achieve synchronization of model objects between a model template and a data model you bind the model template to the model You can only use the erwin extension for template binding Binding a model template to a data model copies the non built in objects from the template model to the target model When you bind a model template the predefined model objects populate you
17. For example if your login is named ogin1 and the fully qualified name of your SQL Azure server is servername database windows net the username parameter of your connection string should be login1 servername This restriction places limitations on the text you can choose for the login name SQL Azure Database Permissions The SQL Azure Permission Editor can be used to define permissions for a database in a SQL Azure physical model 26 Release Notes Database Support Update Database Support Update Support has been added for the following target server database in CA ERwin Data Databases Added Modeler r8 2 m SQL Azure Notes Ifyou plan to use SQL Azure as your target server verify that your SQL Azure license is present on the computer on which you plan to run CA ERwin Data Modeler If it is not present you are unable to select SQL Azure as a target server Review Connecting to SQL Azure see page 26 for specific connection information SQL Azure support is included for the following functional areas in CA ERwin Data Modeler m Modelcreation m Reverse engineering m Derive model m Forward engineering Note The principal Application Role is not supported in SQL Azure Any property editor that provides a way to set permissions on an object will not have Application Role available for selection in the list of Principals to Grant Support is provided for the following objects Databases Database Roles
18. I file m Meta Integration Repository MIR XMI multimodel content m Microsoft Office Visio Database via ERX m Oracle Warehouse Builder m Oracle Warehouse Builder via CWM XMI m SAP BusinessObjects Data Integrator m SAP BusinessObjects Metadata Management BOMM via MIR XMI m SAP NetWeaver Master Data Management MDM m SAS Management Console via MIR XMI m Sybase PowerDesigner 7 0 via ERX Copy and Paste Theme Copy and Paste Theme You can now copy a theme from an object and paste it to another When you right click the workplace the following new options are available in the context menu Copy Theme and Override Fonts and Colors Copies the theme that is attached to the selected object If the selected object includes local overrides they are copied as well Paste Theme and Override Fonts and Colors Applies the selected theme to the selected target object If the target object is already applied with a theme the existing theme is replaced with the selected theme In addition if you have selected local overrides for the target object the overrides are replaced with those of the source object Note If the target object is already applied with a theme the theme is not deleted from the model For the issues fixed in this release see the Issues Fixed in this Release topic Licensing Enhancements The CA ERwin Data Modeler licensing functionality has been enhanced to include the following types of licenses L
19. ble with the current version of the mart database Even though there is a version dependency the service pack version can vary Chapter 4 Installation Considerations for CA ERwin Data Modeler Workgroup Edition 41 Chapter 5 Installation Considerations for CA ERwin Data Modeler Navigator Edition Review the following installation considerations before installing the product See the CA ERwin Data Modeler Navigator Edition User Guide for more information about the installation process Silent Install This product does not provide an unattended or silent install Client Version Checking When you connect the CA ERwin Data Modeler Navigator Edition client to a mart database the software checks to verify that the client version is compatible with the current version of the mart database There is a version dependency however the Service Pack version can vary Chapter 5 Installation Considerations for CA ERwin Data Modeler Navigator Edition 43 Chapter 6 General Considerations for Using CA ERwin Data Modeler Workgroup Edition The following sections contain general information you should know before using CA ERwin Data Modeler in a workgroup environment This section contains the following topics Conversion Information see page 45 Conversion Preparation Recommendations see page 45 Conversion of Custom Security Profiles see page 46 Conversion Notes for Oracle Microsoft SQL Server and Sybase see page 46 r8 Model
20. cess and work with data models stored in a mart When you enable data movement or dimensional modeling features it provides a tool for assisting Data Administrators and Capacity Managers design data warehouses Partners can use the API to create add on solutions to CA ERwin Data Modeler With the optional SQL Azure extension you can take advantage of using SQL Azure as a target database 12 Release Notes Workgroup Edition Workgroup Edition CA ERwin Data Modeler Workgroup Edition provides all the data modeling features used by Data Architects and also includes workgroup modeling capabilities used by Database Administrators Application Administrators and Application Owners It provides conflict resolution versioning security and standardization for multi user modeling Workgroup modeling operates in a client server environment so processing is shared between the user client workstation and the server where the models are stored Users access the stored models through a client such as CA ERwin Data Modeler Models are held in a platform and network independent database or mart that resides on a central server using Microsoft SQL Server Oracle or Sybase as the host database With the optional SQL Azure extension you can take advantage of using SQL Azure as a target database The key features of CA ERwin Data Modeler Workgroup Edition include Model change impact analysis Provides a change summary showing the impact of changes and the hi
21. decsednuncededuandcenusesceavehad euxeateacddedensdeacacteceeedveaees 29 Chapter 3 System Information 31 Upgrading CA ERwin Data Modeler from r7 x to r8 x cssccccesssececseceeceesaeeeceeaeececsaeeceeauececeeaaececsaeeceeueeeseeaaeeeseeeeeeees 32 Release Numbering Scheme in CA ERwin Data Modeler eseeseseeeeeeeeeen nennen nennen nennen en nnne nnne 33 Operating SYStEM SUPPONE AE 34 System Requirement S serinati anan aiia ea a R aE eaa ASE a ES ta E Eae a an ins 34 Administrative Privileges Required 0 cccccsscccccecsessescecececeeseeaeeeeececeeseseeeeseeececsesseaeseeeeeceeseeaeseeeeeceesauaeseseeseeeseaeaeees 34 CurrentiUser Installation tor eee cs EE a E EE EEE E EEE E E EE ER a 35 Supported Target Server Databases ccacccsiccssdeccdeececescansaedesceveessveatedsivavenskensseedestelvessinaeecdeivouatadesetccdvcunderdasecaedsivedeaades 35 CA ERwin Data Modeler Workgroup Edition Requirements esses eene ener nnn enne nre nennen 36 Administrator Server System REqQuireMents ccccccccccssssssssssecccecsesesaeseeececseseaseseeececseseeasaeeecsceesesasseeeeseneseaeaeees 36 DBMS Redqulrements 5 otc loreet aee arenie a ae E er E Eeer ety len ues Pb en e OE Ee e RP Re RUD AEREE 37 Client Workstation REQUIreMENMS csscccceesceceessececeesaececseecececsueeeceeaaececsueeecseaaeeececeececsueeeceeaueeeseeseeceesteeceeaaes 38 CA ERwin Data Modeler Navigator Edition Requirements
22. del Reference Methods Guide Naming Standards Online Help ODBC Reporting Guide CA ERwin Data Modeler Online Help Release Notes Template Language and Macro Reference PDF User Guide Navigator Edition HTML and PDF Note For more information about the CA ERwin Data Modeler editions see CA ERwin Data Modeler Editions see page 9 Technical Documentation Series 60 Release Notes The Template Language and Macro Reference Template Lang and Macro Ref PDF technical document is provided on the Bookshelf and can also be accessed from the Tech Docs menu item on the CA ERwin Data Modeler Start menu The CA ERwin Data Modeler metamodel reference and overview technical documents are provided on the CA ERwin Data Modeler Metamodel Reference Bookshelf This Bookshelf is accessible from the Tech Docs menu item on the CA ERwin Data Modeler Start menu It contains an overview of the metamodel ERwin Metamodel Overview PDF and the metamodel object and property descriptions are provided in HTML format Metamodel Reference To view PDF files you must download and install the Adobe Reader from the Adobe website if it is not already installed on your computer Release Numbers Release Numbers The release number on the title page of a document might not correspond to the current product release number however all documentation delivered with the product regardless of release number on the title page will support your use of the current
23. deler Workgroup Edition 45 Conversion of Custom Security Profiles Conversion of Custom Security Profiles Enhancements to the CA ERwin Data Modeler r8 metamodel may have an effect on custom security profiles that you created in CA ERwin Model Manager r7 x If you defined custom security profiles or modified existing ones in the previous release review your permissions to ensure that your security requirements are met in CA ERwin Data Modeler r8 Conversion Notes for Oracle Microsoft SQL Server and Sybase Review the following information before you attempt a CA ERwin Data Modeler r7 x to r8 database conversion For Oracle r7 x databases m Make sure you have at least as many rollback segments as used by your r7 x database We strongly recommend that you follow the guidelines in the CA ERwin Data Modeler Workgroup Edition Administration Guide m Before you start a conversion it is strongly recommended that you shrink rollback segments The following is a sample SQL statement for each segment ALTER ROLLBACK SEGMENT lt RBS NAME gt SHRINK It is safe to randomly shrink rollback segments while the conversion is running but you must be logged in as the DBA For Microsoft SQL Server and Sybase r7 x databases m tempdb should be as big as the mart DB size r8 Model Conversion and Complete Compare Differences 46 Release Notes Unlike previous conversions to new releases starting with r8 it is no longer valid to do a round tr
24. e 19 Metadata Integration Bridges Updated o cccecsssccccecsesssssceeececseseeesecececsesesaeseceesceesesessecececeesesesaeseescecsesesaeseeeceseenees 19 Import Bridges Added Remowved cccssccsssceessecssscecseecesscecseecssseccssecesseecaeecssssccseecessessaeecsssssessecesseseaseenstesenaeenaes 20 Export Bridges Added Removed sccccssecsssseessecssscecssecsseecseecsseccssecesssecasecssssccasecssseccssecsseccasecessaceasecesteeeaseceees 23 Copy and Paste Theme reete ores ciet oases awe eae Fera aepo ERE CER RRREEE VE Feed Ea ERE ER aE A AREE GRE ea XR EEREES VERE RENTA MR YER ES 25 licensing Enhancements issiria aeaaee an a cea coed ae Ru Ra ches adionsenes jendesatentaaSedesheeeusten caevacainn ai ex Rea MA RR 25 Connecting tO SOL AZUEIG eiue ons cenae autre duende os auev laces ana deci genau equ exa v xn enean quen Den d gena uin qu exa xd anas as vena cce ema tu laeaine 26 SQL Azure Database Permissions cccccssccecseccececseeeeceenaeeeceneeeceesaececsenaececeneeceesaeeeceeaeeseseneeeeseqaeeesseaaeeesseeeeeeas 26 Database Support Ulo ER 27 Databases Added M E E 27 Publishing CA ERwin Data Modeler Models to a Web Portal eene enne nnn nnne nnn 28 Model Templates etre ease adu tensa datae san du qe sep ino quaera nuu aa tesalsndnceadedsuaauslentsasasbcenecnentacaudedsansaaeesacneattens 28 Enhancements for Diagralmis esee des rot etta ree ene nee ER rena cease denwedsGea
25. e first time you open the Licensing dialog and install the license file If you are using concurrent licenses you provide the path to the License Server on the CA ERwin Data Modeler Licensing dialog In the previous release you opened CA ERwin DM and then the Licensing dialog to install your license Now you can install your license and can add the server path to the License Server from the CA ERwin Data Modeler Licensing dialog before the application opens The following image shows the updated dialog ICA ERwin Data Modeler Licensing Merge Alter Table Statements for DB2 LUW Merge Alter Table Statements for DB2 LUW CA ERwin Data Modeler Service Pack 8 2 6 includes an enhancement to the Forward Engineering Template of DB2 LUW When you generate the alter script the Merged Alter Table Statements option is displayed when you select Other Options This option merges the ALTER TABLE statement for an entity and generates a single ALTER TABLE statement if the table is not dropped and created If a property change requires a table to be dropped and created such ALTER TABLE statements are not merged Note After three units of work that include ALTER TABLE operations have been performed run a REORG TABLE command For more information see the IBM documentation For the issues fixed in this release see the Issues Fixed in this Release topic Metadata Integration Bridges Updated CA ERwin Data Modeler has been updated to suppor
26. eeseeecseauececeeeeececueeecseaaeesceeeaeceesaeeeceeaeeeseenaeens 53 Upgrading CA ERwin Data Modeler on Windows Server 20083 sessssesesseseee eene enne ener nennen 53 Administrative Privileges Required for Export Import and Query Tool Options eseeeeeneeeene 53 6 Release Notes Crystal Reports Developer menu item in CA ERwin DM and Edit Design in CA ERwin Report Viewer are CISA DN OG NRI ECTETUR SIME IE 54 Chapter 9 Fixed Issues 55 Iss es Fixedtii this Release uere tr ree ertet terrenae ener nada e dye reet awava te dna er aad Va a due ranae ENEE drap En AEE 56 Chapter 10 Documentation 59 Documentation Formats and Deliverables sssssseeeeeeneneneneneneneeennnennnnnnn enne nennen nnne sensns sense neni 59 Technical DOCUMENTATION Series rr retira i dU a ERR x TR Ra ri YER EU Ei P RE RE TR Re RR RE V Un Ea Taa 60 Release NUMDEFS esiste ears cocaine praed drank heme dav dea apnea vdd cann is nnn o teihin innsinn 61 Contents 7 Chapter 1 CA ERwin Data Modeler Editions The following editions of CA ERwin Data Modeler are available Community Edition see page 10 Standard Edition see page 12 Workgroup Edition see page 13 Navigator Edition see page 14 CA ERwin Data Modeler for Microsoft SQL Azure see page 15 This Release Notes details new features enhancements updates and known issues for all editions of CA ERwin Data Modeler Note Depending on the editi
27. ements see page 34 Administrative Privileges Required see page 34 Current User Installation see page 35 Supported Target Server Databases see page 35 CA ERwin Data Modeler Workgroup Edition Requirements see page 36 CA ERwin Data Modeler Navigator Edition Requirements see page 38 Chapter 3 System Information 31 Upgrading CA ERwin Data Modeler from r7 x to r8 x Upgrading CA ERwin Data Modeler from r7 x to r8 x 32 Release Notes Models You can upgrade any model from r7 x to r8 x During the r8 x upgrade process for CA ERwin Data Modeler Workgroup Edition a dialog opens if you have any models that are stored in a r7 x mart that are Version 4 x This dialog contains a list of all the Version 4 x models and presents you with the following options for each model m Delete the Version 4 x model and continue with the mart upgrade m Cancelthe mart upgrade Doing so lets you go back to CA ERwin Data Modeler r7 x convert the models from Version 4 x to r7 x and save to the mart After you have saved these models to your mart you can continue with the r7 x to r8 x upgrade Printer settings and paper size considerations If you use a paper size other than Letter before you upgrade any r7 x models to r8 x ensure your paper size specifications are set in the Printer Properties dialog and saved with the model Otherwise you must reset your paper size in the Page Setup Editor in r8 x Deleting subject areas dur
28. ent MDM Beta bridge SAS OLAP Server via ODBO Sybase Database via JDBC Sybase PowerDesigner CDM 7 5 to 16 x Sybase PowerDesigner PDM 7 5 to 16 x Syncsort DMExpress Teradata Database via JDBC Chapter 2 New Features and Enhancements 21 Metadata Integration Bridges Updated 22 Release Notes Support has been removed for the following MIMB import bridges IBM Cognos BI Reporting PowerPlay Transformer Beta bridge IBM InfoSphere Data Architect IBM InfoSphere Discovery Beta bridge IBM InfoSphere Warehouse Cubing Services for OLAP IBM Rational System Architect 10 4 to 11 x Encyclopedia IBM Rational System Architect 7 1 to 11 x File Meta Integration Repository MIR XMI file Meta Integration Repository MIR XMI multimodel content Microsoft SQL Server Integration Services File MicroStrategy 7 0 to 9 0 Oracle Business Intelligence Answers Oracle Business Intelligence Server Oracle Data Integrator 11g Oracle Warehouse Builder Oracle Warehouse Builder via CWM XMI SAP BusinessObjects Data Integrator SAP NetWeaver Business Warehouse BW Beta bridge SAP NetWeaver Business Warehouse BW via XML Beta bridge SAP NetWeaver Master Data Management MDM SAS Data Integration Studio via MIR XMI SAS Information Map Studio via MIR XMI SAS Management Console via MIR XMI SAS Metadata Management via MIR XMI Sybase PowerDesigner CDM 7 5 to 15 x Sybase PowerDesigner PDM 7 5 to 15 x Metadata Integ
29. erates For this reason routine management is usually performed by a dedicated administrator Administrators can find detailed information regarding their tasks and responsibilities in the CA ERwin Data Modeler Workgroup Edition Administration Guide Chapter 1 CA ERwin Data Modeler Editions 13 Navigator Edition You can also use CA ERwin Data Modeler Navigator Edition as a client Read only access is permitted to data models so your workgroup can use this client to share information with others without the risk that unauthorized changes might be saved to the mart Additionally you can connect to the mart through the Naming Standards Editor or the Datatype Standards Editor Navigator Edition 14 Release Notes CA ERwin Data Modeler Navigator Edition provides a cost effective way to provide read only access to models built with CA ERwin Data Modeler for viewing and analysis This edition does not permit you to make any changes to models The key features of CA ERwin Data Modeler Navigator Edition include Read only access Read only access is provided to models created by CA ERwin Data Modeler and it can also be used as a Workgroup Edition client for viewing a data model stored in a mart Use the Navigator Edition to easily share model information without the risk of unauthorized changes to a model Navigation and Viewing Provides those who need to view models but not update them full navigation and viewing of data models Repo
30. f the Community Edition include the following m A copy of Crystal Reports 2008 is not included with the Community Edition m Features supporting the creation and implementation of data type standards are not enabled m Access to the CA ERwin Data Modeler Workgroup Edition is disabled When working with Complete Compare the option to compare your model with a model in a mart is disabled m The Community Edition license is valid for one year After one year you can reinstall the Community Edition with a new license or purchase and install a full version of the product You can install and use the Community Edition without entering a license key for 30 days from the date you installed the product Note If you attempt to access a disabled feature in the Community Edition a pop up message appears to remind you the feature is not available The Community Edition includes online help files and PDF guides available on the ERwin Bookshelf which is accessible from the Start menu To view PDF files you must download and install the Adobe Reader from the Adobe website if it is not already installed on your computer Standard Edition CA ERwin Data Modeler Standard Edition provides all the data modeling features used by Data Architects Data Administrators and Application Administrators but does not include any workgroup modeling capabilities You can use this edition as a standalone modeling tool and as a Workgroup Edition client that can ac
31. fy Use of Foreign Characters With Microsoft SQL Server 2005 Specify Use of Foreign Characters With Microsoft SQL Server 2005 For Microsoft SQL Server 2005 and 2008 modify your registry settings to have certain foreign language characters in your models recognized Follow these steps 1 2 Click Run on the Start menu Enter regedit The Registry Editor opens Verify or add the following registry entry HKEY_LOCAL_MACHINE SOFTWARE Microsoft MSSQLServer Client DB Lib AutoAnsiToOem ON UselntlSettings ON Click File Exit Your configuration is set to recognize foreign language characters in your models Specify Use of Foreign Characters With Microsoft SQL Server 2000 40 Release Notes For Microsoft SQL Server 2000 select specific settings in the Client Network Utility to have certain foreign language characters in your models recognized Follow these steps 1 Click Programs Microsoft SQL Server Client Network Utility on the Start menu The SQL Server Client Network Utility dialog opens Select the following check boxes on the DB Library Options tab m Automatic ANSI to OEM conversion m Use international settings Click OK Your configuration is set to recognize foreign language characters in your models Client Version Checking Client Version Checking When you connect a client such as CA ERwin Data Modeler to a mart database the software checks to verify that the client version is compati
32. ing the upgrade process The r8 x upgrade process includes the option to delete the Main Subject Area When the upgrade process completes the model opens in r8 x If this model contains other subject areas that you want to delete then for better model performance we recommend that you first save the open model and close it Reopen the model and then delete any subject areas that you want to remove Diagram layout Due to the changes in the diagram layout technology the conversion of models from r7 x to r8 x may not preserve the exact layout used in r7 x Release Numbering Scheme in CA ERwin Data Modeler Release Numbering Scheme in CA ERwin Data Modeler Effective with r8 the release of this product is displayed in the About CA ERwin Data Modeler dialog using the following release numbering scheme About CA ERwin Data Modeler Ca ER technologies CA ERwin Data Modeler Standard Edition Release 8 2 09 3685 Service Pack 2 Copyright 2014 CA All rights reserved The first number always indicates the main GA release the second number indicates the service pack number of the main release the third number indicates the patch number of the main release or service pack or both and the fourth number indicates the build number of the product For example the preceding illustration indicates that the product level is r8 Build 3685 The release 8 2 9 3685 in this dialog indicates r8 Service Pack 2 Patch Release 9 Build
33. ip through another version of the product and use Complete Compare to compare the differences between the models Due to the new changes and features in r8 the models will be different use reports to detect and work with model differences Model Display in the Difference Reconciliation Dialog Model Display in the Difference Reconciliation Dialog In a workgroup modeling environment two users may check out and make changes to the same model The first user may make changes to the model and save the changes to the mart When the second modeler makes changes and saves them to the mart the Difference Reconciliation dialog is displayed You use features in this dialog to view the differences on the object level the more detailed property level or search the text of the comparison lists Note In the Difference Reconciliation dialog the model in the left pane is the current model that you are checking in to the mart The model in the right pane is the version of the model already in the mart Uninstalling CA ERwin Data Modeler Workgroup Edition You can use the Windows uninstall utility to uninstall CA ERwin Data Modeler However when you uninstall CA ERwin Data Modeler in a workgroup environment the mart database remains intact To remove the database from your computer delete the mart database first and then uninstall CA ERwin Data Modeler Chapter 6 General Considerations for Using CA ERwin Data Modeler Workgroup Edition 47 Chapter 7
34. lement design decisions such as partitioning tables However because of the limitation to 25 entities tables per model some transformation operations may not be possible For example if you are near the limit of 25 tables and choose to partition a table you may surpass the table limit and the transformation operation will not complete The Advisories Pane on the main workplace window reports a message reminding you that the intended action did not complete because of the object creation limit Limited Database Support Support is included for modeling using the following databases m Oracle 10 x 11 x m SQL Server 2005 2008 m DB2LUW 9 1 9 5 and 9 7 m MySQL 5 x using ODBC m ODBC 2 0 3 0 m Sybase 12 5 15 Limited Access to Metadata Integration MITI Bridges Support is limited to the following Metadata Integration MITI Bridges for import Export using Metadata Integration MITI Bridges is not supported m Sybase PowerDesigner OOM 9 x to 15 x using UML XMI m Sybase PowerDesigner CDM 6 x m Sybase PowerDesigner CDM 7 5 to 15 x m Sybase PowerDesigner PDM 6 1 x m Sybase PowerDesigner 7 5 to 15 x m Embarcadero ER Studio m Embarcadero ER Studio using DM1 m OMG CWM 1 x XMI 1 x m OMG UML 1 x XMI 1 x Note If the file you import has more than 25 tables the Community Edition imports only the first 25 tables Chapter 1 CA ERwin Data Modeler Editions 11 Standard Edition Documentation Other limitations o
35. must use a supported DBMS as your host server The following host DBMSs are supported by r8 2 m Oracle 10x 11x m SQL Server 2000 2005 2008 m Sybase 12 5 15 Chapter 4 Installation Considerations for CA ERwin Data Modeler Workgroup Edition Review the following installation considerations before installing the product For more information about the installation process for a workgroup environment see the CA ERwin Data Modeler Workgroup Edition Implementation Guide This section contains the following topics Microsoft SQL Server 2005 Permissions see page 39 Specify Use of Foreign Characters With Microsoft SQL Server 2005 see page 40 Specify Use of Foreign Characters With Microsoft SQL Server 2000 see page 40 Client Version Checking see page 41 Microsoft SQL Server 2005 Permissions For SQL Server 2000 you only need to have public assigned to save to the mart However when the repository is on a SQL Server 2005 instance you need to have the bulkadmin permission designated as well The ability to do bulk inserts which was permitted by public previously is no longer part of the public permission You must explicitly define this permission or when you attempt to save a model to a new mart instance created using a SQL Server 2005 database an error You do not have permission to use the bulk load statement is returned Chapter 4 Installation Considerations for CA ERwin Data Modeler Workgroup Edition 39 Speci
36. n the same machine as the database server m Intel Pentium 4 or equivalent supported by the Host DBMS m 2GBdisk space 2 GB RAM more recommended for large models m DVD readable device only if installing from DVD media CA ERwin Data Modeler Workgroup Edition Requirements DBMS Requirements Before you install CA ERwin Data Modeler r8 2 to use in a workgroup environment ensure you are using a supported DBMS as your host server r8 2 supports the following host DBMSs m Oracle 10g 11g m SQL Server 2000 2005 2008 m Sybase 12 x 15 To create update or delete a mart in CA ERwin Data Modeler Workgroup Edition you must have the following database rights m For Microsoft SQL Server 2000 2005 2008 you must be the database owner dbo Notes m The dbo is no longer required to have the sysadmin role m The SQL Server 2005 2008 TRUSTWORTHY database property is no longer required for the mart After you install this product you can optionally reset this property to OFF m For Oracle you must be the database schema owner and have the DBA role Before you can install the mart on the server you must verify that the DBMS environment is prepared for the installation and that the server system requirements meet at least the minimum specifications The administrator of the DBMS must also set up user permissions for the mart Note The dbo role for Microsoft SQL Server or Sybase is necessary only during the installation or upgrade
37. ntation updates that have been made since CA ERwin Data Modeler release 8 1 CA ERwin Data Modeler Editions see page 15 This chapter describes the new edition CA ERwin Data Modeler for Microsoft SQL Azure see page 15 that is enabled by the addition of SQL Azure support New Features and Enhancements This chapter describes the new features enhancements and changes implemented for r8 2 Supported Target Server Databases see page 35 SQL Azure using the SQL Azure extension has been added to the list of target databases supported by CA ERwin Data Modeler Documentation Formats and Deliverables Updated to include the addition of the Installation Guide Fixed Issues Updated with the issues fixed for CA ERwin Data Modeler Service Pack 8 2 9 Contents Chapter 1 CA ERwin Data Modeler Editions 9 C mmunity Editio PL S 10 Standardi EAI OM E 12 Workgroup Editio ERA REEL ERR NER 13 IN AVIS eiusdem 14 CA ERwin Data Modeler for Microsoft SQL AZUreC ccccsssccecesssececsecceceeseeeecseauececeeneeceesueeecseaaececeeaeeceeaaeeceeaeeeseenaeess 15 Chapter 2 New Features and Enhancements 17 Licensing Dialog Enhancements rnern aeaa aaan aa aT ENE EEEE EEEE TEENE EEEa TE aE 18 Merge Alter Table Statements for DB2 LUW esccccesssreeceeneececeeeeeceesueeeceeaeececeeeeceeueeeceeeeeeeceeeeceeaaeeesseaaeeeeeeeeecee
38. ocal license Is stored on your local computer This license lets you use CA ERwin Data Modeler only from your computer Concurrent license Locks to your License Server With this license you can access CA ERwin Data Modeler from any computer that is in the same network This license is checked out from the License Server You can have Local and Concurrent licenses for CA ERwin Data Modeler Standard and Workgroup Editions A local license is ideal when a single user uses CA ERwin Data Modeler and a concurrent license is ideal when multiple users in a network domain use the product If you are using the concurrent licensing model the licenses are stored on a License Server You can install the License Server when you install CA ERwin Data Modeler For more information about how to install the License Server see the nstallation Guide Chapter 2 New Features and Enhancements 25 Licensing Enhancements Connecting to SQL Azure Consider the following if your target server is SQL Azure m To connect to the SQL Azure database using the logins you create you must first grant each login database level permissions using the CREATE USER command m Because some tools implement tabular data stream TDS differently you may need to append the SQL Azure server name to the login in the connection string using the lt login gt lt server gt notation In this case separate the login and the SQL Azure server name with the at symbol
39. on of CA ERwin Data Modeler you are using not all features may be enabled for use For more information about the differences between versions click one of the Edition links Chapter 1 CA ERwin Data Modeler Editions 9 Community Edition Community Edition 10 Release Notes The Community Edition of CA ERwin Data Modeler includes a limited number of features from the main product and is designed to help Data Architects learn data modeling techniques create simple data models and learn about the design and maintenance of a production database Most of the basic features of CA ERwin Data Modeler are available with limited access to the following features 25 Entities Tables Per Model You can reverse engineer import using Metadata Integration MITI bridges or create up to 25 entities tables per model There is no restriction on the number of views you Can create If you attempt to reverse engineer a script or database with more than 25 tables or attempt to open a model with more than 25 tables a warning message displays reminding you of the object creation limitation in the Community Edition For Oracle and SQL Server the reverse engineer process stops after creating 25 tables in the new model For other databases a warning message displays stating that the import feature is disabled Note Some operations that include the creation of temporary tables may also result in exceeding the allowed table limit For example if yo
40. opics SQL 1105 Error see page 51 Model and Version Name Limit on Oracle see page 51 Editing UDP Values in the Bulk Editor see page 52 Reverse Engineer from Database see page 52 CA ERwin Data Modeler r8 and Crystal Reports Shell Installation see page 52 CA ERwin Data Modeler r8 Silent Installation see page 53 Upgrading CA ERwin Data Modeler on Windows Server 2003 see page 53 Administrative Privileges Required for Export Import and Query Tool Options see page 53 Crystal Reports Developer menu item in CA ERwin DM and Edit Design in CA ERwin Report Viewer are disabled see page 54 SQL 1105 Error When you are upgrading to CA ERwin Data Modeler r8 on Microsoft SQL in a workgroup environment during the mart conversion process you may get the message Sql 1105 if you run out of free hard disk space during the process Stop the conversion process and either free or add hard disk space You should delete the already created r8 tables and then re attempt the conversion Model and Version Name Limit on Oracle In a workgroup environment when you save a model to an Oracle mart the model name must be less than 130 characters If you exceed the 130 character limit the model will not save Because the version name is derived from the model name for example ModelName version number by UserName on lt VersionCreateDate gt you should use model names considerably less than 130 characters in length to a
41. orted in CA ERwin Data Modeler r8 2 DB2 for i 5 x 6 x m DB2 LUW 9 1 9 5 9 7 m DB2 z0S 8 1 9 1 m Informix 9 x 10 x 11 x m MySql 5 x m ODBC Generic 2 0 3 0 m Oracle 10x 11x m Progress 9 x 10 x m SAS stabilized support m SQL Azure using the SQL Azure Extension m SQLServer 2000 2005 2008 m Sybase 12 5 15 m Sybase IQ 12 x m Teradata 2 6 12 13 Chapter 3 System Information 35 CA ERwin Data Modeler Workgroup Edition Requirements CA ERwin Data Modeler Workgroup Edition Requirements If you plan to use CA ERwin Data Modeler Workgroup Edition review the following requirements to ensure your workgroup environment is set up properly Administrator Server System Requirements 36 Release Notes Verify that the machine where the software the administrator s workstation or file server for administrative files is installed meets the minimum requirements summarized below The disk space required for the administrative files used to create and manage the database is separate from the disk space required to accommodate models on the server where the database is located Greater CPU speed and more RAM and disk space result in better performance Important In addition to being licensed for the Workgroup Edition the administrator s workstation must also contain the Initializer license in order to perform administrative tasks on the mart Note While not recommended the software can be installed o
42. r model eliminating the need to enter objects manually or depend on reverse engineering Binding of model templates can occur at any time necessary including during model creation or after the model is created Creating a model template lets you create objects according to company or department standards so that object names are consistent across all data models Any changes made to the model template are reflected in the models that use it Enhancements for Diagrams Model template functionality includes the following features Bind unbind and rebind model template To use a model template for a model you bind the model template to the model At any time you can unbind or remove the model template Whenever you open a model with a bound model template confirm whether to synchronize any model template changes with the objects used in the model Detection of model template changes Whenever you open a model with a bound model template confirm whether to synchronize any model template changes with the objects used in the model You can also refresh your model with any model template changes at any time using the Refresh Template option Filtering of template objects Filters the object display in the Model Template dialog Filtering the objects to create a shorter list makes it easier for you to define the model objects that you want in your template Importing new template objects When you change a model template or want to incl
43. ration Bridges Updated Export Bridges Added Removed Support has been added for the following MIMB export bridges CA Gen Composite Beta IBM DB2 Cube Views IBM InfoSphere Data Architect IDA IBM Rational System Architect SA 10 4 to 11 x Encyclopedia IBM Rational System Architect SA 7 1 to 11 x File Meta Integration Repository MIR Application Server Microsoft Office Excel Java Alpha Microsoft SQL Server Analysis Services Repository Oracle Data Integrator ODI 11g Beta bridge Oracle Warehouse Builder OWB Oracle Warehouse Builder OWB via CWM XMI SAP BusinessObjects Data Integrator BODI SAP NetWeaver Master Data Management MDM Beta bridge Chapter 2 New Features and Enhancements 23 Metadata Integration Bridges Updated 24 Release Notes Support has been removed for the following MIMB export bridges m Adaptive Metadata Manager via MIR XMI m CA ERwin 3 x ERX m CA Gen 4 1a to 7 6 m HP Knightsbridge CDMA BM InfoSphere Data Architect m BM InfoSphere DataStage m BM InfoSphere Warehouse Cubing Services for OLAP m BM Rational System Architect 10 4 to 11 x Encyclopedia m BM Rational System Architect 7 1 to 11 x File m Informatica Metadata Manager m Informatica Metadata Manager via MIR XMI m Meta Integration Business Rules m Meta Integration Repository MIR Profiling XML m Meta Integration Repository MIR XMI Business Glossary m Meta Integration Repository MIR XM
44. rting and Publication Offers reporting and printing capabilities that generate in a variety of formats including HTML and PDF CA ERwin Data Modeler for Microsoft SQL Azure CA ERwin Data Modeler for Microsoft SQL Azure If you plan to use SQL Azure as your target server with CA ERwin Data Modeler verify that your SQL Azure license is present either on the computer on which you plan to run CA ERwin Data Modeler or on the License Server This means if you are using a local CA ERwin DM license then you must have the license for SQL Azure locally If you are using a License Server to get the CA ERwin DM license then you must have the license for SQL Azure on the License Server If you do not have a SQL Azure license you cannot select SQL Azure as a target server This requirement is effective for all editions of CA ERwin Data Modeler including Community Edition The following tables compare the differences in CA ERwin Data Modeler functionality depending on whether you are using the SQL Azure extension Community Edition with SQL Azure Extension Limited database support however SQL Azure is available as a target server for new models and deriving models SQL Azure models can be opened directly Opening a file in XML format is supported Alter Script in Forward Engineering is enabled only for SQL Azure models No entity table volume limitation for SQL Azure models only Notes m You can reverse engineer from any of the supported target ser
45. s Server 2003 KB925336 from Microsoft Administrative Priviledes Required for Export Import and Query Tool Options If you log on to the computer on which you are running CA ERwin DM as a user that does not have administrator privileges the following options may not work properly m Exportor import objects using MITI bridges File Export or Import menu option m ODBC connection ODBC connection to erwin fails This functionality affects Query Tool and Crystal Reports The workaround is that you must log in using an account that has administrator privileges to use the Export Import and Query Tool options and Crystal Reports Chapter 8 Known Issues 53 Crystal Reports Developer menu item in CA ERwin DM and Edit Design in CA ERwin Report Viewer are disabled Crystal Reports Developer menu item in CA ERwin DM and Edit Design in CA ERwin Report Viewer are disabled 54 Release Notes Suppose that you have an existing installation of CA ERwin Data Modeler release 8 and SAP Crystal Reports 2011 If you then install CA ERwin Data Modeler release 9 uninstall SAP Crystal Reports 2011 and install Crystal Reports 2008 the Crystal Reports Developer menu item under the Tools menu is disabled in CA ERwin Data Modeler release 9 Further in CA ERwin Data Modeler release 8 the Crystal Reports Developer menu item under the Tools menu is disabled Workaround 1 Open Registry Editor and delete the following keys m For 64 bit Windows OS delete
46. specific owner the application fetched objects for the current owner Issue No 21581888 1 Problem No 12740 CC ALTER SCRIPT DOES NOT GENERATE DDL FOR IMPORTED TABLE In CA ERwin Data Modeler release 8 DDL scripts could not be generated for a specific SQL Server model When a new table was created in a new model and the model was compared the table was shown However then the DDL script was generated it did not generate anything Issue No 21550103 1 Problem No 12607 NAME HARDENING CHANGE COL ORDER In a specific model in CA ERwin Data Modeler release 8 2 5 when the entity and attribute names were hardened the column order changed in Column Order and Physical Order Issue No 21646921 1 Problem No 12419 CAN T CLICK PRINT BUTTON WHEN CHANGE ICONS FROM 100 TO 125 CA ERwin Data Modeler release 8 2 8 when the display in Windows 7 was changed from Smaller 100 default to Medium 125 and the Print option in a model was selected the full printer dialog was not displayed The Print button was not visible in the dialog Issue No 21531633 2 Problem No 12555 SA DISPLAY SHOWS NO OBJECTS When a specific CA ERwin Data Modeler release 7 3 model was opened in release 8 2 8 the subject areas did not display any ER diagrams or the objects in those diagrams The message The Subject Area sa name gt has no diagrmas Nothing to show appeared The Model Explorer did not display any members for the subject area Issue No 21578003 1
47. ss the CA Support online registration site to register for product support Accessing Technical Support For your convenience CA Technologies provides easy access to One Stop support for all editions of CA ERwin Data Modeler and includes the following m Online and telephone contact information for technical assistance and customer services m Information about user communities and forums m Product and documentation downloads m CASupport policies and guidelines m Other helpful resources appropriate for your product For information about other Home Office Small Business and Enterprise CA Technologies products visit http ca com support Provide Feedback If you have comments or questions about CA Technologies product documentation you can send a message to techpubs ca com If you would like to provide feedback about CA Technologies product documentation complete our short customer survey which is also available on the CA Support website found at http ca com docs CA ERwin Data Modeler News and Events Visit www erwin com to get up to date news announcements and events View video demos and read up on customer success stories and articles by industry experts Documentation Changes This Release Notes document is cumulative it is updated during the Patch and Service Pack releases Information in most sections of this document remains the same unless specified here The following list summarizes the docume
48. story of the affected model objects allowing you to select which changes to apply to the model repository Version management Lets Data Architects store access and analyze the history of a model and the changes made to it lock down specific versions run difference reports between versions and seamlessly roll back models to previous states as required Concurrent model access with optional model locking Allows multiple users to concurrently work on a given model without compromising the integration and integrity of their parallel efforts Sub modeling support Provides a focused view that helps individual modelers reduce the system resources required to upload and download during model check in and check out The administrator installs the program and initializes the database on the DBMS server The administrator also has the responsibility of setting up the library structure in which models are organized and assigning security profiles to users Administration overhead is relatively low and proportional to the number and activity level of the users After a model is saved to the database control of who can work on the model and how changes are saved to the model is handled by security making it possible for workgroups to work on large models without confusion CA ERwin Data Modeler Workgroup Edition supports many security and administrative features related to its multiuser capabilities and the client server environment in which it op
49. t Meta Integration Model Bridge MIMB version 7 04 from Meta Integration Technology Inc You can access the bridges when you click Import From External Format or Export To External Format on the File menu The full list of supported import and export bridges is documented in Appendix B of the CA ERwin Data Modeler Implementation Guide This guide is available on the ERwin Bookshelf which is accessible from the Start menu Chapter 2 New Features and Enhancements 19 Metadata Integration Bridges Updated Import Bridges Added Removed 20 Release Notes Support has been added for the following MIMB import bridges CA Component Modeler 3 52 ParadigmPlus CA Component Modeler 4 x via UML 1 x XMI CA COOL BusinessTeam GroundWorks 2 2 1 CA COOL DBA Terrain for DB2 5 3 2 CA COOL Xtras Mapper TerrainMap for DB2 CA ERwin 3 x ERX CA ERwin 4 x Data Modeler CA Gen CA Repository for Distributed Systems CA Repository for z OS COBOL Copybook Flat Files Database via JDBC Database via ODBC Embarcadero Describe via UML 1 x XMI Embarcadero ER Studio Business Architect via DM1 Embarcadero ER Studio Data Architect Embarcadero ER Studio Repository EMC ProActivity 3 x amp 4 0 Gentleware Poseidon via UML 1 x XMI Grandite Silverrun RDM 2 4 4 to 2 8 6 IBM Cognos BI Reporting Content Manager Packages IBM Cognos BI Reporting Content Manager QueryStudio IBM Cognos BI Reporting Content Manager ReportStudio
50. t Server dialog Mart access is disabled for SQL Azure models 16 Release Notes Standard Edition with SQL Azure Extension SQL Azure is available as a target server for new models and deriving models SQL Azure models can be opened directly SQL Azure is available for selection in the CA ERwin Data Modeler Target Server dialog Workgroup Edition with SQL Azure Extension SQL Azure is available as a target server for new models and deriving models SQL Azure models can be opened directly SQL Azure is available for selection in the CA ERwin Data Modeler Target Server dialog Mart access is enabled for SQL Azure models Chapter 2 New Features and Enhancements This section of the Release Notes for CA ERwin Data Modeler documents new features and enhancements from CA ERwin Data Modeler 8 2 onward This section contains the following topics Licensing Dialog Enhancement see page 18 Merge Alter Table Statements for DB2 LUW see page 19 Metadata Integration Bridges Updated see page 19 Copy and Paste Theme see page 25 Licensing Enhancements see page 25 Database Support Update see page 27 Publishing CA ERwin Data Modeler Models to a Web Portal see page 28 Model Templates see page 28 Enhancements for Diagrams see page 29 Chapter 2 New Features and Enhancements 17 Licensing Dialog Enhancement Licensing Dialog Enhancement 18 Release Notes When you launch CA ERwin Data Modeler for th
51. tion 52 Release Notes If the operating system of the machine on which you want to install CA ERwin Data Modeler r8 and Crystal Reports is either Microsoft Windows Server 2008 or Microsoft Windows Server 2008 SP1 you may encounter the following error C Users Administrator Desktop DMCRShell_OneClick exe x x C Users Administrator Desktop DMCRShell_OneClick exe is not a valid Win32 application CA ERwin Data Modeler r8 Silent Installation If you receive this error the installation will not continue You can perform one of the following to resolve this problem m Upgrade to Microsoft Windows Server 2008 SP2 m Install CA ERwin Data Modeler r8 and Crystal Reports Shell separately by downloading each application s individual installation program m Install CA ERwin Data Modeler r8 and then run the Crystal Reports installation from the CA ERwin Data Modeler r8 DVD CA ERwin Data Modeler r8 Silent Installation CA ERwin Data Modeler r8 requires NET 3 5 to be installed on your system If you do not have it installed the CA ERwin Data Modeler installation will attempt to install it In this case we advise against using a silent install Upgrading CA ERwin Data Modeler on Windows Server 2003 While upgrading CA ERwin Data Modeler on the Windows Server 2003 platform you may receive a digital signature policy error during the r8 1 installation This is an operating system error that can be resolved by applying the update for Window
52. u reverse engineer a DB2 LUW script that contains 25 tables and a materialized view the temporary table used to create the materialized view will cause you to exceed the allowed table limit for the model Read Only Complete Compare You can use Complete Compare features to evaluate and compare models but you cannot commit changes you make in the Complete Compare wizard to the models you compare The Finish button is disabled in the Resolve Differences dialog In addition demand loading of databases and Alter Script generation are not supported Note If you are working with a database as part of the compare process only the first 25 tables are reverse engineered to the model used during the compare This may result in problems in the Complete Compare Resolve Differences dialog where objects and properties between the models will not match To avoid problems work with a database that has fewer than 25 tables Save As You can save your models in the native erwin format or as a template erwin tmpl Save As XML ER1 and ERT is not supported Community Edition File Open You can open a model in erwin or erwin_tmpl format and a SQL DDL file in the format sql ers or ddl Print a Model Support for printing models is included in the Community Edition although the output includes a watermark Working with Transformations in the Community Edition You can work with transformations in the Community Edition to imp
53. ude objects in a model template you previously did not include refresh the model template Synchronization of model objects Any changes you make to a model template are synchronized with the models that use the template in the Model Template Synchronization Wizard You can select the Synchronize on Model Load option so that when a model is opened you can review model template changes Template removal You can delete model templates Any objects brought in to a model by the template can remain in the model or you can remove them when the template is unbound If you keep the objects any changes made to the objects are performed directly in the model because the template no longer exists Reporting Use the Query Tool to report on model template objects Enhancements for Diagrams The following enhancements have been made to diagrams m You can browse through a diagram horizontally or vertically by holding the middle button of the mouse m You can zoom in or zoom out a diagram by holding the Ctrl key and using the mouse wheel Ctrl scroll Chapter 2 New Features and Enhancements 29 Chapter 3 System Information Review the following system information before installing and using the product This section contains the following topics Upgrading CA ERwin Data Modeler from r7 x to r8 x see page 32 Release Numbering Scheme in CA ERwin Data Modeler see page 33 Operating System Support see page 34 System Requir
54. ver databases but when the reverse engineer process finishes switch to one of the available CE target server databases DB2 for LUW MySQL ODBC Generic Oracle SQL Azure SQL Server or Sybase If you attempt to reverse engineer more than 25 entities tables verify that your target server is SQL Azure If it is not then only the first 25 entities tables are converted and the rest are removed On demand loading and model saving during Complete Compare is enabled only for SQL Azure models Printing a SQL Azure model is supported and the output does not contain a watermark Data type standards are supported Only SQL Azure models can be saved in any of the available formats Access to marts workgroup modeling is not supported Full use of all available MITI import and export bridges Crystal Reports is supported Chapter 1 CA ERwin Data Modeler Editions 15 CA ERwin Data Modeler for Microsoft SQL Azure Standard Edition SQL Azure is not available as a target server for new models and deriving models Opening a SQL Azure model launches a dialog prompting you to select a different target server SQL Azure is not an option in the CA ERwin Data Modeler Target Server dialog Workgroup Edition SQL Azure is not available as a target server for new models and deriving models Opening a SQL Azure model launches a dialog prompting you to select a different target server SQL Azure is not an option in the CA ERwin Data Modeler Targe
55. void problems with saving a model version Chapter 8 Known Issues 51 Editing UDP Values in the Bulk Editor Editing UDP Values in the Bulk Editor You can only edit the UDP values of UDPs that use either the String or Number data type in the Bulk Editor Bulk editing of UDP values that use either the Date or List data type is not currently supported Editing of UDP values for UDPs that use Date or List is only supported using the User Defined Properties Logical or User Defined Properties Physical dialogs These dialogs are accessed by selecting User Defined Properties from the Model menu Reverse Engineer from Database There is a known limitation in CA ERwin Data Modeler r8 when you reverse engineer from a database and select the System Objects option in the Reverse Engineer Set Options dialog You may exceed the memory that CA ERwin Data Modeler requires to operate which can cause the application to end This is because the database you are attempting to reverse engineer is too large it contains very large amount of objects such as tables columns and views and is directly related to the amount of of data stored To avoid this issue we recommend using only the reverse engineer options required any objects that you do not need to reverse engineer should not be selected for this process and not selecting the System Objects option will help to alleviate this issue CA ERwin Data Modeler r8 and Crystal Reports Shell Installa
Download Pdf Manuals
Related Search