How erwin 4.1.4 21 Enhances Data Modeling Performance and Usability
What is erwin 4.1.4 21 and why you should use it
If you are looking for a powerful and reliable data modeling tool that can help you design, deploy and understand data sources to meet your business needs, then you should consider using erwin 4.1.4 21.
erwin 4.1.4 21
Introduction
In this article, we will explain what erwin Data Modeler is, what erwin 4.1.4 21 is, what are the benefits of using it, how to install and use it, and how to connect to Model Manager using Windows authentication.
What is erwin Data Modeler
erwin Data Modeler is an industry-leading enterprise data modeling software that enables you to create and maintain logical, physical and conceptual data models for various database platforms and data sources.
With erwin Data Modeler, you can:
Reduce complexity and improve data quality by standardizing and automating model design tasks.
Enhance business alignment and data governance by documenting and communicating data definitions, rules and policies.
Simplify data integration and migration by generating code and scripts for data structures and transformations.
Support agile development and DevOps processes by enabling collaboration and version control among data modelers and stakeholders.
What is erwin 4.1.4 21
erwin 4.1.4 21 is a version of erwin Data Modeler that was released in April 2021. It includes several features and enhancements that improve the performance, usability and functionality of the software.
Some of the new features and enhancements in erwin 4.1.4 21 are:
The ability to use Windows authentication mode for login validation when connecting to Model Manager using SQL Server or Oracle databases.
The addition of the Trusted Connection keyword to the list of Locator param keywords for use with the mmart type of provider for models stored in Model Manager.
The enhancement of the HasProperty method to return True or False depending on whether a property exists or not.
The update of the API Reference Guide with detailed information about the API.
The improvement of the ERwin SPY utility and the ERwin API sample client.
What are the benefits of using erwin 4.1.4 21
By using erwin 4.1.4 21, you can enjoy several benefits that can help you achieve your data modeling goals more efficiently and effectively.
Some of the benefits of using erwin 4.1.4 21 are:
You can leverage the power and security of Windows authentication mode when connecting to Model Manager, which eliminates the need for storing or entering SQL Server or Oracle usernames and passwords.
You can use the Trusted Connection keyword to specify whether you want to use Windows authentication mode or not when connecting to Model Manager using the mmart type of provider.
You can use the HasProperty method to check whether a property exists or not before accessing or modifying it, which can prevent errors and improve performance.
You can access the updated API Reference Guide that provides comprehensive information about the API, including examples, syntax, parameters, return values and error codes.
You can use the improved ERwin SPY utility and the ERwin API sample client to explore and manipulate the ERwin meta-model more easily and effectively.
How to install and use erwin 4.1.4 21
In this section, we will show you how to install and use erwin 4.1.4 21 on your computer.
Installation considerations
The installation procedure for erwin 4.1.4 21 is similar to previous versions of erwin Data Modeler. You can download the software from Quest Support website if you have a current support maintenance contract.
Before installing erwin 4.1.4 21, you should consider the following:
You need a valid license key to activate the software.
You need administrator privileges on your computer to run the setup program.
You need to close any running instances of ERwin Data Modeler before installing a new version.
You need to back up your existing models before upgrading from an older version.
You need to uninstall any previous versions of ERwin SPY utility or ERwin API sample client before installing new ones.
How to use ERwin SPY utility
The ERwin SPY utility is a tool that allows you to browse and modify the ERwin meta-model using a graphical user interface. You can use it to inspect or change any property or collection of any object in any model.
To use ERwin SPY utility, you need to install it as an optional component during the setup procedure for ERWIN Data Modeler by selecting the ERWIN SPY Utility check box. After installation, you can access it from the Samples\\ERWIN API subdirectory beneath the ERWIN installation directory.
To launch ERWIN SPY utility, double-click on ErSpy.exe file in the Samples\\ERWIN API subdirectory. You will see a window like this:
 To open a model in ERWIN SPY utility, click on File menu and select Open Model... option. You will see a dialog box like this:
 To connect to Model Manager using Windows authentication mode, select mmart as Provider Type, enter your server name as Locator Param Name, enter Yes as Locator Param Value for Trusted Connection keyword, leave User ID and Password fields blank, select your database name as Database Name, select your project name as Project Name, select your model name as Model Name, click OK button. You will see a window like this:
 To browse or modify any object in your model, select it from the tree view on the left pane. You will see its properties and collections on the right pane. You can change any property value by double-clicking on it or right-clicking on it and selecting Edit Value... option. You can add or remove any collection item by right-clicking on it and selecting Add Item... or Remove Item... option. You can also drag-and-drop items between collections or models. You can undo or redo any changes by clicking on Edit menu and selecting Undo or Redo option. You can save your changes by clicking on File menu and selecting Save option. You can close your model by clicking on File menu and selecting Close option.
How to use ERWIN API sample client
The ERWIN API sample client is a program that demonstrates how to use the ERWIN API in Visual Basic 6.0 applications. It consists of two projects: ErApiSampleClient.vbp and ErApiSampleClientEx.vbp.
The ErApiSampleClient.vbp project shows how to perform basic operations with models such as opening, closing, saving, creating new objects etc.