012 Erwin Data Modeler Query Tool

Query tool: is used to
a)connect to a database and perform queries
b)Connect to Erwin Model and perform queries on objects in model.

In this video, I have used the following queries.
I suggest you go through "CA Erwin Data Modeler ODBC Reporting Guide" by Erwin for understanding on the kinds of queries that we can run in Query tool.


/*List the Entity Name and table Name*/
select name,physical_name, tran(physical_name) from m0.entity

/*List the Attribute Name and Column Name*/
select name,physical_name, tran(physical_name) from m0.Attribute

/*List the Entity Name ,table Name, Attribute Name, Column Name, Data type*/
select E.Name as Logical_Ent_Name,
tran(E.Physical_name) as Table_nm,
A.name as Attrib_Name,
tran(a.physical_name) as Column_name,a.physical_data_type
from m0.entity E inner join m0.attribute A
on E.id@=A.Owner@

/*List the table Name,Column Name and Datatype*/
select
tran(E.Physical_name) as Table_nm,
tran(a.physical_name) as Column_name,a.physical_data_type
from m0.entity E inner join m0.attribute A
on E.id@=A.Owner@

---

Closed Caption:

welcome to Open Data Modeler Gordon in
this sir
video will be discussing about query to
in open using the credit to I can
connect to a particular database like in
here to contact us equal so database
and perform queries on the tables
came all our I disconnect from the
database here are
I can actually connect to the mornin
using over ODBC
case I conked to the mornin using the
second here
and sure could do much
black
so this stable and 2d
gimme information about all the entities
that are present in my modern
and water does physical names
okay the fiscal in country you would see
here is
in in in the Mac or format I V left left
function on it and get the fiscal name
for it all this information you can find
in a document called
Open Data Modeler will be busy putting
guide to confer to search in Google and
you get this document and
this document describes the structure of
the tables and how
joined a student tables to get the
relevant information ok
so what you seen here's is just a quick
way beyond and tea table
quotable
each identity and at two beautiful
after stay hope to do it with china and
get them where information from it
okay so I I'm running this gritty
on then to do table okay I the name
column here
is column each his mythological names
the physical name is the D for physical
name that
you're seeing here I'm harvard is in the
macro formats
and then I'm using a function called
Tran on the physical name again
and dysfunction kiss me display value of
x so
and logical name say
student have any undergoes
the macro conversion and then the naming
standards
its and as St udy and trance function
dissolved Oct and gives us the bud okay
as you can see here
as expected large condemn student and
the fiscal
macro physical in this macro I
applied to try and function and a guard
of a physical name of the table
similarly how a table called attribute
which has that to be name datatypes
and and then the physical inside again
in macro
which use a timer function again to come
look
so the physical name as you can see here
is
attribute name 17 play trance a function
on a detective give me the
physical name of two columns but do you
see here
even the logically mauled attributes
here is shown
n macros that's because be used
domains to create these attributes so
what i'll do is
add one more column that the transfer
function
and what this will do is it to actually
he was logical names of
to attributes like once the Mac result
on
you know executed sunau
I I would like to run as a board that I
just how
on tablename hi you know the column name
and the data type of the column
and that I can do by Chinese us
ok the van this book says
I'm joining the and tea table the
at a beautiful okay the ID column
Ind and T is a unique ID for each entity
and into act to get caught in that treat
table the owner column
is like a farm key from the entity table
you can think of it that way
are the owner ID this response to the
unique
ID pay off debt and T full rich
he held the columns okay so once I
joined on these two tables
I get what I'm looking for how does a
logical name: and the fiscal tablename
logical had to be to deflation
and the column name and the fiscal did
what I can do here
is for the active name in
as a applied to try and function here so
that we don't
seals macros so this is
what I was looking for and possibly what
I want to do is actually discuss
with the dollar per ordered EPA and I
just want to
a white even using the entire logical
and attribute sonatas of I just
get the information on the table name
ColumnName
and the datatype and now
how'd option of it saving the quitting
can 126 already
civil ready as excision
lights thought I can citizens as well
in the CSU and I can use this CSV file
open at 10 you know have a discussion on
the developer or the DB its
spoke a few
if you have any shoe actually connecting
to Coleman
ODBC what you can try doing
is actually launching open as an
administrator
and you can also Jim Baird reports
on up in more than on like what you're
seeing here
to win column name physical improbably
that relationship name
whatnot I using the Consumer Reports
guides December for me here because I'm
using the Community Edition
but it does alarming a dude on some
basically boats
so I'll just sum on that boats to show
you
how Accra suitable would look like
selectors
some cyclical came and egos did hundreds
and need to put I'm
if I V had as a glove open edition
I can launch a suitable start a book and
their
I can actually design made a board in
the sense that I
akin to say okay gimme just a table name
the column name
the physical data type and it wouldn't
it
edible and doesn't listen to post on the
phone as so
%uh in this video what he discusses how
to I mean
how to use credit on and
and Holika soda pore
would look like and hope you find this
information useful
thanks a lot for watching