How to Jump Start Data Governance
In a little more than 30 minutes, discover the steps that you can take with ER/Studio to create an Enterprise Information Map and successfully jump start your data governance initiatives.
You will organize your models, create views of subject areas and processes and use a data dictionary to standardize names and bind models. You will catalog databases and derive data lineage. Finally you will selectively publish models and collaborate with a wider audience of business and data professionals.
First download a free trial copy of ER/Studio
It is highly recommended to download a free trial copy of ER/Studio so that you can follow-along with these examples. Download both trial versions, Client and Server, from our download page:
Use the model explorer to organize your projects and manage queries & reports. Add security information for fields and insert business definitions with an enterprise data dictionary.
Discover the ability to create a conceptual map of data sources and objects with an example that includes 3 subject areas: Lending, Online banking and Securities. Next view examples of process maps that you could replicate.
Use a naming standards template to update existing column names. Create and import attachments with PII information. Classify data with color codes based on security settings and other Data Governance settings using Custom Macros.
Reverse engineer databases using ER/Studio Data Architect and bind models to an existing enterprise data dictionary that is shared across models and across projects.
Catalog all your database sources to obtain lineage and impact analysis capabilities.
Use ER/Studio Repository to collaborate with other data professionals to complete mapping of Data Governance settings to models. Manage roles within the Repository Security Center by assigning specific permissions including the ability to bind to the Enterprise Data Dictionary.
Use the Universal Mapping feature to map related physical, logical and conceptual objects. Map generalized entities to its various manifestations across the enterprise. Also create sub models for greater reusability.
Derive data lineage from ETL mappings connecting different databases and having intermediate transformations.
Selectively publish models to a wider audience for feedback and collaboration. Administrator has complete control on which models will be available to be shown via portal.
Thanks for following along and exploring how you can jump start your data governance initiative. Contact your sales representative for more information. And if you haven't done so yet, try it yourself!