ERwin Data Modeler ODBC: How to Create a Custom Report

ERwin Data Modeler allows you to create custom reports using ODBC queries to interrogate the ERwin meta model. Queries can be run using the built in ODBC Query Tool, Microsoft Excel, or Business Objects' Crystal Reports which ships with ERwin. This video gives you examples of each.

Disclaimer: ERwin Data Modeler and its related products were formerly owned by CA Technologies, until the product was divested in March, 2016.

---

Closed Caption:

good wrong the
0
hello and welcome to how to create a
custom report
using r8 CA or when data modeler
ODBC our video will cover
how to create a custom report in the
following tools:
the ODBC query tool that is the built-in
query tool available within
re: CA or when data mahler Microsoft
Office Excel
and Business Objects Crystal Reports
seeger when Dave Moller re: implements
and ODBC interface
allow sequel base reporting or query
tools to retrieve information from the
product
you can report on the object some
properties in your models
the meta-data defining those objects and
properties
and the action log that records what
changes were made to the model during
the session
any ODBC compliant tool
can be used to communicate with this
component such as a bad did report
writer
spreadsheet program or ad hoc query tool
this includes Business Objects Crystal
Reports 2008
which is installed with CA or when Dave
Moller
you can also use the built-in query tool
that is available with NCAA or when Dale
mahler
as presently displayed on the screen the
model that you want a query against must
first be open in CA or when data mahler
here we have open the EMU V's model that
ships with
RA CA or when data mahler to navigate to
the ODBC query tool
go to the menu tools query tool
the query tool window comes up
we have circled in red the icon that
will allow you to connect to the ODBC
database
so we make we re guess a model that has
been loathe inter one
pressing that I com we'll connect you to
the ODBC database
this query returns all the entities and
attributes in the model
is the example query will be using in
this video
we have pasted into the query tool
a query that brings back all the
entities and attributes in the model
we run the query by pressing the execute
button
that is the arrow icon that has been
circled in red
the data from executing the query is
place since the results window
at the bottom we can now see the result
set as a CSV
comma separated values file in the
middle right
above the query tool we have circled the
save result set as CSV
the disk icon that allows us to see the
result set to a CSV file
having press the Save result set
as CSV bun we now save a result set as a
CSV file
to our local drive
week and then open the csv file
and display the result set in Microsoft
Excel
ODBC datasource
spreadsheet Microsoft Office Excel we
were now demonstrate how to query the
Irwin ODBC database
metamodel using Microsoft Office Excel
first launcher when RA
and open the model that you want to
query against using Microsoft Excel
sakin launch Microsoft Excel
third good the Data tab choose from
other sources
and then select Microsoft Query the
choose datasource window appears
the Irwin or eight current day the
source
represents the model that is presently
open and has the context NCAA
or Wendy temalar RA select the early one
current data source
d select the checkbox use the queer
wizard to create
any queries press OK Microsoft Query
opens
select the tables you need for your
query in our example
we selected table entity press Add
and then close the table and to the
appears in Microsoft Query
now press the sequel button to open the
sequel editor
the sequel window opens we paced in
their query that returns
all the entities and attributes in the
model we press OK
we get a message that the query can't be
represented graphically
continue anyway that is OK
we press OK to continue anyway the
result set displays a Microsoft Query
press the button to exit Microsoft Query
and return to Microsoft Excel your
return to Microsoft Excel
keep the default selection of table take
the cell where you want the day to be
placed
and press OK the result set appears in
Microsoft Excel
as a table
ODBC datasource report writers
Business Objects Crystal Reports her win
includes a copy of Crystal Reports
developer
to launch crystal go to start
programs Crystal Reports and launch
Crystal Reports
as displayed on the screen Crystal
Reports comes up in the wizard
choose report was ur that prompts the
database
expert or standard report creation was
ur
stain to report creation was our comes
up
expand create new connections
scroll down to locate the ODBC
datasource
expand the ODBC datasource
the data source selection window comes
up
select the datasource named Berwyn re:
current and press Finish
your place back into the standard
report creation wizard select at command
and then press the two right button to
move that into the selected tables
area
the air command to report window appears
we paced inner query that returns all up
the
entities and attributes in the model we
press OK
we're place back into the standard
report creation wizard
we press Finish Arkham and appears in
Crystal Reports
however that require some work to be
completed
to begin doing so we press the field
explore button to display the field
explore which is shown on the right
then the field explore appears on the
right
the field Explorer button has been
circled in red at the top
by expanding the command there we see
the database feels firmer query
that we can drag and drop onto our
report
wean express the Design tab is located
on the upper left
in this area you work with David
representations
not with the actual data itself into the
detail section
which is denoted with a capital D we
drag and drop the feels from our command
query
the detail section issues for the body
of the report
having moved our fields into the detail
section
and after adjusting the very series at
the report
we now press the Preview tab to get a
glimpse so what are finished report may
look like
and here we see our report preview
that contains are clear result in
Crystal Reports
within this video we covered
how to create a custom report using the
following tools:
the r8 CA or when data mahler
ODBC query tool Microsoft Office Excel
and Business Objects Crystal Reports
for more information on these topics and
more
please see your product documentation
also the website's
her when Doc com support .ca dot com
alternatively for vice and guidance you
may contact CA Technologies technical
support
for contact information depending upon
where you reside
please see the website her when dot com
support maintenance
thank you for viewing this presentation
please visit
kerwin dot com slash products
for more information about CA or when
Dave Moller