Credit Union Banks on erwin
Data Modeler by Quest®

CUSTOMER PROFILE®

First Tech Federal Credit Union is one of the nation’s premier credit unions,offering a full range of customized products and services, as well as individual
tools for financial wellness.

CompanyFirst Tech Federal
Credit Union

Industry

Financial ServicesCountry

United States ofAmerica

Employees 1,500
Websitefirsttechfed.com

CHALLENGE
Data modeling is the first step toensuring that an enterprise can use,
understand and trust its mission-criticalinformation. Like many organizations
today, compatibility and support forcloud-based databases are vital for thisfinancial services company, which uses
Snowflake as its cloud data warehouse.
The Snowflake Cloud Data Platform is asolution for data warehousing, data lakes,
data engineering, data science, dataapplication development and for securely
sharing and consuming shared data.

“The biggest lesson I have learned from using
erwin Data Modeler is that having the model
upfront and getting it approved helps reduce
project go-live time. It also definitely helps
business analysts and end-users to understandhow to write their Tableau reports.”
Srikanth AkavaramSenior Data Warehouse ArchitectFirst Tech Federal Credit Union

For First Tech Federal Credit Union,
collaboration is a critical part of theirculture. In order to become truly datadriven, First Tech promotes a cultureof working cross-functionally to enable
teams to collaboratively produce moreaccurate and higher-value results. As
such, the organization needed a data
modeling tool that was both compatible
with Snowflake and could ensurethat its data models were always up
and running and available for queryand reporting purposes for both its
business and IT users. Data modelinghas always been the best way tounderstand complex data sources andautomate design standards. All First
Tech users need visibility into the kindsof relationships that are being built in
the data warehouse in order to keep theentire organization on the same page.

SOLUTION“Overall, erwin Data
Modeler’s support
for Snowflake is very
good. It’s very stableand user-friendly andour data modelers live
day in and day out on
it. No complaints.”
Srikanth Akavaram

As a long-term erwin® Data Modeler byQuest® customer, First Tech knew thaterwin’s system-provided integration toautomate the design, analysis and deployment of Snowflake was vital functionality.
erwin Data Modeler is used for all projects
in the data warehouse as part of thecompany’s project life cycle. erwin Data
Modeler supports Snowflake as a target
database using Codemesh-based JDBC
support for Snowflake connectivity andenables customers to automate thecreation of Snowflake data models;engineer or generate code for Snowflake
database schemas; and compare, analyze,
and synchronize Snowflake models withthe databases they represent. It also
provides customers with the necessarydata modeling, code generation, datamapping, lineage, documentation andimpact analysis that’s foundational to asustainable data governance program.
First Tech generates the DDL scripts oferwin Data Modeler into Snowflake. Anychanges that happen after that also go
through erwin and then they make amaster copy of the erwin model. It is not
being used for reverse-engineering – only
from data model to the physical layer.
RESULTSerwin Data Modeler has become a critical
tool for this credit union in helping geteveryone on the same page and reducing
project go-live time. The product’s support
for Snowflake has been especially helpful
from a data modeling perspective. JDBC

and system-provided connectivity havehelped the organization simplify thepush mechanism. According to Srikanth
Akavaram, Senior Data Warehouse
Architect, “We have five to seven modelers
working on it at any moment in time. We
have not seen any scalability issues,
slowness, or that it is not supporting thatlevel of use, because it is all desktop
based.” erwin data models reducecomplexity, making it easier to design,
deploy and understand data sources tomeet business needs.
erwin Data Modeler also automates andstandardizes model design tasks, including
complex queries, to improve businessalignment, ensure data integrity and simplify
integration. Its automated schema engineeringand deployment accelerates and ensures
successful adoption of cloud platforms, likeSnowflake, including auto documenting
existing schema into reusable models.
SOLUTION
erwin® Data Modeler by Quest®
ABOUT QUESTQuest creates software solutions thatmake the benefits of new technology realin an increasingly complex IT landscape.
From database and systems management,
to Active Directory and Office 365
management, and cyber security resilience,
Quest helps customers solve their next
IT challenge now. Quest Software. Where
next meets now.

View more case studies at Quest.com/Customer-Stories
Quest, erwin data modeler by Quest and the Quest logo are trademarks and registered trademarks of Quest Software
Inc. For a complete list of Quest marks, visit www.quest.com/legal/trademark-information.aspx. All other trademarks
are property of their respective owners.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED.
CustomerStory-FirstTech-LP-67700