17-09-2021

Business challenges

  1. Quick Adjusting GrooveLock VISE-GRIP 2-Pack Tongue & Groove Plier Set. For pricing and availability. Hanson Forstner 14-Piece 3/8-in Woodboring Forstner Drill Bit Set.
  2. Quick Adjusting GrooveLock VISE-GRIP 2-Pack Tongue & Groove Plier Set. For pricing and availability. Hanson Forstner 14-Piece 3/8-in Woodboring Forstner Drill Bit Set.
  • Frequent business changes (business rules changes)
  • Regulatory changes
  • Increase in volume of services (i.e. integration of complementary services from partners)
  • The need to improve the level of service quality (speed, accuracy and consistency of information)
  • Speed of decision making based on reliable information
  • Business environment competitiveness

All Tools Tools by Trade New Tools Promotions & Events Find a Retailer VISE-GRIP® MARATHON® QUICK-GRIP® SPEEDBOR® STRAIT-LINE® MARPLES® Unibit® HANSON® Reference Guides Manuals Literature Guarantees Safety Warnings MSDS Sheets Ask IRWIN Press Center Glossary Testimonials Invention Submission Sign Up for Email Newsletter Account Access. This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.

Data challenges

  • Provide right data (WHAT?)
  • To the right person (WHO?)
  • At the right time (WHEN?)
  • In the right way (HOW?)
  • At the right location (WHERE?)
  • For the required activities (WHY?)

Domains of erwin usage

erwin has more than 25 years of enterprise architecture (EA) experience, helping organizations better understand, architect and transform the critical enterprise domains.
With erwin EA, you’ll know how business functions are aligned and structured, understand the information that powers business operations, and see where technology and innovation is lagging or can be used to drive competitive advantage.
erwin EA takes the guesswork out of business and IT transformation, and tames the inherent complexity of major IT initiatives like application rationalization, migrating to the cloud, and implementing Big Data.

Basic principles
  • Data are resource
    • Data are a resource with the highest value for whole business system and have to be accordingly managed.
  • Data are accessible
    • Users should have access to those data, that are necessary for them to do the tasks they have to do, regardless of organizational or functional distribution of data.
  • Common Business Glossary and common data definitions
    • Data (meta-data) should be defined in a consistent way throughout whole organizations for all business functions. Definitions of data meanings should be understandable to all users, unambiguous and accessible to all users
  • Data security
    • Data access should be properly secured so that un-authorized access should not happen.
Data architecture artifacts
  • Business Glossary
  • Conceptual models
  • Key success factors
  • Logical business models
  • Migration models
  • ETL models
  • Physical models.
  • DDL
  • DB catalogue..
Data Models Architecture – example
Sharing information between different type of Users
  • Some Users need desktop tools for development and analises of Data Models
  • Much more Users need understandable, consistent Data definitions accessible over web browsers and intuitive reports
Data Architecture of models for a DW development – example
Development process – example
Typical issues, reasons for integration requests
  • Different locations, different operating systems
  • Different data bases
  • Different applications
  • Different data structures
  • Multiple entries and multiple versions of same data, more versions of truth

TOO MANY data – TOO FEW relevant business INFORMATION

Erwin Tool
Challenges for integrations of different Data sources

How to ensure:

  • Unique naming and definitions of business terms
  • Harmonized security levels
  • Harmonized „code lists“ and classifications
  • Harmonized structures and data formats
  • Appropriate Data Quality

for the whole organization

  • Between ERP…CRM…BI and other Information Systems
MDM – “Master Data Management”

Methods, procedures and tools, for ensuring, that all applications, all business dashboards and reports for a specific organization, would be conceived on one, central version (“master”) of master business data

  • Examples of master data
    • Business partners, products, articles, services….
    • Main code-lists
  • Some of main reasons for poor quality of master data
    • No organization for Data Quality Governance
    • Separate maintenance of the same data in different applications
    • Non-consistent transferring, copying, amendments … of data between different applications

More versions of truth, which one is more reliable?

  • Should be in-line with general Quality policy
    • General guidelines : TQM/ISO9000/SixSigma…
    • Quality policy for a specific organization….
Basic condition for Critical Success Factors monitoring
  • Impact of Data Quality on the goals of businesses and success of performance
  • Some of the basic criteria for Data Quality
  • Correctness
  • Completeness
  • Consistency of data among various data sources (applications/DBs, reports, documents,…)
  • Consistency of data regarding time dimension
  • Relevance of data for business needs
  • Traceability between summary and transactional data
  • Timeliness
Iterative (spiral) approach
  • Iterations for a limited selected range
  • Transparency of development
  • Users are not aware of all requirements in advance
  • Speed of completion of all phases of each iteration (requirements-analysis-design-programming-testing-integration)
  • Possibility of re-definition of requirements for the next iteration after the completion of an iteration
  • Possibility of parallel activities of the different teams
Iterative (spiral) approach – key conditions for successful implementation
  • Iterativity can also be a problem …
    … as each iteration focuses on a different area (of data)!
  • Integration can be ensured only if all iterations originate from the same Data Model

AD consulting provides users with basic and advanced training, full help support for the usage of erwin and consultancy services for all domains of erwin usage.

erwin Data Modelererwin Web Portalerwin Web Portal Data Governance Editionerwin Safyr – for ERP
  • Design and creation of database structures using visual models
  • Documentation of basic business concepts and business rules
  • Coordination of business rules and technical documentation
  • Generating database structure directly from visual models for greater efficiency
  • Setting standards for reusability: models framework, domains, naming standards, data types …
  • Comparison of model and database with bi-directional syncing models, scripts and databases (comparison, selective update, and, if necessary, generating ALTER scripts)
  • Reports and publications can be created in PDF, HTML or text format for both diagrams and metadata specifications.
  • Integration and metadata exchange with data sources, BI tools, MDM Hubs, other tools for data modeling, ETL tools …

More about tool: http://erwin.com/products/data-modeler/standard-edition

  • Provides read-only access to data models with the ability to analyze the impact of changes
  • Reports and publications can be created in PDF, HTML or text format for both diagrams and metadata specifications

More about tool: http://erwin.com/products/data-modeler/navigator-edition

Erwin Tool Tutorial

  • Storing key data definitions in a central model repository
  • Promoting the re-use of objects for higher efficiency and higher quality
  • Simplifying of development through change management with conflict resolution and security

More about tool: http://erwin.com/products/data-modeler/workgroup-edition

The tool is intended to manage MS SQL Azure environments and its integration with other data sources, whether on-premise or in the Cloud.

More about tool: http://erwin.com/products/data-modeler/for-microsoft-sql-azure.

Benefits of Web Portal:
  • Establishing trust in information (as users have a detailed overview of sources of data for data warehouse and business reports).
  • Audit on sensitive data collection (where and how sensitive data is collected).
  • Support for agile application development
  • Enabling business analyst to use metadata to find out where to get information and what information can be obtained
Some characteristics of Web Portal:
  • Visualization with the possibility of drill-down to view the details of objects (definitions, comments, …)
  • Users can add comments to objects in the repository
  • Search in metadata using keywords
  • Links between metadata of different models (functionality of erwin Data Modeler Design Layer Architecture)
  • Mapping resources for data warehouse (erwin Data Modeler Source-To-Target mapping)

More about tool: http://erwin.com/content/products/ca-erwin-web-portal.pdf

Benefits of Web Portal Data Governance Edition:
  • Easier communication and a higher level of understanding among experts in various business areas using Business Glossary.
  • Integration of “closed” applications into Business Glossary.
  • Management of the life cycle of data and information
    • when the data is collected,
    • how long data is stored,
    • what we do after the expiry date,
    • reuse of data, if needed.
  • Easier integration of data from multiple sources …
Some characteristics of Web Portal Data Governance Edition (in addition to the full functionality of a Web Portal):
  • Business Glossary
  • Semantic mapping
  • Data mapping
  • Data documenting
  • Including of metadata from data servers
    • Directly from relational databases
    • Directly from the Big Data Hadoop distributions
  • Including of models from third party modeling tools

More about tool: http://erwin.com/resources/whitepapers/category/data-governance

Erwin Tool Download

  • Safyr connects to one of the following ERP solutions:
    • SAP ERP
    • JD Edwards
    • PeopleSoft
    • Seibel
    • Oracle (EBS)
    • Sales Force
  • Identifies metadata of the structure of the database including the relationships between tables
  • The result of reverse engineering in the model using Safyr => full E/R representation of database
Erwin Tool

Awards

  • #1 Global Market Share Leader in Data Modeling Tools, according to IDC
  • erwin Again Named “Best Data Modeling Solution” by Database Trends and Applications Magazine
  • #1 Most-Used Data Modeling Tool among data professionals, according to a recent DATAVERSITY survey.
  • “erwin Data Modeler should be evaluated by any company that is about to embark on a major application development initiative or an application portfolio overhaul” according to Ovum

Irwin Tool Bags

CA ERwin Data Modeler (or ERwin for short) is a data modeling and database design tool that is used to create conceptual, logical, and physical data models. ERwin can create the actual database from the physical model, and create different physical implementations from a single logical model. ERwin can also reverse-engineer existing databases into a data model diagram. ERwin works with many database management systems (DBMS). Outputs from the tool include entity-relationship (ER) diagrams and standard or custom reports on all objects in the design (tables, fields, relationships).

Irwin Tool Box

While users are charged for the full version of ERwin, there is a free 'Community Edition' available for students and others new to modeling to try the functionality of the software on a small dataset. The Community Edition has a limit on the number of objects (25) that can be created in the data model.