Back to Bookshelf

• Workgroup Edition Implementation and Administration Guide
• Legal Notices
• CA Technologies Product References
• Contact CA Technologies
• Documentation Changes
• Modeling in the Multiuser Environment
  • CA ERwin Data Modeler Workgroup Edition
  • Model Life Cycle Frameworks
    • Model-Driven Development Framework
    • System-Driven Model Framework
    • Informational Model Framework
• Install and Configure an Oracle Mart
  • How to Install and Configure an Oracle Mart
    • Mart Architecture
    • Install a Mart or Upgrade a Mart?
    • Review the Prerequisites for an Oracle Mart
    • Create the Mart Database and Perform the Additional Tasks
      • Oracle SQL Commands
    • Install CA ERwin Mart Server
      • Enable SSL for Tomcat
    • Use Mart Server as a Windows Service
    • Initialize an Oracle Mart
    • Log In to CA ERwin Mart Administrator and Configure Settings
  • How to Upgrade a Mart from r9.0.0 to r9.5.0
    • Review the Prerequisites
    • Upgrade the Mart Server
    • Configure the Mart Server
    • Restart the Mart Server Service
    • Log In to CA ERwin Mart Administrator
  • Change the Mart Database Server
  • Troubleshooting
    • Port out of range
    • Call failed on the server
    • Application Internal Error
    • ORA-12514 TNS listener does not currently know of service requested in connect descriptor
    • Mart already exists. Specify another database name
    • Initialize page is not loading in Internet Explorer
    • The Tomcat server is not starting properly. The Configure button is disabled.
    • A connection with the server could not be established
    • The server name or address could not be resolved
    • Invalid user ID or password
    • Error 12029
    • Unable to load the web page from my web browser
    • Test connection failed
    • Internet Explorer Redirects to a Different Link
• Install and Configure a SQL Server Mart
  • How to Install and Configure a SQL Server Mart
    • Mart Architecture
    • Install a Mart or Upgrade a Mart?
    • Review the Prerequisites for a SQL Server Mart
    • Create a SQL Server Database
      • Microsoft SQL Server 2005 Permissions
      • Specify Use of Foreign Characters With Microsoft SQL Server 2005
    • Install CA ERwin Mart Server
      • Enable SSL for Tomcat
    • Use Mart Server as a Windows Service
    • Initialize a SQL Server Mart
    • Log In to CA ERwin Mart Administrator and Configure Settings
  • How to Upgrade a Mart from r9.0.0 to r9.5.0
    • Review the Prerequisites
    • Upgrade the Mart Server
    • Configure the Mart Server
    • Restart the Mart Server Service
    • Log In to CA ERwin Mart Administrator
  • Change the Mart Database Server
  • Troubleshooting
    • Port out of range
    • Call failed on the server
    • Application Internal Error
    • Mart already exists. Specify another database name
    • Initialize page is not loading in Internet Explorer
    • The Tomcat server is not starting properly. The Configure button is disabled.
    • A connection with the server could not be established
    • The server name or address could not be resolved
    • Invalid user ID or password
    • Error 12029
    • Unable to load the web page from my web browser
    • Test connection failed
    • Internet Explorer Redirects to a Different Link
    • Chinese characters are replaced with question marks
• Install and Configure a Sybase Mart
  • How to Install and Configure a Sybase Mart
    • Mart Architecture
    • Install a Mart or Upgrade a Mart?
    • Review the Prerequisites for a Sybase Mart
    • Create a Sybase Database
      • Transact-SQL Commands
    • Install CA ERwin Mart Server
      • Enable SSL for Tomcat
    • Use Mart Server as a Windows Service
    • Initialize Mart
    • Initialize a Sybase Mart
    • Log In to CA ERwin Mart Administrator and Configure Settings
  • How to Upgrade a Mart from r9.0.0 to r9.5.0
    • Review the Prerequisites
    • Upgrade the Mart Server
    • Configure the Mart Server
    • Restart the Mart Server Service
    • Log In to CA ERwin Mart Administrator
  • Change the Mart Database Server
  • Troubleshooting
    • Port out of range
    • Call failed on the server
    • Application Internal Error
    • ORA-12514 TNS listener does not currently know of service requested in connect descriptor
    • Mart already exists. Specify another database name
    • Initialize page is not loading in Internet Explorer
    • The Tomcat server is not starting properly. The Configure button is disabled.
    • A connection with the server could not be established
    • The server name or address could not be resolved
    • Invalid user ID or password
    • Error 12029
    • Unable to load the web page from my web browser
    • Test connection failed
    • Internet Explorer Redirects to a Different Link
• Prepare to Use IIS with Mart
  • Configure IIS Web Server
  • Implement SSL for IIS
• How to Upgrade Mart Models
  • Review the Prerequisites
    • Paper Size Considerations When You Upgrade to This Release
    • Running CA ERwin DM on a 64-bit Operating System
  • Select the Working Directory
  • Enter the Source Mart Details
  • Enter the Destination Mart Details
  • Select the Data to Upgrade
  • Select Upgrade Options
  • Select Models
  • View the Upgrade Status
  • Log Files
  • Troubleshooting
    • Test Connection Failed--Source Mart
    • Your License does not Permit Connection to this Mart
    • Test Connection Failed--Destination Mart
    • Unable to Select Upgrade Models Check Box
• Administer Mart
  • Adding a User
    • Add a User
      • Mart Users
      • Best Practices to Add a Group User
    • Verify if an Existing Profile Suits the User
      • How Profiles Work
    • Create a Profile
    • Verify if the Required Library Exists
    • Create a Library
    • Assign Permissions to a User
    • Examples
  • Sessions
    • Terminate Inactive or Closed Sessions
  • Delete Mart
  • Catalog Management
    • Library Structure Planning
    • Library Structure Organization
    • Library Security Levels
    • Library Structure Considerations
    • Manage Catalogs
      • Lock a Catalog Entry
      • Lock Behavior
• CA ERwin Data Modeler Workgroup Edition Performance
  • Optimize the Performance
  • Reindex the Database
    • Run the Oracle DBMS Reindex Script
    • Troubleshooting the Reindexing Script
  • Run the Database Statistics
• Workgroup Modeling Reports
  • Generate a Global Report
  • Generate a Model Validation Report
  • Generate a Diagram Report
  • Generate a Model Lock Report
  • Generate a Report on Model Contents by Class
  • The Report Viewer
• Generate the Current Diagram Picture
• Microsoft SQL Server and Sybase Tuning Recommendations
  • Physical Tuning Parameters
    • Database Placement
    • Data Redundancy
  • Server-Level Tuning Parameters
  • Named Cache Configuration
  • Database Tuning Parameters
    • Transaction Log
    • Threshold Procedures
    • "trunc. log on chkpt" Option
  • Database and Log Sizing
  • How to Maintain an Efficient Database
    • DBCC Commands
• Oracle Tuning Recommendations
  • Recommended Disk Configurations
  • Database Configuration
    • Maximum Number of Processes
    • Shared Pool
    • Buffer Cache
    • Redo Log Files
    • Increase Space in Redo Logs
    • Redo Log Buffer
    • Checkpoints
  • Storage Parameters
    • Rollback Segments
    • Set Optimal Configuration for the Rollback Logs
    • Tablespaces
• Sample Files
  • Sample workers.properties File
  • Sample isapi_redirect.properties File
  • Sample isapi_redirect.reg File
  • Sample uniworkers.properties File
  • Sample uriworkermap.properties File